Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages


home | help
xlhtml(1)		    General Commands Manual		     xlhtml(1)

       xlhtml -	A program for converting Microsoft Excel Files .xls

       xlhtml					[-nc][-a][-fw][-bcNNNNNN][-tc-

       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.

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

       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/   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.

       Charles N Wyble

xlhtml			       October 13, 2001			     xlhtml(1)


Want to link to this manual page? Use this URL:

home | help