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.  

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