Hi, I have a three grids and those grid have different columns and seperated by group boxes.
How can I export those grids to excel at the same time?
There is a export button and when the user click the button, I want to export three grids to one excel file.
Also, when the user click all the cells in one of the grid, it will copy and paste to excel. But after pasting
it to excel, all the display layout properties are missing. For example, the color for the header and the
ulternate column color are all missing. WHat should I do if I want to keep those color settings on
excel?
Hi,
minlee10 said: I have a three grids and those grid have different columns and seperated by group boxes. How can I export those grids to excel at the same time? There is a export button and when the user click the button, I want to export three grids to one excel file.
I have a three grids and those grid have different columns and seperated by group boxes.
Create a Workbook object in code. Add a Worksheet to the Worksheets collection.Export the first grid to the worksheet. Add a second worksheet and export the second grid to the second worksheet, etc.
minlee10 said: Also, when the user click all the cells in one of the grid, it will copy and paste to excel. But after pasting it to excel, all the display layout properties are missing. For example, the color for the header and the ulternate column color are all missing. WHat should I do if I want to keep those color settings on excel?
Copying from the grid only copies the data. There's no way to copy the appearances with it.
You should Submit a feature request to Infragistics
I want to export all three grids in one worksheet, not in three worksheet.
How can I do this?
You would have to trap the events of the UltraGridExcelExporter to determine the last row that is exported for each export operation. EndExport probably gives you the CurrentRowIndex, so you could use that. Then when you export the second grid, you pass in the same worksheet, but also pass in the starting row and column index.