COMMAND LINE OPTIONS
xlhtml has several command line options that let you tailor its output. The command is
now:
xlhtml [ -nc -a -fw -bc -tc -bi
-c -te -v -m -asc -dp -xp:n -xc:n -xr:n -xml ] file.xls
-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?) Tab delimited.
-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 is in XML
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 |
