Export Method (XlsExport)

Exports the specified document to Excel format.

Overload List

Overload	Description
Export(PageDocument,String)	Exports the specified document to a .xls file.
Export(PageDocument,String,String)	Exports the specified page document to Excel.
Export(PageDocument,Stream)	Exports the specified page document to Excel.
Export(PageDocument,Stream,String)	Exports the specified document to Excel.
Export(SectionDocument,String)	Exports the specified document to an Excel file.
Export(SectionDocument,String,String)	Exports the specified range of pages in a document to an Excel file.
Export(SectionDocument,Stream)	Exports the specified document to a stream in Excel format.
Export(SectionDocument,Stream,String)	Exports the specified range of pages in a document to a stream in Excel format.

Remarks

Only when the output on the report is valid for the following conditions, the format settings of the cells exported to Excel are set automatically.

Example

private void Form1_Load(object sender, System.EventArgs e) 
{ 
    rptExports rpt = new rptExports(); 
    this.viewer1.Document = rpt.Document; 
    rpt.Run(false); 
 
    xlsExport1.Export(this.viewer1.Document, Application.StartupPath + "\\x.xls"); 
}

VB.NET

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    Dim rpt As New rptExports()
    Viewer1.Document = rpt.Document
    rpt.Run(False)

    XlsExport1.Export(rpt.Document, Application.StartupPath + "\x.xls")
End Sub

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

XlsExport Class
XlsExport Members