[]
Option class for saving xlsx file.
public class XlsxSaveOptions : SaveOptionsBase
Public Class XlsxSaveOptions
Inherits SaveOptionsBase
Name | Description |
---|---|
XlsxSaveOptions() | Constructor. |
Name | Description |
---|---|
ExcludeEmptyRegionCells | Indicates whether to exclude any empty cells(cells with no data or only style) outside the used data range. Default is false. |
ExcludeUnusedNames | Indicates whether to exclude user-defined but never used Define name. Default is false. |
ExcludeUnusedStyles | Indicates whether to exclude user-defined but never used Cell styles. Default is false. |
IgnoreFormulas | Indicates whether to treat formula cells as value cells. |
IncludeAutoMergedCells | Indicates whether to include the automatically merged cells. The default value is false. |
IncludeBindingSource | Gets or sets whether to include the binding source when saving the file. Default value is true. |
IsCompactMode | A bool indicating whether to save workbook in compact mode, the default value is false. |
Password | The password for the xlsx file. |