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,443
2
25
42

answered Sep 08 '11 at 10:18

Michał Šrajer

27,439
4
33
29

2

That - is - **AWESOME**! – Oxwivi Sep 08 '11 at 10:30
1

@Oxwivi: You welcome. This shows beauty of open standards. Isn't it? – Michał Šrajer Sep 08 '11 at 10:33
Indeed, stuff like these small workarounds makes me love open softwares and standards even more! – Oxwivi Sep 08 '11 at 12:58
1

nice tip! same works for open document presentation (.odp). – susis strolch May 21 '13 at 11:14

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,051
17
53
98

How do I save all images from .xls file?

2 Answers2