Technical Articles
Excel download in SAPUI5 application with custom formatting
GitHub repository:
Introduction:
- In this session, we will look at how we can download table data in Excel with custom formatting
- SAPUI5 framework has support for Excel download – but comes with minimal formatting options
- We can achieve any kind of custom formatting with HTML5, CSS and JavaScript
Excel with custom formatting
Synopsis:
- To achieve this custom formatting, we can use HTML5, CSS and JavaScript
- Basically, we need to manipulate the DOM structure and add an <a> tag to it
- The href attribute of the <a> tag will hold the outerHTML of the table element
- And with the help of a simple utility function, we can download the table with custom formatting
YouTube Link:
Conclusion:
- This workaround will allow us to download table data in Excel with custom formatting
- This workaround is not supported by SAP
- The Excel file downloaded in this manner will have a warning message
- If you have questions or comments, please list them below and I will be happy to answer
Be the first to leave a comment
You must be Logged on to comment or reply to a post.