Thursday, May 14, 2009

How to extract embedded images from .xls, .ods or .odt

icon_openoffice
Hi :)

It's simple. Just 4 steps:

  1. Save a copy of the file as ODS (OpenOffice.org Spreadsheet).

  2. Change the filetype of the copy to ZIP (for example rename File.xls to File.zip).

  3. Open the ZIP.

  4. In the directory called Pictures will be the images, just as in the original.



Update
For newser versions, it works also to save it as xlsx and rename to zip later. Extract it and in the embedded folder you'll find a mediafolder containing your pictures.

3 comments:

  1. Great tip, I love hackable binary formats that let you do this kind of stuff. Saved me hours of redoing the pcitures in my .odt.

    ReplyDelete
  2. hey saeid!
    i'm glad too see your english blog.
    i really needed an article about extracting these image formats.
    it's very simple :)

    ReplyDelete
  3. Thanks a million bro i needed to get a image from .odt file and this just saved my life!

    jazak allah khair

    Ramadan kareem

    ReplyDelete