HI,
Is it possible in Infragistics Excel to export it to Multiple sheets?
Is there any ways in this to use to concept of Styles and the Ranges which will help us to give a good look to excel sheet, if yes please tell me how to use it.
Please give the sample examples where these concepts are used so that i can have a good idea.
Thanks in advance.
shilpag said:Is it possible in Infragistics Excel to export it to Multiple sheets?
Do you mean a single grid exported to multiple sheets? I'm not sure if this can be done. You can handle the events of the WinGridExcelExporter and set the current worksheet, so I guess this would be possible. I'm pretty sure there is an overload of the export method that takes a WorkSheet, also. So you could certainly export a different grid to a different worksheet. Or even multiple grids to the same worksheet, by specifying the starting row index.
shilpag said:Is there any ways in this to use to concept of Styles and the Ranges which will help us to give a good look to excel sheet, if yes please tell me how to use it.
I'm afraid I don't understand your question.
For the First question can you give me a sample code of how it can be done using the starting row index.
The second question is about, Is there any class or concepts of using the Styles and Ranges using Infragistics excel.
Regards,
Shilpa