1、 Excel转PDF 1.1 转整个Excel工作簿为PDFC#//创建一个Wordbook类对象，并加载需要转换的Excel文档Workbook workbook = new Workbook();workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\test.xlsx",ExcelVersion.Version2010);//将Excel文档保存为PDF，并打开转换后的PDF文档workbook.SaveToFile("result.pdf", Spire.Xls.FileFormat.PDF);System.Diagnostics.Process.Start("result.pdf");1.2 转指定工作表为PDFC#//创建工作簿并加载Excel文档Workbook workbook = new Workbook();workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\Sample.xlsx");//获取第一个工作表Worksheet sheet = workbook.Worksheets[0];//保存为PDF并打开文档sheet.SaveToPdf("toPDF.pdf");System.Diagnostics.Process.Start("toPDF.pdf");
2、 Excel转Image2.1 将工作表为ImageC#//初始化一个Workbook实例，并加载一个工作簿文件Workbook workbook = new Workbook();workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\Sample.xlsx");//将第一张工作表保存为图片Worksheet sheet = workbook.Worksheets[0];sheet.SaveToImage("sample.jpg");2.2 转指定范围的单元格为ImageC#//创建一个Workbook类实例，并从文件中加载一个工作表Workbook workbook = new Workbook();workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\test.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);
3、 Excel转HtmlC#//创建一个workbook类对象并加载Excel文档Workbook workbook = new Workbook();workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\sample.xlsx");//获取第一个工作表Worksheet sheet = workbook.Worksheets[0];//保存为Html文件并打开文档sheet.SaveToHtml("sample.html");System.Diagnostics.Process.Start("sample.html");
4、 Excel转 TXTC#Workbook workbook = new Workbook();workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\sample1.xlsx");Worksheet sheet = workbook.Worksheets[0];sheet.SaveToFile("ExceltoTxt.txt", " ", Encoding.UTF8);
5、 Excel转XMLC#Workbook wb = new Workbook();wb.LoadFromFile(@"C:\Users\Administrator\Desktop\sample1.xlsx");wb.SaveAsXml("result.xml");
6、 Excel转XPSC#Workbook workbook = new Workbook();workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\sample.xlsx", ExcelVersion.Version2010);workbook.SaveToFile("result.xps", Spire.Xls.FileFormat.XPS);
7、 Excel转CSVC#Workbook workbook = new Workbook();workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\test.xlsx");Worksheet sheet = workbook.Worksheets[0];sheet.SaveToFile("sample.csv", " ", Encoding.UTF8);
8、 Excel转ODSC#Workbook workbook = new Workbook();workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\test.xlsx");workbook.SaveToFile("Result.ods", FileFormat.ODS);
9、 Excel转SVGC#//创建一个Wordkbook类对象并加载Excel文档 Workbook workbook = new Workbook(); workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\Sample.xlsx");//遍历Excel工作簿，调用方法ToSVGStream()将文件保存到流，并通过流创建SVG文件 for (int i = 0; i < workbook.Worksheets.Count; i++) { FileStream fs = new FileStream(string.Format("E:\\Program Files\\sheet-{0}.svg", i), FileMode.Create); workbook.Worksheets[i].ToSVGStream(fs, 0, 0, 0, 0); fs.Flush(); fs.Close(); }
10、 Excel转 EMFC#//初始化Workbbok类实例，并加载Excel文档Workbook workbook = new Workbook();workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\test.xlsx");//获取第一个工作表Worksheet sheet = workbook.Worksheets[0];//将指定大小范围的工作表保存为Emf格式sheet.SaveToEMFImage("result.emf", 1, 1, 19, 6, System.Drawing.Imaging.EmfType.EmfPlusDual);
11、 Excel转XLSMC#Workbook workbook = new Workbook();workbook.LoadFromFile(@"C:\Users\Administrator\Desktop\test.xlsx", ExcelVersion.Version97to2003);workbook.SaveToFile("result.xlsm", FileFormat.Version2007);
