Group Abstract Group Abstract

Message Boards Message Boards

Export a WL-Graphics to Excel?

Posted 9 years ago
Attachments:
POSTED BY: Werner Geiger
3 Replies
Posted 9 years ago

Unfortunately I could not solve that until now.

Maybe it becomes clearer if I ask like this:

How can I export some WL-data (say a string) together with a WL-image (generated from a graphics or anything else) on one sheet of an Excel-2007ff (.xlsx) workbook?

POSTED BY: Werner Geiger
Posted 9 years ago

Thanks, Chad. This works indeed. But I cannot see how to get control over the sheet names. And how can I mix different data on one sheet? For example a header line and a graphics? Like in my example above.

POSTED BY: Werner Geiger

Here is one way to do it:

aTable = Table[{x, x^2}, {x, 10}];
aGraphics = ListPlot[aTable];
xfile = Export["exported_tmp.xlsx", {"Sheets" -> aTable, "Images" -> aGraphics}, "Rules"]
POSTED BY: Chad Knutson
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard