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
Hi Shilpa,
shilpag said:For the First question can you give me a sample code of how it can be done using the starting row index.
I don't have any samples of this. It really depends what you want to do. Take a look at almost any of the events of the UltraGridExcelExporter. Just about all of the events pass in parameters like CurrentWorkSheet, CurrentRowIndex, and CurrentColumnIndex and these are settable properties. So you could watch for a particular row where you want to break to a new sheet and then set some of these properties to get the next row exported where you want it.
shilpag said:The second question is about, Is there any class or concepts of using the Styles and Ranges using Infragistics excel.
I'm still not really sure what you mean. The lastest version added some new features to the Excel assembly, so you can add images and things like that. You might want to check out the samples included with the NetAdvantage. I am pretty sure there are samples of using ranges to display an image.