ComponentOne True DBGrid for WinForms
True DBGrid for WinForms Task-Based Help / Exporting Grid Data / Exporting to Excel
In This Topic
    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: