• Excel转PDF方法


    引用:

    using Microsoft.Office.Interop.Excel;
    

    方法:

    //// <summary>
            /// Excel转PDF
            /// </summary>
            /// <param name="sourcePath">需要转换的文件路径和文件名称</param>
            /// <param name="targetPath">转换完成后的文件的路径和文件名名称</param>
            /// <returns></returns>
            public static bool ExcelToPdf(string sourcePath, string targetPath)
            {
                bool result = false;
                XlFixedFormatType xlTypePDF = XlFixedFormatType.xlTypePDF;//转换成pdf
                object missing = Type.Missing;
                Microsoft.Office.Interop.Excel.ApplicationClass applicationClass = null;
                Workbook workbook = null;
                try
                {
                    applicationClass = new Microsoft.Office.Interop.Excel.ApplicationClass();
                    string inputfileName = sourcePath;//需要转格式的文件路径
                    string outputFileName = targetPath;//转换完成后PDF文件的路径和文件名名称
                    XlFixedFormatType xlFixedFormatType = xlTypePDF;//导出文件所使用的格式
                    XlFixedFormatQuality xlFixedFormatQuality = XlFixedFormatQuality.xlQualityStandard;//1.xlQualityStandard:质量标准,2.xlQualityMinimum;最低质量
                    bool includeDocProperties = true;//如果设置为True,则忽略在发布时设置的任何打印区域。
                    bool openAfterPublish = false;//发布后不打开
                    workbook = applicationClass.Workbooks.Open(inputfileName, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
                    if (workbook != null)
                    {
                        workbook.ExportAsFixedFormat(xlFixedFormatType, outputFileName, xlFixedFormatQuality, includeDocProperties, openAfterPublish, missing, missing, missing, missing);
                    }
    
                    result = true;
                }
                catch
                {
                    result = false;
                }
                finally
                {
                    if (workbook != null)
                    {
                        workbook.Close(true, missing, missing);
                        workbook = null;
                    }
                    if (applicationClass != null)
                    {
                        applicationClass.Quit();
                        applicationClass = null;
                    }
                }
    
                return result;
            }
    

     

    【原文出处】http://www.51aras.com/?id=22 

       

  • 相关阅读:
    学号 20172328 《程序设计与数据结构》第八周学习总结
    172328 结对编程练习_四则运算 第一周 阶段总结
    学号 20172328 《程序设计与数据结构》实验二报告
    20172328《程序设计与数据结构》第七周学习总结
    Educoder
    Educoder
    Educoder
    Educoder
    Educoder
    Educoder
  • 原文地址:https://www.cnblogs.com/61007257Steven/p/11121179.html
Copyright © 2020-2023  润新知