SHStefan Hoenig Syncfusion Team November 4, 2002 12:44 PM
right now there is no support for exporting these settings into Excel format. We'll work on support for exporting Excel/BIFF format in a future version and should have something ready in a few months.
One workaround you might try in the meantime would be to use Excel OLE-Automation, create a worksheet and format the cells.
ADAdministrator Syncfusion Team March 25, 2004 02:56 PM
I am using Excel Automation to fill the values from the grid to Excel spreadsheet. Do you have any suggestion on how to copy a tree view grid into Excel? I want to preserve the tree view.
ADAdministrator Syncfusion Team March 26, 2004 11:16 AM
Excel does not support direct representation of Hierarchical data, but there is a Group By feature which can be used to give the appearance of a Hierarchical grid. The groupby feature can be found in >>Data>>Group and outline >> group. This feature allows you to collapse a bunch or rows/columns. We can use this feature to collapse every level in the hierarchy. This can be done by using the Essential ExcelRW library.
ExcelRW allows you to read and write excel files in native BIFF8 format. ExcelRW also has API support for grouping rows and columns. Could you provide more information on your requirements and the type of grid that you are using [Databound grid, grouping grid,GridControl] so that i can put together a sample demonstrating how ExcelRW could be used to export an Hierarchical grid to excel.
However, we will be adding built in support for Essential grid to export Hierarchical tables to Excel. Sorry for the inconvenience.
>I am using Excel Automation to fill the values from the grid to Excel spreadsheet. Do you have any suggestion on how to copy a tree view grid into Excel? I want to preserve the tree view.