 | Nano |
Main namespace with all high-level classes and functions to create or read workbooks and worksheets
Classes| Class | Description | |
|---|---|---|
 | Address | Struct representing the cell address as column and row (zero based) |
| BasicFormulas | Class for handling of basic Excel formulas |
| Cell | Class representing a cell of a worksheet |
| CellAddressScope | Enum to define the scope of a passed address string (used in static context) |
| CellAddressType | Enum for the referencing style of the address |
| CellCellType | Enum defines the basic data types of a cell |
| Column | Class representing a column of a worksheet |
| ImportOptions | The import options define global rules to import worksheets. The options are mainly to override particular cell types (e.g. interpretation of dates as numbers) |
| ImportOptionsColumnType | Column types to enforce during the import |
| ImportOptionsGlobalType | Global conversion types to enforce during the import. All types other than will override defined Column types |
| Metadata | Class representing the meta data of a workbook |
| Range | Struct representing a cell range with a start and end address |
| Shortener | Class to provide access to the current worksheet with a shortened syntax. Note: The WS object can be null if the workbook was created without a worksheet. The object will be available as soon as the current worksheet is defined |
| Utils | General Utils class with static methods |
| Workbook | Class representing a workbook |
| Worksheet | Class representing a worksheet of a workbook |
| WorksheetCellDirection | Enum to define the direction when using AddNextCell method |
| WorksheetSheetProtectionValue | Enum to define the possible protection types when protecting a worksheet |
| WorksheetSheetViewType | Enum to define how a worksheet is displayed in the spreadsheet application (Excel) |
| WorksheetWorksheetPane | Enum to define the pane position or active pane in a slip worksheet |