Click or drag to resize
XlsxReader Properties

The XlsxReader type exposes the following members.

Properties
  NameDescription
Public propertyColumnCount
Returns the count of columns found on the current record when looping with the ReadRecord method.
(Inherited from SpreadsheetReader.)
Public propertyCurrentRecord
Gets or sets the current record the reader is on for reading records in a loop using ReadRecord.
(Inherited from SpreadsheetReader.)
Public propertyCurrentSheet
Gets or sets the index of the current sheet in the workbook.
(Inherited from SpreadsheetReader.)
Public propertyHeaderCount
Returns the count of column headers found when HasHeaders is set to true.
(Inherited from SpreadsheetReader.)
Public propertyHeaders
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.
(Inherited from SpreadsheetReader.)
Public propertyItemInt32
Returns the current column value for a given column index.
(Inherited from ReaderBase.)
Public propertyItemString
Returns the column's value corresponding to the column header name.
(Inherited from SpreadsheetReader.)
Public propertyItemInt32, Int32
Returns the column value at the given record and column indexes.
(Inherited from SpreadsheetReader.)
Public propertyRecordCount
Returns the count of records found in the current sheet.
(Inherited from SpreadsheetReader.)
Public propertySettings
Has all the options that are able to be set that will affect the way records are parsed and accessed.
(Inherited from SpreadsheetReader.)
Public propertySheetCount
Returns the count of sheets found in the workbook.
(Inherited from SpreadsheetReader.)
Public propertySheetNames
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.
(Inherited from SpreadsheetReader.)
Public propertyTable
Returns all data for the current sheet as a DataTable of string columns.
(Inherited from SpreadsheetReader.)
Public propertyValues
Returns the columns values for the current record as a string array.
(Inherited from ReaderBase.)
Top
See Also