ultraGridExcelExporter | Infragistics Forums

565

ultraGridExcelExporter

Preeth M posted over 9 years ago

Hi, Using an ultragrid with multibands (design mode.jpg) and it has indentation set to -1(properties of indentation.jpg), note that this has been set for all three bands in the grid. That is actually required as we need to show them on the screen for the users(data shown in the screen.jpg). I am using this ultraGridExcelExporter to get the excel sheet as shown in the screen. When the export happens i could see that the columns move one cell to the left. Actually it should be the same as shown in the screen. Could you kindly advise what am I missing here? Also they have commented that the gird needs extra code to export correctly and have used the below lines ultraGridExcelExporter.HeaderRowExporting += new HeaderRowExportingEventHandler(ultraGridExcelExporter_HeaderRowExporting); ultraGridExcelExporter.RowExported += new RowExportedEventHandler(ultraGridExcelExporter_RowExported); note the method in the bracket is attached as txt file(methods). Kindly advise what could be the ideal solution to adjust the column only in the export.

Images n txtfile.rar

Parents

6158

Offline Christopher Shea posted over 9 years ago

Hello,

I having a bit of difficulty deducing the structure of your datasource based on the images. I've attached my simple sample that exports a hierarchical grid to an Excel file. Could you please modify and reattach the sample so that it can help us reproduce the behavior? We appreciate your assistance.

Thanks,

Chris

WindowsFormsApplication1.zip
Cancel
Reply

Cancel
565

Preeth M posted over 9 years ago in reply to Christopher Shea

Hi,

Sorry, i am using VS 2008. Could you give me a sample on that version?

Thanks

Preeth
Cancel
Reply

Cancel

Reply

12480

Offline Mike Bowshewicz posted over 9 years ago in reply to Preeth M

Hi Preeth,

I've saved the solution in VS 2008. Please let me know if it works for you.

WindowsFormsApplication1.zip
Cancel
Reply

Cancel

Children

12480

Offline Mike Bowshewicz posted over 9 years ago in reply to Preeth M

Hi Preeth,

I don't believe that a teamviewer session will be valuable in this case, since I will need to familiarize myself with the application before I can begin to debug. If there's anything that you can send over, I will look at it and do my best to find the issue.
Cancel
Reply

Cancel
565

Preeth M posted over 9 years ago in reply to Mike Bowshewicz

HI

I am not able to map the datasource to the solution provided. Shall we have a teamviewer session at your convenience, so that i will be able to demonstrate how it works. Also note i am using windowsxp as to support the development - no skype available for IM. Kindly advise.
Cancel
Reply

Cancel
12480

Offline Mike Bowshewicz posted over 9 years ago in reply to Preeth M

Hi Preeth,

I wouldn't expect the exporter to behave in this way. Are you able to send a code sample that I can use to reproduce this issue? If you can send over some code, I should be able to determine why the cells are offset like that.
Cancel
Reply

Cancel
565

Preeth M posted over 9 years ago in reply to Mike Bowshewicz

Hi Mike,

I was able to use it after merging the required dll with the version(8.2) I have.

But after spending some time with my application i was able to find out the reason for this. I even altered the e.CurrentColumnIndex value thinking it should help me and it has only when i keep the headers visible for the child bands. But the requirement is hiding the headers for the childbands and using the headers of the band 0 for all of them. This has caused the excel output to show as reported. This "ultraGridExcelExporter_HeaderRowExporting" method is triggered only once as there is only one header row i.e., for band 0.

Now, could you guide me how to make this work keeping the headers of the child bands hidden.

Thanks
Preeth
Cancel
Reply

Cancel