GeneralExcelImporter Class
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).
Namespace: PCBI_AVL_Check.ImporterAssembly: PCBI_BOMExpert (in PCBI_BOMExpert.dll) Version: 17.0.0.0 (17.0.0.0)
public class GeneralExcelImporter : IAVLImportScript
Public Class GeneralExcelImporter
Implements IAVLImportScript
public ref class GeneralExcelImporter : IAVLImportScript
type GeneralExcelImporter =
class
interface IAVLImportScript
end
- Inheritance
- Object GeneralExcelImporter
- Implements
- IAVLImportScript
| FileExtension |
Available file extensions for import dialog filtering.
Returned as a semicolon separated list for consumer code.
|
| Name |
Display name in selection drop down to identify this importer.
|