Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 18 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
1  
@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
1  
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.