| AllColumnsInOnePagePerSheet { get; set; } |
If AllColumnsInOnePagePerSheet is true, all column content of one sheet will output to only one page in result. The width of paper size of pagesetup will be invalid, and the other settings of pagesetup will still take effect. |
| AutoFitRows { get; set; } |
Autofits all rows when converting |
| CheckExcelRestriction { get; set; } |
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. |
| ClearBuiltInDocumentProperties { get; set; } |
Removes built-in metadata properties from the document. |
| ClearCustomDocumentProperties { get; set; } |
Removes custom metadata properties from the document. |
| ColumnsPerPage { get; set; } |
Split a worksheet into pages by columns. Default is 0, no pagination. |
| ConvertDateTimeData { get; set; } |
Indicates whether the string in the file is converted to date. Default is True. |
| ConvertNumericData { get; set; } |
Indicates whether the string in the file is converted to numeric. Default is True. |
| ConvertOwned { get; set; } |
Implements ConvertOwned Default is false |
| ConvertOwner { get; set; } |
Implements ConvertOwner Default is true |
| ConvertRange { get; set; } |
Convert specific range when converting to other than spreadsheet format. Example: “D1:F8”. |
| CultureInfo { get; set; } |
Get or set the system culture info at the time file is loaded |
| DefaultFont { get; set; } |
Default font for spreadsheet document. The following font will be used if a font is missing. |
| Depth { get; set; } |
Implements Depth Default: 1 |
| Encoding { get; set; } |
Encoding. Default is Encoding.Default. |
| FontSubstitutes { get; set; } |
Substitute specific fonts when converting spreadsheet document. |
| Format { get; } |
Input document file type. |
| virtual Format { get; } |
Input document file type. |
| HasFormula { get; set; } |
Indicates whether text is formula if it starts with “=”. |
| HideComments { get; set; } |
Hide comments. |
| IsMultiEncoded { get; set; } |
True means the file contains several encodings. |
| OnePagePerSheet { get; set; } |
If OnePagePerSheet is true the content of the sheet will be converted to one page in the PDF document. Default value is true. |
| OptimizePdfSize { get; set; } |
If True and converting to Pdf the conversion is optimized for better file size than print quality. |
| Password { get; set; } |
Set password to unprotect protected document. |
| RowsPerPage { get; set; } |
Split a worksheet into pages by rows. Default is 0, no pagination. |
| Separator { get; set; } |
Delimiter of a Csv file. |
| SheetIndexes { get; set; } |
List of sheet indexes to convert. The indexes must be zero-based |
| Sheets { get; set; } |
Sheet name to convert |
| ShowGridLines { get; set; } |
Show grid lines when converting Excel files. |
| ShowHiddenSheets { get; set; } |
Show hidden sheets when converting Excel files. |
| SkipEmptyRowsAndColumns { get; set; } |
Skips empty rows and columns when converting. Default is True. |
