Excel download in SAPUI5 application with custom formatting

GitHub repository:


  • 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


  • 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:


  • 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