Exporting to Excel
In This Topic
TrueDBGrid allows exporting grid data to Microsoft Excel format by using either of the following methods:
It is important to note that time taken to export grid data to Excel format is very small when using the SaveExcel method. In comparison, the ExportToExcel method takes much longer to export data.
SaveExcel method
To set the SaveExcel method, add the following code to the Click event of the Export button:
To write code in Visual Basic
| Visual Basic |
Copy Code
|
|---|---|
| Me.c1TrueDBGrid1.SaveExcel("../../GridData.xlsx") | |
To write code in C#
| C# |
Copy Code
|
|---|---|
| this.c1TrueDBGrid1.SaveExcel("../../GridData.xlsx"); | |
ExportToExcel method
To set the ExportToExcel method, add the following code to the Click event of the Export button:
To write code in Visual Basic
| Visual Basic |
Copy Code
|
|---|---|
Me.C1TrueDBGrid1.ExportToExcel("c:\temp\composers.xls")
|
|
To write code in C#
| C# |
Copy Code
|
|---|---|
this.c1TrueDBGrid1.ExportToExcel(@"c:\temp\composers.xls"); |
|
Note: TrueDBGrid's export and printing features uses the C1.Win.Printing NuGet package, which provides three libraries: C1.PrintDocument, C1.Win.PrintPreview and C1.Win.RibbonPreview. Each library provides a set of previewing controls or components. The PrintDocument library provides the PrintDocument and MultiDocument components, the PrintPreview library provides the PreviewOutlineView, PreviewPane, PreviewTextSearchPanel, Thumbnail, PrintPreviewControl and PrintPreviewDialog components, and RibbonPreview provides the RibbonPreview and RibbonPreviewDialog components. Since C1Report is now obsolete, make sure that the references for C1Report libraries is replaced by individual library references in the C1.Win.Printing nuget.
What You've Accomplished
Clicking the Export button creates an Excel file in the temp directory indicated in the code above:
