Why do people use Excel just to send screen captures?

Is it only in Japan? Is it because many of us office workers are not allowed to install tools like IrfanView or Gimp? Don't we all prefer to get image as \*.png, \*.jpg or in HTML mail?

Anyway, if you get image in newer MSOffice document format , such as \*.xlsx \*.docx \*.pptx (as opposed to xls,doc,ppt), you may be lucky. These are just zip files, like OpenOffice files are.

This bash function worked to view all images in Excel file without cluttering my home directory. Tested on Solaris10 and Windows(Cygwin+X). This requires ImageMagick's display command.
imginxlsx () 
{ 
    unzip -l $1 | cut -c29- | grep -i --color '\\.png$' | while read image; do
        unzip -p $1 $image | display -geometry +0+0 png:-;
    done
}
Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today