To export selected WinGrid rows to Excel I have successfully used the code described in KB07699. Because a new application I’m developing contains a significant number of WinGrids I need to use the ultraGridExcelExporter1_InitializeRow event and not the ultraGrid_InitializeRow event as described in KB07699.
Using the ultraGridExcelExporter1_InitializeRow event to export selected rows to Excel is described in Mike Saltzman’s post of 5/31/2011. The code described in this post does identify the selected rows for exporting but ALL the rows in the grid are exported and therein lies my question. What am I missing? I see the post has been verified but it’s not getting it done for me.
Any suggestions would be enormously helpful.
Thank you.
Hello ,
As far as I understand you want to use the approach suggested by Mike (
http://ko.infragistics.com/community/forums/p/55998/287427.aspx#287427) instead of this in our Knowledge Base (http://devcenter.infragistics.com/Support/KnowledgeBaseArticle.aspx?ArticleID=7699), because of your specific scenario to export several grids and you need this functionality to be in ExcelExporter. Based on those tutorials I have implement a small sample, where I am using ExportStarted event of UltraExcelExporter in order to “say“ which rows should be exported (selected rows). Please run the sample, select several rows and press “Export” button. Please let me know if this is what you are looking for.
Please let me know if you have any further questions.
Hristo:
As I mentioned in my previous post, our program uses multiple WinGrids, over 100, and your export to Excel solution works flawlessly when it’s rolled into our code.
Thank you for the promptness of your reply and accuracy of your code. Well done!