exporting Items with pictures to excel sheet

(0) Share

Report

Posted on by samerabd

i need to export the items with their pictures to an excel file on cloud, I tried doing the report and using SAVEASEXCEL function but this function only works on premise, is there any other way to do that on the cloud?

would tempblob work?

Thank you,

Categories:

Dynamics 365 Business Central

All responses (4)

Answers (0)

samerabd 70 on at

Like (0)

Report

RE: exporting Items with pictures to excel sheet

if i copy the data to a new excel file i can import it with no problems
samerabd 70 on at

Like (0)

Report

RE: exporting Items with pictures to excel sheet

the export now works great i was missing the filemanagment line, but now the import is giving me an error :

'', hexadecimal value 0x03, is an invalid character. Line 1, position 81.
Suggested answer

Stefano Demiliani 37,162 Most Valuable Professional on at

Like (1)

Report

RE: exporting Items with pictures to excel sheet

For this task you could create an API page that exposes Item and Item Picture and then consume it from Excel or othet OData clients.

Other possibile solution is something like described here (with Streams):

navnilesh.blogspot.com/.../reportsaveaspdf-in-business-central.html
Community Member on at

Like (0)

Report

RE: exporting Items with pictures to excel sheet

try to use Report.SaveAs and use Tempblob to stream the result