Hello ABAPers!
How many times have you struggled with Excel spreadsheet (XLSX and CSV) uploading and downloading routines with validations, date formats, decimals points, etc.? I created a generic handler class to help repetitive handling of Excel spreadsheets in our programs.
- ZCL_EXCEL_HANDLER is a general Excel upload/download handler class for SAP ABAP systems. It supports both XLSX and CSV file formats for uploading and downloading data between SAP and PC or application server.
- FEATURES
- Upload and download CSV files
- Upload and download XLSX files
- Support for both PC and application server file handling
- Customizable CSV column separator
- Header line handling for CSV files
- Automatic data type conversion and validation
- NOTES
- Method upload_xlsx works only on Windows workstations with Excel installed and in foreground only (using OLE)
- All other methods support upload and download on both PC (foreground) and application server (foreground/background)
- The class handles data type conversions and validations automatically
- Error handling is implemented using the ZCX_EXCEL_HANDLER exception class
Please, feel free to check it out at: https://github.com/ewoyadmin/abap-excel-upload-download-handler.git
I'm glad if someone finds it helpful. 🙂
Happy coding!