Export Excel to HTML – component for .NET

PRLog (Press Release) - Mar. 7, 2013 - There are a lot of data contained in tables. Time to time, it is required to work with it for viewing, editing and calculations. The best solution is the Microsoft Excel. But when need to present result data on an online document, presentation, or webpage, it is reasonable to convert data into HTML format.

The simplest way to convert Excel to HTML is to use the Excel "Save as Web Page" function. But what if it is needed to convert files inside C#/VB.NET/ASP.NET project and MS Excel is not installed? The best and the fastest way is a using some .Net libraries. One of these libraries is introduced by Elerium Software. Elerium Excel to HTML .NET is a high performance component enabling developer to convert Excel to HTML files. The converter supports the following excel formats: XLS, XLSX, CSV.

First of all, a developer must install Excel to HTML .NET component to the project:

1. Download the latest version of the component from this link: http://www.eleriumsoft.com/Excel_NET/Excel2HTML/Default.aspx
2. Extract the downloaded archive and put the Excel.dll component into /bin folder of the project.
3. Add the component to the “using” section:
using Docs.Excel;
using Docs.Excel.Converting;

When the component is connected to the project, a developer can convert the whole excel spreadsheet or only range of excel cell to HTML file. This code will display how simple to convert full excel spreadsheet to html file:

using System;
using System.Collections.Generic;
using System.Text;
using Docs.Excel;
using Docs.Excel.Converting;
namespace ExportToHTML
{
class Program
{
static void Main(string[] args)
{
//Read excel file.
ExcelWorkbook wbook = ExcelWorkbook.ReadXLSX(@"..\..\..\List.xlsx");
ExcelToHtml converter = new ExcelToHtml(wbook);
//Display mesh grid.
converter.Worksheets[0].ShowGrid = true;
//Save specified worksheet to HTML file.
string html_file = @"..\..\..\ExportExcelToHtml.html";
converter.Worksheets[0].SaveHTML(html_file);
//Open specified file.
System.Diagnostics.Process.Start(html_file);
}
}
}.

For more information about the component please visit the product page:
http://www.eleriumsoft.com/Excel_NET/Excel2HTML/Default.aspx