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进行处理,非常感谢!