前面我们介绍了如何使用Spire.XLS 将Excel保存为HTML, 该文将介绍如何将HTML格式文件保存为Excel文档。
首先,请查看HTML示例文档
C#
using Spire.Xls;
namespace HTML_to_Excel
{
class Program
{
static void Main(string[] args)
{
//加载示例文档
Workbook workbook = new Workbook();
workbook.LoadFromHtml("Sample.html");
//自适应行高
Worksheet sheet = workbook.Worksheets[0];
sheet.AllocatedRange.AutoFitRows();
//保存文档
workbook.SaveToFile("Result.xlsx",FileFormat.Version2010);
}
}
}
VB.NET
Imports Spire.Xls
Namespace HTML_to_Excel
Class Program
Private Shared Sub Main(ByVal args() As String)
'加载示例文档
Dim workbook As Workbook = New Workbook
workbook.LoadFromHtml("Sample.html")
'自适应行高
Dim sheet As Worksheet = workbook.Worksheets(0)
sheet.AllocatedRange.AutoFitRows
'保存文档
workbook.SaveToFile("Result.xlsx", FileFormat.Version2010)
End Sub
End Class
End Namespace
效果图: