xlhtml(1) A program for converting Microsoft Excel Files .xls


xlhtml [-a] [-asc] [-csv] [-xml] [-bcNNNNNN] [-bi/path] [-c] [-dp] [-v] [-fw] [-m] [-nc] [-nh] [-tcNNNNNN] [-te] [-xc:N-N] [-xp:N] [-xr:N-N] FILE


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 commandline interface.


aggressively optimize html by removing </TR> </TD> or VALIGN="bottom". Some older browsers may not display properly in this mode.
Ascii out of -dp and extraction data (-xc, -xp, -xr)
Output in Comma Separated Values of -dp and extraction data (-xc, -xp, -xr)
Output in XML of -dp and extraction data (-xc, -xp, -xr)
Override the background color. e.g. -bc808080 for gray
Use background image. e.g. -bi/home/httpd/icon/tar.gif
Centers the tables horizontally
Dump page count and max columns and rows per page
Prints program version
suppress formula warnings about accuracy
No encoding for multibyte
tells it not to colorize the output.
Suppress header and body tags in html output
Override the text color. e.g. -tcFF0000 for red
Trims empty rows & columns at the edges of a worksheet
Columns (separated by a dash) for extraction (zero based)
Page for extraction (zero based), one page only
Rows (separated by a dash) to be extracted (zero based)

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: \n\n


Steve Grubb, Charles N Wyble