PROJECT LINK:
YOUTUBE CHANNEL:
For a long time only OLE/DOI-approach was available for creating spreadsheets. As you know, OLE/DOI-approach is quite flexible, but it has some restrictions. For example, it requires installed MS Excel application (this makes impossible to use background job for generate spreadsheet). Moreover, OLE-approach has low performance (this problem can be partially solved using VBA, but this requires manually changing of security settings MS-Excel application on each front-end computer).
Since, ZIP-folder processing tools became available in the SAP environment, we are able to generate spreadsheets with new Open XML Format (XLSX). This approach does not have lacks of OLE.
But, in my opinion, the flaw of all existing solutions for generate spreadsheets from ABAP- is many lines of ABAP code required directly for creating and formatting spreadsheet layout. As result, the same Excel forms are quite differently implemented by the different developers. That approach heavily complicates a support of these developments.
My idea is creating the design-time environment for visual form editing (like a SMARTFORMS tool, for example).
A unified approach to development is realized because no need to write the code for the Excel form formatting - you only care about source data for the form.
Runtime printing form is being generated with the new Open XML Format (XLSX), without using of Microsoft Excel application (it makes possible to get result in the background jobs SAP).
DESIGN-TIME AND RUNTIME
Where are two modes of XLSX Workbench tool.
WHAT DOES DEVELOPMENT PROCESS LOOK LIKE ?
You need to develop three components:
declare a context (just variable which refers to ABAP-dictionary type);
fill context with data;
call function module 'ZXLWB_CALLFORM'.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |