xlHtml

Home Page      Status     Downloads     Man Page     FAQs      Source     Mail List
 

 

 
  NOTE: THIS PAGE IS NO LONGER MAINTAINED. THE ONGOING XLHTML DEVELOPMENT HAS MOVED AND CAN BE FOUND AT http://chicago.sourceforge.net/xlhtml

What is xlHtml?
xlHtml is an Excel 95 and later file converter. It's html output can be used as a Netscape Plugin to let you view xls e-mail attachments. It can also extract regions of a spreadsheet and convert the spreadsheet to pure text or XML rather than html. xlHtml is an Open Source project with the software being distributed under the GNU General Public License. I used to work in the CLCS Project at the Kennedy Space Center and used a Sun UltraSparc running Solaris. The problem was that people kept sending me  #%$@*!   Word Docs and Excel Spreadsheets...thus the inspiration...

 
 
  So...how does it Look?
I used Excel97's "Save As Html" function on test.xls and this is what it looks like (74K).
And here's xlHtml-0.4's rendering (16K) of the same file.
 
 
  What's Happenin'...
*Dec 9
- New development source released. Includes --help etc &   a fix for malformed font names.  0.4.9.0 is here.

*Dec 3
- New release is finally out. Removed spurrious tabs in closing tags of XML output, fixed up some issues with trimming the edges & signed / unsigned comparisons. Reduced structure sizes a little. Added patches for doxygen generated documentation, updated xldump utility, and added xlcdump utility which dumps chart information. Added patch from Rafael Kitover to support String Formulas. Also attempted to fix unsupported numeric fields from truncating to MAXINT. CSV bug fixes...not escaping currency fields or unknown fields. Also, fixed a bug in the Cell Merging code where whole rows were selected. Also attempted to fix mailto: hyperlinks. Now supports custom colors & new command line option to suppress header & body tags. Fixed bug in tab delimited output so it doesn't end line with a tab. Added bug fix for blank cells when outputting CSV. Added a negative position check in cole_fread(). Also this release uses 75% of the memory and translates spreadsheets that are 2% smaller in size than the 0.3 release. This release also contains a contributed script for mutt.  0.4 is here.

I am also releasing a chart utility. It is intended for cgi-bin usage and does not integrate with xlhtml without some scripting. The basic idea is to search the Excel file for Chart objects. Grab the page & rows & columns for the data sets. Next run xlhtml to extract the ranges, and finally emit a html page. The chart program, xlchart, would be passed the chart type, data, colors, labels, etc. It would render the chart after the script has finished. If you get a script working, I would like to add it to the package. The chart program depends on gdchart. I have a copy here for convenience.

*Oct 21
- xlhtml now has a mailing list at yahoo. New development series kicking off. This version will attempt to address memory constraints, portability, and data formatting. With these goals in mind, I need testers for 64 bit support. This would be Itanium Linux, Alpha Linux, True64, 64-bit Solaris, and others. This release contains my first shot at it...and I would like feedback if anyone has access to those systems.

*Oct 19 -
New version, 0.3, is released!  This version is long overdue mostly because I completely  reworked xinetd. If you noticed all the xinetd releases this summer, I was right in the middle of it. xinetd is much better now so I'm back into xlhtml. This version has many new features and lots of bug fixes.

The biggest change is that the program name is now all lowercase letters. If you have developed scripts for the old name, you can make a symlink from xlHtml to xlhtml. This change was made so that it is easier to use from the command line or to find the man pages.

Also, libtool is no longer used and the cole library has been changed to a static compile. See the ChangeLog for details about what's in the new release. I would like to thank Jason Venner and Rob Arnold for the XML & CSV patches respectively. There are still patches in the queue for more new features, but this release already has a lot. New things will follow soon. :)

 
 
  Needed...
The program can now be interfaced to gnuplot. There's a demo file, gpdemo, that shows one way to do it to Test.xls .If you create a generic GPL'd perl script that renders charts with this facility and are in the sharing mood, please send it as I would like to add it to the distribution.
 
 

If you have comments, thoughts, suggestions, poetry, or bug reports please
write to Steve Grubb at:   linux_4ever@yahoo.com or visit my home page or
my site dedicated to trinary/ternary computer logic www.trinary.cc - exercise that gray matter !

 

 

This page was last updated: 10/16/04