| GeneralExcelImporter |
General excel importer for csv and xlsx files.
This implementation reads a user configured BOM/AVL table (wrapped by ImporterListView)
and converts each chosen line into an AVLEntry with references, description and a list of possible parts.
The importer supports several layout variants:
- Standard (separate MPN and Manufacturer columns)
- Separated (MPN + Manufacturer combined in one column using a separator character)
- MultiLayer (MPN/Manufacturer information may span multiple subsequent table rows for one logical component group)
- Combination of Separated + MultiLayer
Additionally ranges like R1-R5 or mixed forms (R1,2,3) are expanded into discrete references.
Duplicate entries (by part name) can be merged depending on the combineEntries flag (currently always true for meaningful AVL aggregation).
|