xlHtml

Home Page      Status     Downloads     Man Page     FAQs     Source      Mail List
 

 

      
  Over the past few months, I've received many questions about the program. This is a collection of the most common questions and their answers.  
   
 
  1. I get an error message when compiling the program that says "to get a new compiler"
  2. How can I export all rows/columns ? xlHtml gives me an error "Error - Col not in range during extraction"
  3. I´m interested in looking at the equations (rather than the results), is there a "switch" in the program to enable this?
  4. I need a program that converts xls to txt ascii format.
  5. How do I use apache to display xls files.
  6. How do I setup Netscape to use xlHtml to open email attachments.
  7. What Mime Type is excel
  
     
Answers:  
 
  1. The problem that you are seeing comes from the cole library. The error message seems confusing...but here's a fix for  x86 machines. In the top level config.h file, either insert this or replace most of it with this:

    #define SIZEOF_UNSIGNED_CHAR 1
    #define SIZEOF_UNSIGNED_SHORT 2
    #define SIZEOF_UNSIGNED_INT 4
    #define SIZEOF_UNSIGNED_LONG 4
    #define SIZEOF_UNSIGNED_LONG_LONG 8
    #define SIZEOF_FLOAT 4
    #define SIZEOF_DOUBLE 8
    #define SIZEOF_LONG_DOUBLE 12

    This should make it happy.

  2. To get all rows & columns, just give it the -xp:n option where n is the page you are interested in. It will get them all. There is also a commandline option that dumps the page names, numbers, max rows & max columns for the page.
  3. I originally want to view the formula's as text, but as I dug into it, I found that Microsoft actually tokenizes the formulas. Therefore, it would not be easy to show. String formulas, on the other hand,  do store the resulting text - but I haven't had time yet to add that code to the program.
  4. The xlHtml program will output in plain text format also. Just give it the -asc option if you want to read the first page, it would be something like:

    xlHtml -asc -xp:0 file.xls
  5. Apache has the ability to add handlers based on the file extention. You can make apache automagically convert xls file by adding the following in either the VirtualHost section or the global section.

    AddHandler excel-sheet xls
    Action excel-sheet /cgi-bin/xls-handler

    Then put the xls-handler in the cgi-bin directory. xls handler is simply:

    #!/bin/sh
    echo "Content-type: text/html"
    echo
    echo
    /usr/local/bin/xlHtml $PATH_TRANSLATED
  6. a) Go into the Edit Preferences dialog.
    b) Click on the Navigator menu item and select applications.
    c) Find Microsoft Excel Worksheet click it and then click the edit button.
    d) Click on the Application radio button and enter nsxlview %s  You may need to put the full path to the file if it is not in the PATH.
    e) Click on OK and close up. Give it a test by opening the Test.xls file.
  7. Excel primarily uses: application/vnd.ms-excel.
  

 

This page was last updated: 05/07/02