在日常工作中可能会遇到将某文件转换为其他格式的文件的情况,在本篇文章中将介绍如何在C#程序中将Excel文档转为PDF、IMAGE、HTML、TXT、XML、XPS、CSV、ODS、SVG、EMF、XLSM等格式的文件。
工具使用:Free Spire.XLS http://for.NET(免费版)
安装www.e-iceblue.cn![ea281f19a6157d063fe55b0118dd8d9b.png](https://i-blog.csdnimg.cn/blog_migrate/c177713798fd028888266afc82154c25.png)
安装后,在VS程序中添加引用Spire.XLS.dll即可(该dll可在安装文件下的Bin文件夹中获取)
下面将作详细介绍:
- Excel转PDF(该组件也支持将Excel文档里的图表、形状、SmartArt图形以及图像转换为PDF)
1.1 转整个Excel工作簿为PDF
//创建一个Wordbook类对象,并加载需要转换的Excel文档
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:UsersAdministratorDesktoptest.xlsx",ExcelVersion.Version2010);
//将Excel文档保存为PDF,并打开转换后的PDF文档
workbook.SaveToFile("result.pdf", Spire.Xls.FileFormat.PDF);
System.Diagnostics.Process.Start("result.pdf");
![d44ce222cd1ef9392b2d193923ae9743.png](https://i-blog.csdnimg.cn/blog_migrate/10faab3828d9e4d32965fc7d2f229de4.jpeg)
1.2 转指定工作表为PDF
//创建工作簿并加载Excel文档
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:UsersAdministratorDesktopSample.xlsx");
//获取第一个工作表
Worksheet sheet = workbook.Worksheets[0];
//保存为PDF并打开文档
sheet.SaveToPdf("toPDF.pdf");
System.Diagnostics.Process.Start("toPDF.pdf");
![a9c8006b7eec00bc09d18afa2a340bb0.png](https://i-blog.csdnimg.cn/blog_migrate/d93f30e7412673c23dcc5497305b13f3.jpeg)
2. Excel转Image
2.1将工作表为Image
//初始化一个Workbook实例,并加载一个工作簿文件
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:UsersAdministratorDesktopSample.xlsx");
//将第一张工作表保存为图片
Worksheet sheet = workbook.Worksheets[0];
sheet.SaveToImage("sample.jpg");
![311a41f3ae8d23c974a2cafcd3f6e6a0.png](https://i-blog.csdnimg.cn/blog_migrate/db6c723b5ada6b8902b6e24863bf5fd0.jpeg)
2.2转指定范围的单元格为Image
//创建一个Workbook类实例,并从文件中加载一个工作表
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:UsersAdministratorDesktoptest.xlsx");
//获取文档中的第一个工作表
Worksheet sheet = workbook.Worksheets[0];
//指定单元格范围,保存为想要的图片格式
sheet.SaveToImage(3, 1, 4, 3).Save("image1.png", ImageFormat.Png);
sheet.SaveToImage(5, 1, 19,3).Save("image2.jpeg", ImageFormat.Jpeg);
sheet.SaveToImage(20, 1, 21, 3).Save("image3.bmp", ImageFormat.Bmp);
sheet.SaveToImage(22, 1, 23, 3).Save("image4.bmp", ImageFormat.Bmp);
![ff654cc5b09f2f9c89724d608e9f20b3.png](https://i-blog.csdnimg.cn/blog_migrate/646f27c1ab7a9eba71d564e8a7b3102d.jpeg)
3. Excel转HTML
//创建一个workbook类对象并加载Excel文档
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:UsersAdministratorDesktopsample.xlsx");
//获取第一个工作表
Worksheet sheet = workbook.Worksheets[0];
//保存为Html文件并打开文档
sheet.SaveToHtml("sample.html");
System.Diagnostics.Process.Start("sample.html");
![59bc0c2bee012fbde93789764c460aa6.png](https://i-blog.csdnimg.cn/blog_migrate/406475de52ea323bb9dce242ac337122.jpeg)
4. Excel转 TXT
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:UsersAdministratorDesktopsample1.xlsx");
Worksheet sheet = workbook.Worksheets[0];
sheet.SaveToFile("ExceltoTxt.txt", " ", Encoding.UTF8);
![9c1bf3e4dd72fd20455ebef7292d6e2b.png](https://i-blog.csdnimg.cn/blog_migrate/b153a6994f72a6dc95d6a0c677d06820.jpeg)
5. Excel转XML
Workbook wb = new Workbook();
wb.LoadFromFile(@"C:UsersAdministratorDesktopsample1.xlsx");
wb.SaveAsXml("result.xml");
![5eb078c501ad0fe2cffa040d3e7a1583.png](https://i-blog.csdnimg.cn/blog_migrate/0efd1f25091f46ac517172fbdb8e2084.jpeg)
6. Excel转XPS
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:UsersAdministratorDesktopsample.xlsx", ExcelVersion.Version2010);
workbook.SaveToFile("result.xps", Spire.Xls.FileFormat.XPS);
![0b6fe54f3670012eb9df41662c2eec14.png](https://i-blog.csdnimg.cn/blog_migrate/b690fb637e6fc247cb9b47affeb05272.png)
7. Excel转CSV
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:UsersAdministratorDesktoptest.xlsx");
Worksheet sheet = workbook.Worksheets[0];
sheet.SaveToFile("sample.csv", " ", Encoding.UTF8);
![1bc346e3261067f65e682bacdede681e.png](https://i-blog.csdnimg.cn/blog_migrate/240147c77808479ff869a18798f65d77.jpeg)
8. Excel转ODS
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:UsersAdministratorDesktoptest.xlsx");
workbook.SaveToFile("Result.ods", FileFormat.ODS);
![b1c99f1b9734ee269fa6d990405896c8.png](https://i-blog.csdnimg.cn/blog_migrate/77db772a9642d5bb400548a0c94a335a.jpeg)
9. Excel转SVG
//创建一个Wordkbook类对象并加载Excel文档
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:UsersAdministratorDesktopSample.xlsx");
//遍历Excel工作簿,调用方法ToSVGStream()将文件保存到流,并通过流创建SVG文件
for (int i = 0; i < workbook.Worksheets.Count; i++)
{
FileStream fs = new FileStream(string.Format("E:Program Filessheet-{0}.svg", i), FileMode.Create);
workbook.Worksheets[i].ToSVGStream(fs, 0, 0, 0, 0);
fs.Flush();
fs.Close();
}
![af42f98b3a88d56e3e651e137116255d.png](https://i-blog.csdnimg.cn/blog_migrate/d0b4678ff7eb954ff4f67b7d1d8bc283.png)
10. Excel转 EMF
//初始化Workbbok类实例,并加载Excel文档
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:UsersAdministratorDesktoptest.xlsx");
//获取第一个工作表
Worksheet sheet = workbook.Worksheets[0];
//将指定大小范围的工作表保存为Emf格式
sheet.SaveToEMFImage("result.emf", 1, 1, 19, 6, System.Drawing.Imaging.EmfType.EmfPlusDual);
![5eea252b0135c948fd05800fac433d62.png](https://i-blog.csdnimg.cn/blog_migrate/ba2705585dcb853511d376f840b1e80c.png)
11. Excel转XLSM
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"C:UsersAdministratorDesktoptest.xlsx", ExcelVersion.Version97to2003);
workbook.SaveToFile("result.xlsm", FileFormat.Version2007);
![8ca27bc10a042b1729c67359cb2251be.png](https://i-blog.csdnimg.cn/blog_migrate/820761ad8e66f6406422c469b237b3ac.jpeg)
以上全部内容是本次关于Excel转换为PDF、IMAGE、HTML、TXT、XML、XPS、CSV、ODS、SVG、EMF、XLSM等格式文件的方法介绍.
End.