A newer version of this page is available.
Switch to the current version.
XlsExportOptions.ExportMode Property
Specifies whether the document should be exported to a single or different XLS files, each page in a separate file.
Namespace: DevExpress.XtraPrinting
Assembly: DevExpress.Printing.v18.2.Core.dll
Declaration
[DefaultValue(XlsExportMode.SingleFile)]
[XtraSerializableProperty]
public XlsExportMode ExportMode { get; set; }<DefaultValue(XlsExportMode.SingleFile)>
<XtraSerializableProperty>
Public Property ExportMode As XlsExportModeProperty Value
| Type | Default | Description |
|---|---|---|
| XlsExportMode | SingleFile |
An XlsExportMode enumeration value. |
Property Paths
You can access this nested property as listed below:
| Library | Object Type | Path to ExportMode |
|---|---|---|
| Cross-Platform Class Library | RemotePrintingSystem |
|
| ExportOptions |
|
|
| PrintingSystemBase |
|
|
| WinForms Controls | PrintingSystem |
|
| XtraSchedulerReport |
|
|
| WPF Controls | ExportOptionsContainer |
|
| PrintingSystem |
|
|
| PrintingSystem |
|
|
| Reporting | XtraReport |
|
| DocumentOperationRequest |
|
Remarks
The code below demonstrates to export a report to XLS with the specific export options.
using DevExpress.XtraPrinting;
//...
public partial class Form1 : Form {
//...
private void button1_Click(object sender, EventArgs e) {
// A path to export a report.
string reportPath = "c:\\Test.xls";
// Create a report instance.
XtraReport1 report = new XtraReport1();
// Get its XLS export options.
XlsExportOptions xlsOptions = report.ExportOptions.Xls;
// Set XLS-specific export options.
xlsOptions.ShowGridLines = true;
xlsOptions.TextExportMode = TextExportMode.Value;
xlsOptions.ExportHyperlinks = true;
xlsOptions.SheetName = "My Sheet";
xlsOptions.ExportMode = XlsExportMode.DifferentFiles;
// Export the report to XLS.
report.ExportToXls(reportPath);
//...
}
//...
See Also
Feedback