Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
115
How can I export multiple grid to excel?
posted

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?

Parents
  • 469350
    Offline posted

    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

     

     

Reply Children