Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
abaprules
Explorer
0 Kudos
4,058

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! 

2 Comments
Sm1tje
Active Contributor

Hi abaprules,

personally, I'm curious about what, among others, Jelena Perfiljeva, Paul Hardy et al. have to say about this blog post.

https://community.sap.com/t5/application-development-blog-posts/monthly-abap-to-excel-blog-july-2023...

shais
Participant
0 Kudos

Yet another Excel (and CSV) blog 🙂

Labels in this area