I have a report which display list in Header and Item format. If i click on 'Excel' icon on tool bar, the Item list is converted in to 'Excel' format. Every thing is fine.
The issue is the excel formatted list has got lot of Work sheets called 'Format',Header','Pivot',sub1,sub2....sub10 'Raw data' and 'Raw header'.
Most of these worksheets are blank. User do not want remove all these worksheets except one or two. How do i do this. Can a variant do the trick? if yes how to do that?
Any help in this regard is appreciated.