xlhtml(1)xlhtml(1)NAMExlhtml - A program for converting Microsoft Excel Files .xls
SYNOPSISxlhtml
[-nc][-a][-fw][-bcNNNNNN][-tcNNNNNN][-bi/path][-c][-te][-v][-m][-asc][-dp][-xp:N][-xc:N][-xr:N][-xml][-csv]
DESCRIPTION
This manual page explains the xlhtml program. The program xlhtml is
used to convert Microsoft Excel Spreadsheet files into either html or
tab delimitted ASCII. The program can be interfaced with helper scripts
for viewing email attachments. Most use of this program is through the
helper scripts and one would probably rarely resort to using the com‐
mandline interface.
OPTIONS-nc tells it not to colorize the output.
-a aggressively optimize html by removing </TR> </TD> or
VALIGN="bottom" Some older browsers may not display properly in
this mode.
-fw suppress formula warnings about accuracy
-bc Override the background color. e.g. -bg808080 for gray
-tc Override the text color. e.g. -tcFF0000 for red
-bi Use background image. e.g. -bi/home/httpd/icon/tar.gif
-c Centers the tables horizontally
-te Trims empty rows & columns at the edges of a worksheet
-v Prints program version
-m No encoding for multibyte
-asc Ascii out of -dp and extraction data (-x?)
-dp Dump page count and max columns and rows per page
-xp Page for extraction (zero based)
-xc Columns (separated by a dash) for extraction (zero based)
-xr Rows (separated by a dash) to be extracted (zero based)
-xml Output in XML
-csv Output in Comma Separated Values
-nh Suppress header and body tags in html output
An example of the extraction command line is: xlhtml-fw-asc
-xp:0 -xr:2-6 -xc:0-1 Test.xls
The extraction output is: Formatted output of cells by column
left to right, columns separated by a tab, end of row is: 0x0A,
end of file:
NOTES
To interface to Netscape Navigator: first locate the help scripts
nsxlview & nsopen. Go into the Edit Preferences dialog box. Click on
the Navigator Category and hilight the Applications menu item. Look for
Microsoft Excel Worksheet. If you don't see it create one. The MIME
type should be: application/vnd.ms-excel The suffixes should be:
xls,xlt,xlm,xld,xla,xlc,xlw,xll In the handled by section of the dia‐
log box, check the Application checkbox and set the path to wherever
the nsxlview helper script is located and pass a %s argument. For exam‐
ple, if nsxlview is located in /usr/local/bin, then you would put:
/usr/local/bin/nsxlview %s
in the Application path box.. (As a side note, make sure the nsxlview
script can find the xlhtml program or it won't work.) Click on the OK
and you are done. You should be able to use the Test.xls file that is
distributed with the program to verify its configured correctly.
AUTHOR
Charles N Wyble
xlhtml October 13, 2001 xlhtml(1)