![]() ![]() Internally also uses OLE, but no OLE specific knowledge is required. Interface I_OI_SPREADSHEETīelongs to the SAP Office Integration / Control Framework.Īllows to create more sophisticated Excel Files (Colors, Individual Formatting, Multiple Sheets, Zoom, Hide Rows, etc.)Īlthough a lot of formatting options exist, the usage is quite simple because the methods of the interfaces are self-explanatory. No changes to layout or formatting of the file possible. Has a very simple interface (internal table, filename).Ĭertain ABAP Types may not be converted correctly to Excel Format (e.g. Function Module SAP_CONVERT_TO_XLS_FORMAT NB: although SpreadsheetML Files are still compatible with newer Excel Versions, Microsoft changed to the OpenXML Standard with Office 2007. Word/Excel-Files consist now internally of several xml-files. Their names are all starting with ZDEMO_EXCEL. Several demo programs are available after importing the source code. The suite works in background, is performing, platform-independent and is easy to understand. The features of this suite allow producing high end excel files (drawings, graphs, conditional formatting, formulas etc) This project can be imported by first installing abapGit. Information on ABAP2XLSX can be found on the ABAP2XLSX Homepage or in this nice blog. ![]() ABAP2XLSX is a convenient openSource Suite to generate Excel Files according to format XLSX (since Office 2007). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |