Beiträge lesen & schreiben : Read & write articles
Fragen stellen & beantworten : Ask & Answer


Postby SapFossil » Fri 26. Jul 2013, 11:52

If you have the problem to develop any EXCEL-scenarios with SAP i can recommend to install and use nugget ABAP2XLSX.
I've made best experience using this feature for direct EXCEL-Ex- & Import. Thanks people for this development!
Although there is little bug interpreting fix column/lines (class zcl_excel_reader_2007, method load_worksheet) this feature ist very effective and has a very good performance. You need not to care about XML and other stuff.
Forget all about SAP-functions TEXT_CONVERT_XLS_TO_SAP or ALSM_EXCEL_TO_INTERNAL_TABLE and similar. They all use OLE-screnario with restricted and uncontrollable clipboard-functions. Further they all have strict limits using string-containers.
To download this nugget follow this link.

Thanks for further comments and/or discussions in advance.
Take people as they are - there are no better ones. :-)
User avatar
Posts: 36
Joined: Tue 14. Jul 2009, 19:54

Forum Statistics

Who is online

Users browsing this forum: No registered users and 1 guest


Return to Tipps & Tricks