Message Boards Message Boards

0
|
1775 Views
|
1 Reply
|
1 Total Likes
View groups...
Share
Share this post:

How to create XLSX output that includes images in some spreadsheet cells?

Posted 1 year ago

I'd like to create an XLSX file for offline use that contains images. Here's my example:

name = "Abruzzi";
img = Import["http://figs4fun.com/fpix/FP861-25_192.jpg"];
myTable = {
   {"Cultivar", "skin color", "flesh color", "images"},
   {name, "", "", img}
   };
Export["test.xlsx", myTable];

When viewed in MS Excel, the spreadsheet cell that I'd like to contain the image looks like this:

Image[NumericArray[{{{0, 0, 0}, {0, 0, 0}, {0, 0, 0}, {0, 0, 0}, ...
POSTED BY: Richard Frost

Hi Richard,

I searched on MSE for a solution to this and the only answer I found that could export an image to a cell requires some Python code. You could try that.

POSTED BY: Rohit Namjoshi
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract