Method | Description | |
---|---|---|
ExcelNPOIStorage ( |
Create a new ExcelStorage to work with the specified type
|
|
ExcelNPOIStorage ( |
Create a new ExcelStorage to work with the specified type
|
|
ExcelNPOIStorage ( |
Create a new ExcelStorage to work with the specified type
|
|
ExtractRecords ( ) : object[] |
Returns the records extracted from Excel file.
|
|
InsertRecords ( object records ) : void |
Insert all the records in the specified Excel File.
|
Method | Description | |
---|---|---|
CellAsString ( object row, object col ) : string |
Get the string value of a cell
|
Method | Description | |
---|---|---|
AddHeaderColumns ( int startCol, int rowNum ) : void | ||
CellAsString ( IRow row, int col ) : string | ||
CloseAndCleanUp ( ) : void | ||
ColumnsToValues ( object values ) : string | ||
CreateWorkbook ( string filename ) : void | ||
InitExcel ( ) : void | ||
OpenOrCreateWorkbook ( string filename ) : void | ||
OpenWorkbook ( string filename ) : void | ||
RowValues ( int rowNum, int startCol, int numberOfCols ) : object[] | ||
SaveWorkbook ( ) : void | ||
SaveWorkbook ( string filename ) : void | ||
WriteRowValues ( object values, int rowNum, int startCol ) : void |
protected CellAsString ( object row, object col ) : string | ||
row | object | Cell Row |
col | object | Cell Column |
return | string |
public ExcelNPOIStorage ( |
||
recordType | The type of records. | |
return | System |
public ExcelNPOIStorage ( |
||
recordType | The type of records. | |
startRow | int | The row of the first data cell. Begining in 1. |
startCol | int | The column of the first data cell. Begining in 1. |
return | System |
public ExcelNPOIStorage ( |
||
recordType | The type of records. | |
fileName | string | The file path to work with. |
startRow | int | The row of the first data cell. Begining in 1. |
startCol | int | The column of the first data cell. Begining in 1. |
return | System |
public InsertRecords ( object records ) : void | ||
records | object | The records to insert. |
return | void |