XlsbSaveOptions Class
Represent options for saving to XLSB file format (Microsoft Excel Binary File Format).
public sealed class XlsbSaveOptions : SaveOptions
Public NotInheritable Class XlsbSaveOptions
Inherits SaveOptions
- Inheritance:
- XlsbSaveOptions
Constructors
XlsbSaveOptions()
Initializes a new instance of the XlsbSaveOptions class.
Properties
ContentType
Gets the content-type for PDF file format: application/vnd.ms-excel.sheet.binary.macroEnabled.12.
public override string ContentType { get; }
Public Overrides ReadOnly Property ContentType As String
Property Value
- System.String
The content-type for PDF file format.
Overrides
ImageDpi
Gets or sets the saved images DPI.
Property Value
The saved images DPI.
Remarks
This property controls the image quality for all images in the file. Larger value results in better-quality images but increases the file size. Setting this property to 0 will disable image optimization. Standard DPI values are:
- 330 - Good quality for HD displays
- 220 - Good quality for most printers and displays
- 150 - Good quality for web pages and projectors
- 96 - Good quality for smaller file sizes
Limitations
Gets limitations for saving to XLSB file format.
public override FileFormatLimitations Limitations { get; }
Public Overrides ReadOnly Property Limitations As FileFormatLimitations
Property Value
Overrides
Remarks
These are the limits:
- MaxRows: 1048576
- MaxColumns: 16384
- MaxColors: 16000000
- MaxCellStyles: 64000
Password
Gets or sets the password used to protect / encrypt the workbook.
Property Value
- System.String
Events
ProgressChanged
Occurs when the saving progress of a file has changed.
public event EventHandler<OperationProgressChangedEventArgs> ProgressChanged
Public Event ProgressChanged As EventHandler(Of OperationProgressChangedEventArgs)
Event Type
- System.EventHandler<OperationProgressChangedEventArgs>
Remarks
The file path or stream that was provided as a file destination is used as a UserState.
Inherited Properties
CsvDefault | Gets the default options for saving to Character Separated Values file format. (Inherited from SaveOptions) |
HtmlDefault | Gets the default options for saving to HyperText Markup Language File format. (Inherited from SaveOptions) |
ImageDefault | Gets the default options for saving to image formats. (Inherited from SaveOptions) |
OdsDefault | Gets the default options for saving to OpenDocument Spreadsheet file format. (Inherited from SaveOptions) |
PdfDefault | Gets the default options for saving to Portable Document Format file. (Inherited from SaveOptions) |
TxtDefault | Gets the default options for saving to Tab delimited file format. (Inherited from SaveOptions) |
XlsDefault | Gets the default options for saving to, XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions) . (Inherited from SaveOptions) |
XlsbDefault | Gets the default options for saving to XLSB file format (Microsoft Excel Binary File Format). (Inherited from SaveOptions) |
XlsxDefault | Gets the default options for saving to XLSX file format (Microsoft Excel Open XML Spreadsheet; Excel 2007 and later). (Inherited from SaveOptions) |
XpsDefault | Gets the default options for saving to XML Paper Specification file format. (Inherited from SaveOptions) |