How to export filtered data into Excel for a UI5 table?

[Former Member]

Hello Experts,

For the tables in my desktop application built in UI5, I want to develop "Export to MS Excel or PDF" functionality for the filtered data. For example, if the table contains 10 employees with different job titles and I search for Employees based on the job titles. Search result returns me 3 records and I want to export those 3 records into Excel or PDF.

Can anybody tell me if it is feasible? and how I can do that or where can I find the information regarding it?

Regards,

Saurabh

[Former Member · Accepted solution]

HI,

To export to table as excel,

$( "#export" ).click(function() {
  oTable.exportData().saveFile('Table');
});

[SergioG_TX]

Saurabh,

exporting to excel or csv should be a straight forward process. check out the hana xs developer documentation or there are plenty of tutorials on you tube / hana academy. this can also be achieved via native javascript

as far as exporting to PDF there may need additional research to be done. you may require a 3rd party js lib to accomplish this feature.

hope this helps

Sergio