12/28/2007 Web Developer

Sometimes we have to list a mass of data or tables on webpages to prove our point of view, exporting Excel file to the internet is absolutely an necessary thing to us. Now let's learn how to export excel to web with Excel2HTML Interactive.

 

Step1: Install and Launch Excel2HTML Interactive.

To install this excel-to-web tool is easy and staightforward, just by following the navigation, you could easily finish that(If you don't have the setup file, click here to download the free trail version). Once Excel2HTML Interactive is installed, you can see an additional toolbar in Excel

.

 

Step2: Set the Parameters.

Click "Options", there will pop up a dialog box, it offers many parameters for users to tweak. See as follows:



1. Set the "Export".

To use custom colors as the background:

· Select Use custom colors.
· Then select appropriate colors for the table.

To save default Excel cells formatting leave Font name, Font size, Font color, Font style check boxes selected. When the check boxes are cleared, then default web page settings will be used.
When a table has Internet links in a column there are two possibilities to export. To open links in a new browser window select Open links in new window.

2. Set the "Page header".

There are several controls at the exported web page such as search edit box, columns list, etc. Each control has a description text near it or inside it. If it is required to change the text to your own or to translate to a language different from English:



a. Open Options dialog box
b. Select Page header tab
c. Change appropriate text to your own

3. Set the "Progress messages".

Each action at the web page that may take longer than a moment shows a progress dialog with the information message regarding what the program is currently doing. These messages are defined for load, sort and search events. The texts for these messages are also customizable.



a. Open Options dialog
b. Open Progress messages tab
c. Change appropriate text to your own

 

Step3: Start Conversion.

To start converting simply select a table (an area at the sheet) and click the Convert button.




The Convert wizard will be open. At the first wizard page the wizard will suggest a name for the HTML file name and page title. The suggested name and title are based in the sheet name.
If the name and title are appropriate, then click Next to start conversion; in the other case, select appropriate names.

 

Download the free trail vesion first, then try it yourself, if you like it, you could click here to order the full version.