Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

up vote 13 down vote accepted
  1. Open the xls file in OpenOffice or LibreOffice
  2. save it as a open document (.ods).
  3. rename file to have .zip extension
  4. 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.

share|improve this answer
2  
That - is - AWESOME! –  Oxwivi Sep 8 '11 at 10:30
    
@Oxwivi: You welcome. This shows beauty of open standards. Isn't it? –  Michał Šrajer Sep 8 '11 at 10:33
    
Indeed, stuff like these small workarounds makes me love open softwares and standards even more! –  Oxwivi Sep 8 '11 at 12:58
    
nice tip! same works for open document presentation (.odp). –  susis strolch May 21 '13 at 11:14

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.