3 Tutorials
Before beginning You have to install objects of the functionality to Your SAP-system .
Below is the «Roadmap» of the development process:
1) Development of the context (see more).
As a Context, you can use any suitable Table type or Structure or Data element from the ABAP-dictionary.
Or just create your own Context via transaction SE11.
2) Development of the form (see more).
Call transaction ZXLWB_WORKBENCH and build the form structure in the visual editor.
No ABAP-code, just click and drag-n-drop.
3) Development of the printing program (see more).
Create a printing program:
declare a context (just variable which refers to ABAP-dictionary type);
fill context with data;
call function module 'ZXLWB_CALLFORM'.
Profit !!!
By default, the Form will immediately popup with MS Excel application.
However, you can use an option for saving the Form as XLSX-file on your desktop.
And, of course, you can easily get XLSX-file as a hex-sequence for further manipulation with it (sending via e-mail, for example).
And yes, XLSX-file compiles without OLE, directly on the application server (this allows getting XLSX-file in Background job).