Detailed explanation of how to convert Excel files to Html (picture)

黄舟
Release: 2017-05-26 16:23:21
Original
3974 people have browsed it

Background

My work sometimes involves the processing of financial data. We all know that Excel files are popular and widely used in processing data. Excel allows 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 to Html. I found a free application library online to meet my needs - Spire.XLS.

Introduction

Spire.XLS is a .NET-based component, using which we can create Excel files, edit existing Excel and convert Excel files. All in all, we can handle Excel easily through it. Let's create a simple Excel file to use it.

First, create a workbook instance. Workbooks can display Excel files.

Workbook workbook = new Workbook();
Copy after login
Copy after login

Then get the first workbook.

Worksheet sheet = workbook.Worksheets[0];
Copy after login

Set cell A1 of the first workbook to "TEXT.

sheet.Range["A1"].Text = "TEST";
Copy after login

Finally, save the file

workbook.SaveToFile("result.xlsx", FileFormat.Version2010);
Copy after login

Use this library to create Excel files Very convenient. Look at the screenshot of the generated file below:

Detailed explanation of how to convert Excel files to Html (picture)

Convert to Html format

In the previous part, I taught you how to create an Excel file . In this part, I will introduce to you how to convert Excel to Html.

First create an electronic workbook instance, which will display the Excel file:

Workbook workbook = new Workbook();
Copy after login
Copy after login

Convert the first page spreadsheet to Html file

workbook.LoadFromFile("sample.xlsx");
Copy after login

Original file


Detailed explanation of how to convert Excel files to Html (picture)Generated Html file

The above is the detailed content of Detailed explanation of how to convert Excel files to Html (picture). For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!