c# excel转PDF

最新推荐文章于 2026-06-10 11:26:51 发布

原创最新推荐文章于 2026-06-10 11:26:51 发布 · 9.7k 阅读

8 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

C# 开发相关

这篇博客分享了如何使用C#编程实现将Office Excel文档转换为PDF。通过微软.NET平台提供的Office文档支持和COM组件，可以简化这一转换过程。代码示例展示了具体的操作步骤。

PS:

公司的业务中有个超级大的作业就是把OFFICE文档转成PDF,我猜之前没程序猿们，公司那些人应该是一个个手动转。强烈为猿们感叹，帮你们做了这么多事，还在那抱怨....无法满足你们的需求啊；

微软net平台提供了对Office文档非常好的支持；其中有com组件直接集成到了VS中。利用这些API可以快速的免去N多繁琐的工作；

以下代码是翻阅了公司的代码，一个个敲出来的；奉上代码：

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Runtime.InteropServices;

using Microsoft.Office.Interop.Excel;

//Office 命名空间
namespace OfficeToPdf
{
    //excel 类
    class ExcelConverter
    {
        //构造函数
        public ExcelConverter()
        { }

        /// <summary>
        /// 转换excel 成PDF文档
        /// </summary>
        /// <param name="_lstrInputFile">原文件路径</param>
        /// <param name="_lstrOutFile">pdf文件输出路径</param>
        /// <returns>true 成功</returns>
        public bool ConverterToPdf(string _lstrInputFile,string _lstrOutFile)
        {
            Microsoft.Office.Interop.Excel.Application lobjExcelApp = null;            
            Microsoft.Office.Interop.Excel.Workbooks lobjExcelWorkBooks = null;
            Microsoft.Office.Interop.Excel.Workbook lobjExcelWorkBook = null;

            string lstrTemp = string.Empty;
            object lobjMissing = System.Reflection.Missing.Value;

            try
            {
                lobjExcelApp = new Microsoft.Office.Interop.Excel.Application();
                lobjExcelApp.Visible = true;
                lobjExcelWorkBooks = lobjExcelApp.Workbooks;
                lobjExcelWorkBook = lobjExcelWorkBooks.Open(_lstrInputFile, true, true, lobjMissing, lobjMissing, lobjMissing, true,
                    lobjMissing, lobjMissing, lobjMissing, lobjMissing, lobjMissing, false, lobjMissing, lobjMissing);

                //Microsoft.Office.Interop.Excel 12.0.0.0之后才有这函数            
                lstrTemp = System.IO.Path.GetTempPath() + Guid.NewGuid().ToString() + ".xls" + (lobjExcelWorkBook.HasVBProject ? 'm' : 'x');
                //lstrTemp = System.IO.Path.GetTempPath() + Guid.NewGuid().ToString() + ".xls";
                lobjExcelWorkBook.SaveAs(lstrTemp, Microsoft.Office.Interop.Excel.XlFileFormat.xlExcel4Workbook, Type.Missing, Type.Missing, Type.Missing, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing,
                    false, Type.Missing, Type.Missing, Type.Missing);
                //输出为PDF 第一个选项指定转出为PDF,还可以指定为XPS格式
                lobjExcelWorkBook.ExportAsFixedFormat(Microsoft.Office.Interop.Excel.XlFixedFormatType.xlTypePDF, _lstrOutFile, Microsoft.Office.Interop.Excel.XlFixedFormatQuality.xlQualityStandard, Type.Missing, false, Type.Missing, Type.Missing, false, Type.Missing);
                lobjExcelWorkBooks.Close();
                lobjExcelApp.Quit();
            }
            catch (Exception ex)
            {
                //其他日志操作；
                return false;
            }
            finally {
                if (lobjExcelWorkBook != null)
                {
                    lobjExcelWorkBook.Close(Type.Missing,Type.Missing,Type.Missing);
                    Marshal.ReleaseComObject(lobjExcelWorkBook);
                    lobjExcelWorkBook = null;

                }
                if(lobjExcelWorkBooks != null)
                {
                    lobjExcelWorkBooks.Close();
                    Marshal.ReleaseComObject(lobjExcelWorkBooks);
                    lobjExcelWorkBooks = null;
                }
                if(lobjExcelApp != null)
                {
                    lobjExcelApp.Quit();
                    Marshal.ReleaseComObject(lobjExcelApp);
                    lobjExcelApp = null;

                } 
                //主动激活垃圾回收器，主要是避免超大批量转文档时，内存占用过多，而垃圾回收器并不是时刻都在运行！
                GC.Collect();
                GC.WaitForPendingFinalizers();



            }
            return true;
        }
    }
}

标签

#pdf #文档 #office #微软 #excel 转PDF