How to download report to individual sheets of a excel workbook?

[Former Member]

How to download the Header Data to one spreadsheet and put item data in another spreadhseet of the same workbook?

(I searched on the forum but did not narrow down to a suitable result.)

Thanks - Ven

[kesavadas_thekkillath]

Did you search the wiki part, lot of ddocuments are available

check link:[http://wiki.sdn.sap.com/wiki/display/Snippets/MultiplesheetExcelDocumentfromSAPusing+OLE]