Public Instance Constructors
XlsxReader
|
Overloaded. Initializes a new instance of the XlsxReader class. |
Public Instance Properties
 ColumnCount (inherited from SpreadsheetReader) | Returns the count of columns found on the current record when looping with the ReadRecord method. |
| CurrentRecord (inherited from SpreadsheetReader) | Gets or sets the current record the reader is on for reading records in a loop using ReadRecord. |
| CurrentSheet (inherited from SpreadsheetReader) | Gets or sets the index of the current sheet in the workbook. |
| HeaderCount (inherited from SpreadsheetReader) | Returns the count of column headers found when HasHeaders is set to true. |
| Headers (inherited from SpreadsheetReader) | Returns the header values as a string array or sets the headers to allow columns to be accessed by name even if the current spreadsheet does not contain column headers. |
| Item (inherited from SpreadsheetReader) | Returns the column's value corresponding to the column header name. |
| Item (inherited from SpreadsheetReader) | Returns the column's value corresponding to the column header name. |
| RecordCount (inherited from SpreadsheetReader) | Returns the count of records found in the current sheet. |
| Settings (inherited from SpreadsheetReader) | Has all the options that are able to be set that will affect the way records are parsed and accessed. |
| SheetCount (inherited from SpreadsheetReader) | Returns the count of sheets found in the workbook. |
| SheetNames (inherited from SpreadsheetReader) | Returns the list of sheet names as a string array in the correct order. The array can then easily be bound to a combo box for example for sheet selection in a windows form. |
| Table (inherited from SpreadsheetReader) | Returns all data for the current sheet as a DataTable of string columns. |
| Values (inherited from ReaderBase) | Returns the columns values for the current record as a string array. |
Public Instance Methods
| Close (inherited from ReaderBase) | Closes and releases all related resources. |
| Equals (inherited from Object) | Determines whether the specified Object is equal to the current Object. |
| GetHashCode (inherited from Object) | Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table. |
| GetHeader (inherited from SpreadsheetReader) | Returns the column header value for a given columnIndex. |
| GetIndex (inherited from SpreadsheetReader) | Gets the corresponding column index for a given headerName. |
| GetSheetIndex (inherited from SpreadsheetReader) | Returns the index of the sheet with the given name. |
| GetSheetName (inherited from SpreadsheetReader) | Returns the name of the sheet at the given index. |
| GetType (inherited from Object) | Gets the Type of the current instance. |
| ReadRecord (inherited from SpreadsheetReader) | Advances the record cursor to the next record. |
| Reset (inherited from SpreadsheetReader) | Resets the position of the record cursor to the first record for use with the ReadRecord method. |
| ToString (inherited from Object) | Returns a String that represents the current Object. |
See Also
XlsxReader Class | DataStreams.Xlsx Namespace