How do I save all images from .xls file?

Question

I've got a xls file with exactly 167 images that I must save and post on a website. The sheer number itself is painful, but what complicates things is that you can't directly save images from Calc - you need to copy it to Writer first and then save.

This isn't the way I would like to do things, so is there a way to save all the graphics in the file somehow?

score 23 · Accepted Answer · edited Jan 29 '13 at 10:41

23

Open the xls file in OpenOffice or LibreOffice
save it as a open document (.ods).
rename file to have .zip extension
uncompress that zip file

All images should be in a Pictures/ directory in that zip file.

This also works if you are given a .PPT which can be saved in Impress.

edited Jan 29 '13 at 10:41

Dennis

2,513

answered Sep 08 '11 at 10:18

Michał Šrajer

28,899

score 0 · Answer 2 · answered Nov 21 '11 at 02:01

0

If you want to get scripty there are some perl scripts to unpack Open Document Formats at:

http://books.evc-cit.info/odbook/ch01.html#unpack-program-example

answered Nov 21 '11 at 02:01

Amanda

9,723

How do I save all images from .xls file?

2 Answers2