在工作中,有时我们需要转换文档的格式,之前已经跟大家介绍过了如何将Excel转换为PDF。今天将与大家分享如何将Excel转换为Text。这次我使用的依然是免费版的Spire.XLS for .NET组件。
Free Spire.XLS for .NET组件可以使开发人员在任何.NET应用程序上创建、管理和操作Excel文档。即使不安装Microsoft Office,它也能将Excel转换为PDF,HTML,Image,CSV以及XML等。如需下载,请访问:https://www.e-iceblue.com/Download/download-excel-for-net-free.html
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:UsersAdministratorDesktop国家分布.xlsx");
Worksheet sheet = workbook.Worksheets[0];
sheet.SaveToFile("ExceltoTxt.txt"," 以下是转换前和转换后的对比图:
????????????????????????????????????????????????????????????????????????? 转换前
??????????????????????????????????????????????????????????????????? 转换后
??????????
?
C#完整代码:
using Spire.Xls;
System;
System.Collections.Generic;
System.Linq;
System.Text;
namespace excel_to_text
{
class Program
{
static void Main(string[] args)
{
Workbook workbook = new Workbook();
workbook.LoadFromFile(");
Worksheet sheet = workbook.Worksheets[0];
sheet.SaveToFile(,Encoding.UTF8);
}
}
}
?
VB.NET完整代码:
Imports Spire.Xls
System.Collections.Generic
System.Linq
System.Text
Namespace excel_to_text
Class Program
Private Shared Sub Main(args As String())
Dim workbook New Workbook()
workbook.LoadFromFile()
Dim sheet As Worksheet = workbook.Worksheets()
sheet.SaveToFile(End Sub
End Class
End Namespace
感谢您的浏览。
(编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!