C4C Ext Edition - Fiori : Export to Excel

[Vinod0311]

Dear All,

Please aid your valuable inputs on the below scenarios on IPAD (Fiori)

1) 'Export to Excel' option when accessing the reports on Fiori doesn't work. Is there any pre-requisite Excel add-in required ? Please provide some pointers.

2) 'Export to Microsoft Excel' when performed from Sales Orders extracts only the list of Sales order id and the other attributes of the sales order aren't getting extracted as columns,

Please advice.

Cheers,

Vino

[former_member192750 · Accepted solution]

Hi,

#1 - This is a limitation with Excel on mobile devices (not all file formats are supported).
To overcome this, we are providing a new capability in 1608 to export the report data as a CSV file (will be available under Download > Report as CSV file).

#2 - Again this is a limitation of the the preview component on iOS (not all file formats are supported). The Microsoft Excel app works fine. To use it, open the share sheet once you see the single column file and then choose to 'Copy to Excel' and then work with the data.

On Android, you can similarly use the Google Sheets app.

Regards,

Ankan

[Vinod0311 · Accepted solution]

Cheers Ankan,

#1 -> Fantastic ! Shall wait for the 1608 update. As always the iPAD upgrade date is not transparent unlike the Desktop tenants upgrade. But in the last briefing Ananda mentioned, the approval to apple will be sent prior to tenants upgrade to reduce the waiting time for iPAD users. Happy to wait.

#2 : Copy to Excel does work, however am getting only the 'Sales order id' in the extract, the other columns/attributes of the Sales order are not getting exported. The export in desktop does include the adapted columns but Fiori doesn't do.Please advice.

Cheers,

Vino

[former_member192750 · Accepted solution]

For #2, as I mentioned, by default Export to Microsoft Excel will make a one column (ID) file open up (iOS Excel viewer) as in Fig 1. Tap on the share sheet and choose Copy to Excel (install the Microsoft Excel app) as in Fig 2. The same file will now open up in Microsoft Excel with all columns available as in Fig 3.

Fig.1

Fig. 2

Fig. 3

[Vinod0311 · Accepted solution]

Thanks , Fantastic!