Skip to Content
Former Member
Jul 17, 2009 at 12:09 PM

Spitting internal table as per the excel sheet name



I have a excel sheet with number of different sheets.I have few number of fields inside each sheet.My requirement was to do the conversion then download a file as the format of excel file.

But in my program, at selection screen I have 4 file upload paths.

1 for legacy file(records)

2 for legacy field names

3 for target field names

4 for downmoading the converted file as per the excel sheet I have.

Apart from the above I have mapping file which has the each sheet name that is present in the excel and also fields.Based on this file I am doing mapping/conversion.

the conversion has been done and my internal table is having all the fields of the excel sheet.But I need to download the files(the number is equal to the number of sheets present in the excel file and the downloaded file names has to be as the names of excel sheets) now.Can any one help me downloading such files?

Edited by: Jjammy on Jul 17, 2009 2:17 PM