Home > Article > Web Front-end > How to convert Excel files to Html (graphics and text)
My work sometimes involves the processing of financial data. We all know that Excel files are popular and widely used in processing data. ExcelAllows us to perform mathematical calculations on the data stored in it. I use it a lot at work. But when displaying data, using Excel directly is not particularly good. I want to use other formats of files to display to my users. Html is my favorite. So I need to use some methods to convert Excel into Html. I found a free application library on the Internet to meet my needs, which is - Spire.XLS. click here to download.
Introduction
Spire.XLS is a file based on . NET component, using which we can create Excel files, edit existing Excel and convert them ExcelFile. All in all, through it we can easily handle Excel. Let's create a simple Excel file to use it.
First, create a workbook instance. The workbook can display Excel files.
Workbook workbook = new Workbook();
Then get the first workbook.
Worksheet sheet = workbook.Worksheets[0];
Set cell A1 of the first workbook to "TEXT .
#sheet.Range["A1"].Text = "TEST";
Finally, save the file
workbook.SaveToFile("result.xlsx", FileFormat.Version2010);
It is very convenient to create Excel using this library. See the screenshot of the generated file below:
Load the sample file:
workbook.LoadFromFile("sample.xlsx");
Convert the first page of the electronic form to an Html file
sheet.SaveToHtml("result.html");
Original file
Generated Html file
The above is the detailed content of How to convert Excel files to Html (graphics and text). For more information, please follow other related articles on the PHP Chinese website!