Export/Configure Excel from ABAP
2 Beiträge
•
Seite 1 von 1
2 Beiträge
Seite 1 von 1
Hi all !!!
I'm using the function MS_EXCEL_OLE_STANDARD_DAT to export an internal table into Excel ...
But I want to add a new Worksheet into Excel if my internal table is bigger than 65536 records ... How can I do this please ?
Thanks a lot for your help.
David.
I'm using the function MS_EXCEL_OLE_STANDARD_DAT to export an internal table into Excel ...
But I want to add a new Worksheet into Excel if my internal table is bigger than 65536 records ... How can I do this please ?
Thanks a lot for your help.
David.
gesponsert ⓘ
Stellenangebote auf ABAPforum.com schalten
kostenfrei für Ausbildungsberufe und Werksstudenten
kostenfrei für Ausbildungsberufe und Werksstudenten
Hi,
The function module that you are calling downloads the ITAB as a .txt file, then opens excel and presses the SaveAS button to convert this to Excell.
My suggestion would be to modify the function module to open excel, and 'open' your .txt files per tab broken down into as many files as you need.
1) Download the data into no of .txt files.
2) Open Excel
3) On the first 'TAB' select open File and specify the file name
4) Select the second tab and repeat point 3
5) Select SaveAs to convert to .xls
A bit of OLE type coding involved so its a case of 'do they really need this'?
Cheers
Wob
The function module that you are calling downloads the ITAB as a .txt file, then opens excel and presses the SaveAS button to convert this to Excell.
My suggestion would be to modify the function module to open excel, and 'open' your .txt files per tab broken down into as many files as you need.
1) Download the data into no of .txt files.
2) Open Excel
3) On the first 'TAB' select open File and specify the file name
4) Select the second tab and repeat point 3
5) Select SaveAs to convert to .xls
A bit of OLE type coding involved so its a case of 'do they really need this'?
Cheers
Wob
Seite 1 von 1
Vergleichbare Themen
2
Antw.
Antw.
5500
Views
Views
EXCEL Export aus SAP mit Excel 2003 / 2007
von hfahrian » 03.02.2014 11:34 • Verfasst in ABAP Objects®
von hfahrian » 03.02.2014 11:34 • Verfasst in ABAP Objects®
4
Antw.
Antw.
2281
Views
Views
Frage die ABAP Experten
Über diesen Beitrag
Unterstütze die Community und teile den Beitrag für mehr Leser und Austausch
Aktuelle Forenbeiträge
Newsletter Anmeldung
Keine Beiträge verpassen! Wöchentlich versenden wir lesenwerte Beiträge aus unserer Community.Die letzte Ausgabe findest du hier.