1xlhtml(1)                   General Commands Manual                  xlhtml(1)
2
3
4

NAME

6       xlhtml - A program for converting Microsoft Excel Files .xls
7
8

SYNOPSIS

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

DESCRIPTION

15       This  manual  page  explains  the xlhtml program. The program xlhtml is
16       used to convert Microsoft Excel Spreadsheet files into either  html  or
17       tab delimitted ASCII. The program can be interfaced with helper scripts
18       for viewing email attachments. Most use of this program is through  the
19       helper  scripts  and one would probably rarely resort to using the com‐
20       mandline interface.
21
22

OPTIONS

24       -nc    tells it not to colorize the output.
25
26       -a     aggressively  optimize  html  by   removing   </TR>   </TD>   or
27              VALIGN="bottom"  Some older browsers may not display properly in
28              this mode.
29
30       -fw    suppress formula warnings about accuracy
31
32       -bc    Override the background color. e.g. -bg808080     for gray
33
34       -tc    Override the text color. e.g. -tcFF0000     for red
35
36       -bi    Use background image. e.g. -bi/home/httpd/icon/tar.gif
37
38       -c     Centers the tables horizontally
39
40       -te    Trims empty rows & columns at the edges of a worksheet
41
42       -v     Prints program version
43
44       -m     No encoding for multibyte
45
46       -asc   Ascii out of -dp and extraction data (-x?)
47
48       -dp    Dump page count and max columns and rows per page
49
50       -xp    Page for extraction (zero based)
51
52       -xc    Columns (separated by a dash) for extraction (zero based)
53
54       -xr    Rows (separated by a dash) to be extracted (zero based)
55
56       -xml   Output in XML
57
58       -csv   Output in Comma Separated Values
59
60       -nh    Suppress header and body tags in html output
61
62              An example of the extraction command line is:  xlhtml  -fw  -asc
63              -xp:0 -xr:2-6 -xc:0-1 Test.xls
64
65              The  extraction  output  is: Formatted output of cells by column
66              left to right, columns separated by a tab, end of row is:  0x0A,
67              end of file:
68
69

NOTES

71       To  interface  to  Netscape  Navigator:  first  locate the help scripts
72       nsxlview & nsopen. Go into the Edit Preferences dialog  box.  Click  on
73       the Navigator Category and hilight the Applications menu item. Look for
74       Microsoft Excel Worksheet. If you don't see it  create  one.  The  MIME
75       type  should  be:   application/vnd.ms-excel   The  suffixes should be:
76       xls,xlt,xlm,xld,xla,xlc,xlw,xll  In the handled by section of the  dia‐
77       log  box,  check  the Application checkbox and set the path to wherever
78       the nsxlview helper script is located and pass a %s argument. For exam‐
79       ple, if nsxlview is located in /usr/local/bin, then you would put:
80
81       /usr/local/bin/nsxlview %s
82
83       in  the  Application path box.. (As a side note, make sure the nsxlview
84       script can find the xlhtml program or it won't work.)  Click on the  OK
85       and  you  are done. You should be able to use the Test.xls file that is
86       distributed with the program to verify its configured correctly.
87
88

AUTHOR

90       Charles N Wyble
91
92
93
94xlhtml                         October 13, 2001                      xlhtml(1)
Impressum