Click or drag to resize
SpreadsheetReader Properties

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