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).

Definition

Namespace: PCBI_AVL_Check.Importer
Assembly: PCBI_BOMExpert (in PCBI_BOMExpert.dll) Version: 17.0.0.0 (17.0.0.0)
C#
public class GeneralExcelImporter : IAVLImportScript
Inheritance
Object    GeneralExcelImporter
Implements
IAVLImportScript

Constructors

GeneralExcelImporterInitializes a new instance of the GeneralExcelImporter class

Properties

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.

Methods

See Also