[]
Represents an object that can be used to export a document to Excel (XLS and XLSX) formats.
public class XlsExporter : ComplexExporter
Name | Description |
---|---|
XlsExporter() | Initializes a new instance of the XlsExporter class. |
Name | Description |
---|---|
BookContent | Gets or sets a value indicating the Excel book content. |
DataOnly | Gets or sets a value indicating whether only data should be exported, ignoring visual attributes. |
DetectDataType | Gets or sets a value indicating whether the export module should try to auto detect the type of data (numeric, date) in the cells. |
DetectFormats | Gets or sets a value indicating whether to detect of Excel format for each text value. |
ExportProvider | Depending on the value of the OpenXmlDocument property on the current exporter, gets XlsExportProvider or XlsxExportProvider. |
FontScaling | Gets or sets the amount (in points) by which to change font sizes (may be used to better fit texts into available space). |
PagePerSheet | Gets or sets a value indicating whether to export each page of the document into a separate sheet. |
ParseEmfPlus | Gets or sets a value indicating whether EMF+ metafiles should be parsed directly without converting them to EMF-only first. The default is false. Set to true if you have issues resulting from EMF+ to EMF conversion. |
Tolerance | Gets or sets the tolerance (in points) when auto-detecting the boundaries of rows and columns in the document. The smaller this amount, the greater the number of narrow rows and columns created for precise positioning of data. |
Name | Description |
---|---|
Clear() | Resets the internal state of the exporter and all its public properties. |
CopyPropertiesFromOptionsForm(ExportOptionsFormBase) | Copies the options from the specified export options form to corresponding properties on the current exporter. |
CopyPropertiesToOptionsForm(ExportOptionsFormBase) | Copies the properties of the current exporter to corresponding user-editable options of the specified export options form. |
ProcessPage(Metafile, C1MetafileInfo, int, bool) | Exports a page of a document represented by a Metafile. |
Reset() | Resets the internal state of the exporter. |