Skip to Content
0

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

Dec 14, 2017 at 01:54 PM

374

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

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

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 12 at 01:58 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

My verison is 1.38.17.

0
Ivan Mirisola
Feb 19 at 02:15 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded