Export Sharepoint online List to Excel with column Image
Dear all,
I want to export a Sharepoint List that contains a column called Photo which format is "Image".
When I used the button Export the file query.iqy is generated. In my column Photo I have a text like :
{"type":"thumbnail","fileName":"sample-photo.jpg","serverUrl":"","serverRelativeUrl":"/sites/ProjetMKTHJMaquette/SiteAssets/Lists/eb1c0d3f-7a02-4582-ab67-3c01a165fedd/sample-photo.jpg....
Can you advise me how to show the photo instead of the Photo path URL in Excel?
I know that I may create an Excel Macro to achieve this but this doesn't suit my need since I don't know how to deploy my Excel Macro for all my users around the world.
Many thanks.
Regards
Soung
-
AFAIK there is no way to actually export the image into excel, you only can export the path to the image, as the image is technically not stored within the sharepoint-list-item, but instead it's stored separatly from the list-item.
1
Please sign in to leave a comment.
Comments
1 comment