Skip to Content

useExportToExcel in smart table

Hi Experts,

i am using smart table , and i have requirements to enable the user to download the table data with filters used in smart table in csv/xlsx format, Can anyone one help me to do that in smart table, i can see option for that is "useExportToExcel" property which i am already using in my smart table, but it is not working , Please help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 25, 2017 at 09:58 AM

    Hi Pradeep,

    If you want to download excel file from SmartTable, you have to use property useExportToExcel="true"

    The proper format needed for such an export. The server must return a metadata document with sap:supported-formats="xlsx" to support this.


    Please check your metadata. for your kind reference check below screen, EntityContainer looks like this



    Add comment
    10|10000 characters needed characters exceeded

    • Hi Vedaradhya Agrahar,

      Thank you so much for the reply, is the useExcelToExport will download the data after the filter is applied on the smart table?, or is there any way to get the filters applied on smart table in the controller file, so that i can use that filters to download the report in excel?

      Thanks in advance,