The XlsExporter type exposes the following members.
Constructors
Name | Description | |
---|---|---|
XlsExporter |
Initializes a new instance of the XlsExporter class.
|
Methods
Name | Description | |
---|---|---|
Export(Stream) |
Exports the object specified by the Document property on the current exporter
to the specified Stream.
(Inherited from Exporter.)Note that some export formats do not support exporting to streams. Test the value returned by the CanExportToStream property on ExportProvider prior to calling this method. |
|
Export(String) |
Exports the object specified by the Document property on the current exporter
to the specified file.
(Inherited from Exporter.) |
|
ShowOptionsDialog |
Displays a dialog that allows the user to edit the export options.
(Inherited from Exporter.) |
Properties
Name | Description | |
---|---|---|
BookContent |
Gets or sets a value indicating the Excel book content.
|
|
DataOnly |
Gets or sets a value indicating whether the exported document with data only of
the original document (report).
|
|
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.
|
|
Document |
Gets or sets the object representing the document that will be exported
by the current exporter's Export(String) or Export(Stream) methods.
(Inherited from Exporter.) |
|
DocumentInfo |
Gets or sets the DocumentInfo object associated with the Document
assigned to the current exporter.
(Inherited from Exporter.) |
|
DocumentInfoFormClass |
Gets or sets the type of form that is used to edit the fields of DocumentInfo class.
That form can be invoked from the export options form (OptionsFormClass).
The form's type must be assignable to DocumentInfoForm.
(Inherited from Exporter.) |
|
ExportProvider |
Depending on the value of the OpenXmlDocument property on the current exporter,
gets XlsExportProvider or XlsxExportProvider.
(Overrides Exporter..::..ExportProvider.) |
|
FixedPositioning |
Gets or sets a value indicating whether the exported document
should exactly match the appearance of the original document.
Usually this can only be achieved at the cost of preserving
the logical structure and/or ease of editing of the exported document.
(Inherited from ComplexExporter.) |
|
FontScaling |
Gets or sets the amount (in points) by which to change font sizes
(may be used to better fit texts into available space).
|
|
OpenXmlDocument |
Gets or sets a value indicating whether the document should be saved in Office12 Open XML format.
(Inherited from ComplexExporter.) |
|
OptionsFormClass |
Gets or sets the type of form that is used to edit export options.
That form is shown when the Export(String) or the Export(Stream) method is called
if ShowOptions is true.
The form's type must be assignable to the type specified by the DefaultOptionsFormClass
property.
(Inherited from Exporter.) |
|
OptionsFormClassName |
Gets or sets the type name of form that is used to edit export options.
That form is shown when the Export(String) or the Export(Stream) method is called
if ShowOptions is true.
The form's type must be assignable to the type specified by the DefaultOptionsFormClass
property.
(Inherited from Exporter.) |
|
OutputFiles |
Gets the list of files which were generated by the call to Export(String).
Typically exporters produce a single file (e.g. RtfExporter, XlsExporter),
but some (like HtmlExporter and EmfExporter) may produce several files all of which
can be then accessed through this property.
(Inherited from Exporter.) |
|
PagePerSheet |
Gets or sets a value indicating whether to export each page
of the document into a separate sheet.
|
|
Paginated |
Gets or sets a value indicating whether the exported document
should preserve the pagination of the original document.
(Inherited from ComplexExporter.) |
|
Preview |
Gets or sets a value indicating whether the exported document should be opened
after exporting it to a disk file (using the Export(String) method).
The application used to open the file is determined by the OS shell.
(Inherited from Exporter.) |
|
Range |
Gets or sets the range of pages that is to be exported.
(Inherited from Exporter.) |
|
RangeFormClass |
Gets or sets the type of form that is used to enter the export output range.
That form can be invoked from the export options form (OptionsFormClass).
The form's type must be assignable to OutputRangeForm.
(Inherited from Exporter.) |
|
ReferenceGraphics |
Specifies the Graphics object used by export.
For example, that Graphics can be used to convert
EmfPlusDual or EmfPlusOnly
metafiles to EmfOnly.
If this property is null, the screen device context is used.
(Inherited from Exporter.) |
|
ShowOptions |
Gets or sets a value indicating whether the options dialog should be shown to the user
before exporting the document.
(Inherited from Exporter.) |
|
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.
|
Events
Name | Description | |
---|---|---|
LongOperation |
Occurs periodically during export.
Allows to show progress and give the end user the ability to cancel the operation.
(Inherited from Exporter.) |