C# 、VB 将Excel转为PDFA/1B

1、可通过E-iceblue中文官网下载10.10.6版本的hotfix，下载后，解压到指定路径，完成解压后，将文件夹Bin下的Spire.Xls.dll和Spire.Pdf.dll文件添加引用到VS程序（如下图）：

1、using Spire.Xls;

namespace ExceltoPDFA1B

{

    class Program

    {

        static void Main(string[] args)

        {

            //加载Excel测试文档

            Workbook wb = new Workbook();

            wb.LoadFromFile("sample.xlsx", ExcelVersion.Version2013);

            //将Excel保存为Pdf_A1B格式

            wb.ConverterSetting.PdfConformanceLevel = Spire.Pdf.PdfConformanceLevel.Pdf_A1B;

            wb.SaveToFile("result.pdf", Spire.Xls.FileFormat.PDF);

            System.Diagnostics.Process.Start("result.pdf");

        }

    }

}

2、文档转换结果：

1、Imports Spire.Xls

Namespace ExceltoPDFA1B

               Class Program

                   Private Shared Sub Main(args As String())

                            '加载Excel测试文档

                            Dim wb As New Workbook()

                            wb.LoadFromFile("sample.xlsx", ExcelVersion.Version2013)

                            '将Excel保存为Pdf_A1B格式

                            wb.ConverterSetting.PdfConformanceLevel = Spire.Pdf.PdfConformanceLevel.Pdf_A1B

                            wb.SaveToFile("result.pdf", Spire.Xls.FileFormat.PDF)

                            System.Diagnostics.Process.Start("result.pdf")

                   End Sub

               End Class

End Namespace