Skip to Content

Export Excel Sheet in SAP UI5 - Smart Table Column Names from Entity Type property

Hi,

In Smart Table, there is a property "useExportToExcel" for exporting Table data in excel sheet. Here Smart Table headers are coming from entity type sap:label name.

Ex :

<Property Name="StrucData" Type="Edm.String" Nullable="false" MaxLength="18" sap:label="Structured Data" sap:creatable="false" sap:updatable="false"sap:sortable="false" sap:filterable="false"/>

When I export the table, StructData is coming as Column Header in Excel sheet. But we wants Structured Data as column name in excel sheet. In Smart controls, I don't see any event to manipulate the table column data. Is there any way to manipulate?

Regards

Karthik S

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 19, 2017 at 11:41 AM

    Waiting for response for the same query ?? !! kindly help

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 12 at 01:58 PM

    Hi,

    I don't see any issue with the metadata, I am using similar kind of properties and column name for my excel is coming from sap: label.

    Which UI5 version are you using?

    Thanks,

    Shubham

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 19 at 02:15 PM

    Hi Karthik,

    You may need to implement the method "onBeforeRebindTable" . It gets executed right after the odata is called and before any data is assigned to your smart table. There you could get a reference to your smart table. I have done some experimenting with extending the smart table controller and here is the code if you want to take a look. I connected my WebIDE from SCP to a HANA database system via Cloud Connector. But you could check the code and how it is implemented there.

    Regards,
    Ivan

    Add comment
    10|10000 characters needed characters exceeded