Hi
I have an UltraGrid with 2 bands. Band 0 contains the summary information of an object and band 1 contains the details infromation of the same object in band 0.
When I export the grid I concatenate band 1 data after band 0. I have achived that however that left a few blank rows between each rows after move band 1 data to band 0. I am wondering how I can remove those blank rows. I don't mind doing that either during exporting the grid or after exporting.
Any advice will be much appreciated!
Thanks
Lan
Hi Lan,
I'm afraid I don't really understand what you are doing. How exactly are you concatenated Band 1 data onto band 0? Where are these empty rows showing up?
Hi Mike
what I am trying to do is below:-
grid display:
band0 header -> Header 1 Header 2 Header 3
band0 data -> data 1 data2 data3
band 1 header Header A Header B Header C
band 1 data data a data b data c
after experting to excel it looks like below
band0 header -> Header 1 Header 2 Header 3 Header A Header B Header C
band0 data -> data 1 data2 data3 data a data b data c
blank row left from moving band 1 headers
blank row left from moving band 1 data
I am trying to get rid of the blank rows left after moving the band 1 data over to band 0 level. I am trying to find a way to remove the blank rows from the spreadsheet using C#. Hope I have made it clearer for you.