Excel转Html-使用Spire.XLS

Spire.XLS

Spire.XLS是一个基于.NET的组件，可以把Excel很好的转为html。

using Spire.Xls;
Workbook workbook = new Workbook();
workbook.LoadFromFile(filename);

string temp_outputfilename = “tmp.html”;
//convertExceltoHTML
Worksheet sheet = workbook.Worksheets[0];
sheet.SaveToHtml(temp_outputfilename);

//操作html，去掉水印
string sss = File.ReadAllText(temp_outputfilename);
string stroutput = sss.Replace(“Evaluation Warning:The Document was created with Spire.XLS for .NET”, “”);
File.WriteAllText(outputfilename, stroutput);//保存结果
File.Delete(temp_outputfilename);//删除临时文件