128 lines
3.3 KiB
Groff
128 lines
3.3 KiB
Groff
.\"Created with GNOME Manpages Editor Wizard
|
|
.\"http://gmanedit.sourceforge.net
|
|
.\"Sergio Rua <srua@gpul.org>
|
|
.\"Updated by hand of Vaclav Dvorak <dvorakv@idas.cz>
|
|
.\"
|
|
.TH xlhtml 1 "May 15, 2002" "xlhtml"
|
|
|
|
.SH NAME
|
|
xlhtml \- A program for converting Microsoft Excel Files .xls
|
|
|
|
.SH SYNOPSIS
|
|
.B xlhtml
|
|
.RB [ \-nc ]
|
|
.RB [ \-a ]
|
|
.RB [ \-fw ]
|
|
.RB [ \-bc\fINNNNNN\fP ]
|
|
.RB [ \-tc\fINNNNNN\fP ]
|
|
.RB [ \-bi\fI/path\fP ]
|
|
.RB [ \-c ]
|
|
.RB [ \-te ]
|
|
.RB [ \-v ]
|
|
.RB [ \-m ]
|
|
.RB [ \-asc ]
|
|
.RB [ \-dp ]
|
|
.RB [ \-xp:\fIN\fP ]
|
|
.RB [ \-xc:\fIN\fP ]
|
|
.RB [ \-xr:\fIN\fP ]
|
|
.RB [ \-xml ]
|
|
.RB [ \-csv ]
|
|
.RB \fIFILE\fP
|
|
.br
|
|
|
|
.SH DESCRIPTION
|
|
This manual page explains the
|
|
.B xlhtml
|
|
program. The program
|
|
.B 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.
|
|
|
|
.SH OPTIONS
|
|
.TP
|
|
.BR \-nc
|
|
tells it not to colorize the output.
|
|
.TP
|
|
.BR \-a
|
|
aggressively optimize html by removing </TR> </TD> or VALIGN="bottom". Some
|
|
older browsers may not display properly in this mode.
|
|
.TP
|
|
.BR \-fw
|
|
suppress formula warnings about accuracy
|
|
.TP
|
|
.BR \-bc
|
|
Override the background color. e.g. -bg808080 for gray
|
|
.TP
|
|
.BR \-tc
|
|
Override the text color. e.g. -tcFF0000 for red
|
|
.TP
|
|
.BR \-bi
|
|
Use background image. e.g. -bi/home/httpd/icon/tar.gif
|
|
.TP
|
|
.BR \-c
|
|
Centers the tables horizontally
|
|
.TP
|
|
.BR \-te
|
|
Trims empty rows & columns at the edges of a worksheet
|
|
.TP
|
|
.BR \-v
|
|
Prints program version
|
|
.TP
|
|
.BR \-m
|
|
No encoding for multibyte
|
|
.TP
|
|
.BR \-asc
|
|
Ascii out of -dp and extraction data (-x?)
|
|
.TP
|
|
.BR \-dp
|
|
Dump page count and max columns and rows per page
|
|
.TP
|
|
.BR \-xp
|
|
Page for extraction (zero based)
|
|
.TP
|
|
.BR \-xc
|
|
Columns (separated by a dash) for extraction (zero based)
|
|
.TP
|
|
.BR \-xr
|
|
Rows (separated by a dash) to be extracted (zero based)
|
|
.TP
|
|
.BR \-xml
|
|
Output in XML
|
|
.TP
|
|
.BR \-csv
|
|
Output in Comma Separated Values
|
|
.TP
|
|
.BR \-nh
|
|
Suppress header and body tags in html output
|
|
.PP
|
|
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
|
|
|
|
.SH 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 dialog box,
|
|
check the Application checkbox and set the path to wherever the nsxlview helper
|
|
script is located and pass a %s argument. For example, 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.
|
|
|
|
.SH AUTHOR
|
|
Steve Grubb,
|
|
Charles N Wyble
|