C# 将Excel转为PDF时自定义表格纸张大小的代码思路_C#教程

using Spire.Xls;

namespace ExcelToPDFwithCustomPageSize
{
    class Program
    {
        static void Main(string[] args)
        {
            //实例化Workbook类的对象
            Workbook workbook = new Workbook();

            //加载Excel测试文档
            workbook.LoadFromFile("test.xlsx");

            //遍历工作表
            for(int i=0; i<workbook.Worksheets.Count;i++)       
            {
                Worksheet sheet = workbook.Worksheets[i];

                //自定义纸张大小
                sheet.PageSetup.SetCustomPaperSize(620,310);
                
                //保存为PDF格式
                workbook.SaveToFile("ToPDF.pdf", FileFormat.PDF);
            }
            
        }
    }
}

Imports Spire.Xls

Namespace ExcelToPDFwithCustomPageSize
    Class Program
        Private Shared Sub Main(args As String())
            '实例化Workbook类的对象
            Dim workbook As New Workbook()

            '加载Excel测试文档
            workbook.LoadFromFile("test.xlsx")

            '遍历工作表
            For i As Integer = 0 To workbook.Worksheets.Count - 1
                Dim sheet As Worksheet = workbook.Worksheets(i)

                '自定义纸张大小
                sheet.PageSetup.SetCustomPaperSize(620, 310)

                '保存为PDF格式
                workbook.SaveToFile("ToPDF.pdf", FileFormat.PDF)
            Next

        End Sub
    End Class
End Namespace