CsvLoadOptions Properties

The CsvLoadOptions type exposes the following members.

Public propertyCheckExcelRestriction
Whether check restriction of excel file when user modify cells related objects. For example, excel does not allow inputting string value longer than 32K. When you input a value longer than 32K, if this property is true, you will get an Exception. If this property is false, we will accept your input string value as the cell's value so that later you can output the complete string value for other file formats such as CSV. However, if you have set such kind of value that is invalid for excel file format, you should not save the workbook as excel file format later. Otherwise there may be unexpected error for the generated excel file.
(Inherited from SpreadsheetLoadOptions.)
Public propertyConvertDateTimeData
Indicates whether the string in the file is converted to date. Default is True.
Public propertyConvertNumericData
Indicates whether the string in the file is converted to numeric. Default is True.
Public propertyConvertRange
Convert specific range when converting to other than spreadsheet format. Example: "D1:F8".
(Inherited from SpreadsheetLoadOptions.)
Public propertyCultureInfo
Get or set the system culture info at the time file is loaded
(Inherited from SpreadsheetLoadOptions.)
Public propertyDefaultFont
Default font for spreadsheet document. The following font will be used if a font is missing.
(Inherited from SpreadsheetLoadOptions.)
Public propertyEncoding
Encoding. Default is Encoding.Default.
Public propertyFontSubstitutes
Substitute specific fonts when converting spreadsheet document.
(Inherited from SpreadsheetLoadOptions.)
Public propertyFormat
Input document file type.
(Inherited from SpreadsheetLoadOptions.)
Public propertyHasFormula
Indicates whether text is formula if it starts with "=".
Public propertyHideComments
Hide comments.
(Inherited from SpreadsheetLoadOptions.)
Public propertyIsMultiEncoded
True means the file contains several encodings.
Public propertyOnePagePerSheet
If OnePagePerSheet is true the content of the sheet will be converted to one page in the PDF document. Default value is true.
(Inherited from SpreadsheetLoadOptions.)
Public propertyOptimizePdfSize
If True and converting to Pdf the conversion is optimized for better file size than print quality.
(Inherited from SpreadsheetLoadOptions.)
Public propertyPassword
Set password to unprotect protected document.
(Inherited from SpreadsheetLoadOptions.)
Public propertySeparator
Delimiter of a Csv file.
Public propertySheets
Sheet name to convert
(Inherited from SpreadsheetLoadOptions.)
Public propertyShowGridLines
Show grid lines when converting Excel files.
(Inherited from SpreadsheetLoadOptions.)
Public propertyShowHiddenSheets
Show hidden sheets when converting Excel files.
(Inherited from SpreadsheetLoadOptions.)
Public propertySkipEmptyRowsAndColumns
Skips empty rows and columns when converting. Default is True.
(Inherited from SpreadsheetLoadOptions.)
See Also