Spire.XLS支持加载CSV文件并保存为Excel或PDF文件。本教程将介绍如何使用带有C#和VB.NET的Spire.XLS将CSV转换为PDF。
示例CSV文件如下所示:

Step 1:
Workbook wb = new Workbook();wb.LoadFromFile("SampleCSVFile.csv", ",",1,1);
Step 2:
wb.ConverterSetting.SheetFitToPage = true;
Step 3:
Worksheet sheet = wb.Worksheets[0];for (int i = 1; i < sheet.Columns.Length; i++){ sheet.AutoFitColumn(i);}
Step 4:
sheet.SaveToPdf("toPDF.pdf");
输出:

完整代码:
[C#]
Workbook wb = new Workbook();wb.LoadFromFile("SampleCSVFile.csv", ",",1,1);wb.ConverterSetting.SheetFitToPage = true;Worksheet sheet = wb.Worksheets[0];for (int i = 1; i < sheet.Columns.Length; i++){ sheet.AutoFitColumn(i);}sheet.SaveToPdf("toPDF.pdf");
[VB.NET]
Dim wb As New Workbook()wb.LoadFromFile("SampleCSVFile.csv", ",", 1, 1)wb.ConverterSetting.SheetFitToPage = TrueDim sheet As Worksheet = wb.Worksheets(0)For i As Integer = 1 To sheet.Columns.Length - 1 sheet.AutoFitColumn(i)Nextsheet.SaveToPdf("toPDF.pdf")
Spire.XLS
标签:Excel
声明:本站部分文章及图片源自用户投稿,如本站任何资料有侵权请您尽早请联系jinwei@zod.com.cn进行处理,非常感谢!