Spire系列文档处理API是国产开发工具中功能可媲美Aspose的强大控件,帮助开发者轻松将文档功能集成到应用程序中。临近年终,小编为您倾情献上Spire.XLS在.NET中格式转换的示例教程,记得收藏哦!
将文档从一种格式转换为另一种格式是Spire.XLS的主要功能之一。这种转换只不过是加载和保存操作的组合。因此,使用Spire.XLS可以将文档从任何受支持的加载格式转换为任何受支持的保存格式。
- Excel转PDF
- Excel转HTML
- Excel转图像
- Excel和CSV互转
- Excel转文本
- Excel转xps
- PExcel转.ods
>>你可以点击这里下载Spire.XLS for .NET测试体验。
(篇幅较长,建议收藏阅读)
Excel转PDF
using System;using System.Collections.Generic;using System.Linq;using System.Text;using Spire.Xls;namespace ToPDF{ class Program { static void Main(string[] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile("Sample.xlsx", ExcelVersion.Version2010); workbook.SaveToFile("result.pdf", Spire.Xls.FileFormat.PDF); } }}
Excel转HTML
using Spire.Xls;namespace Xls2Html{ class Program { static void Main(string[] args) { //load Excel file Workbook workbook = new Workbook(); workbook.LoadFromFile(@"....test.xls"); //convert Excel to HTML Worksheet sheet = workbook.Worksheets[0]; sheet.SaveToHtml("sample.html"); //Preview HTML System.Diagnostics.Process.Start("sample.html"); } }}
Excel转图像
using Spire.Xls;namespace Xls2Image{ class Program { static void Main(string[] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile(@"....test.xls"); Worksheet sheet = workbook.Worksheets[0]; sheet.SaveToImage("sample.jpg"); } }}
Excel转CSV
using Spire.Xls;namespace xls2csv{ class Program { static void Main(string[] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile(@"..ExceltoCSV.xls"); Worksheet sheet = workbook.Worksheets[0]; sheet.SaveToFile("sample.csv", ",", Encoding.UTF8); } }}
CSV转Excel
using Spire.Xls;namespace csvtoxls{ class Program { static void Main(string[] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile(@"D:michellemy filecsv2xls.csv", ",", 1, 1); Worksheet sheet = workbook.Worksheets[0]; sheet.Name = "csv to excel"; //set the backgroundcolor=LightBlue of Range["A1:E1"] sheet.Range["A1:E1"].Style.Color = Color.Chocolate; //set the backgroundcolor=LightBlue of Range["A2:E6"] sheet.Range["A2:E6"].Style.Color = Color.SpringGreen; //set the backgroundcolor=Silver of Range["A7:E12"] sheet.Range["A7:E12"].Style.Color = Color.SkyBlue; //set the backgroundcolor=Silver of Range["A13:E19"] sheet.Range["A13:E19"].Style.Color = Color.Yellow; workbook.SaveToFile("result.xls", ExcelVersion.Version97to2003); } }}
Excel转文本
using Spire.Xls;namespace Excel_to_Txt{ class Program { static void Main(string[] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile(@"..ExceltoTxt.xls"); Worksheet sheet = workbook.Worksheets[0]; sheet.SaveToFile("ExceltoTxt.txt", " ", Encoding.UTF8); } }}
Excel转XPS
using System;using System.Collections.Generic;using System.Linq;using System.Text;using Spire.Xls;namespace ExceltoXPS{ class Program { static void Main(string[] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile("sample.xlsx", ExcelVersion.Version2010); workbook.SaveToFile("result.xps", Spire.Xls.FileFormat.XPS); } }}
Excel转.ods
using Spire.Xls;namespace Convert_Excel_to_ODS{ class Program { static void Main(string[] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile("Sample.xlsx"); workbook.SaveToFile("Result.ods",FileFormat.ODS); } }}
如果您有任何疑问或需求,请随时联系客服,我们很高兴为您提供查询和咨询。
标签:
声明:本站部分文章及图片源自用户投稿,如本站任何资料有侵权请您尽早请联系jinwei@zod.com.cn进行处理,非常感谢!