Group Abstract Group Abstract

Message Boards Message Boards

0
|
3.1K Views
|
1 Reply
|
1 Total Like
View groups...
Share
Share this post:

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

Posted 2 years 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
Posted 2 years ago

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