c# excel 转 pdf

原创已于 2024-07-26 16:12:26 修改 · 3.6k 阅读

9 ·

CC 4.0 BY-SA版权

文章标签：

#c#excel转pdf #excel转pdf #.net excel转pdf

于 2019-09-12 08:54:00 首次发布

本文档详细介绍了如何利用C#编程语言，结合.NET库将Excel电子表格高效地转换为PDF格式，包括关键步骤、所需库和代码示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

using MSExcel = Microsoft.Office.Interop.Excel;

private bool exceltoPDF(string sourcePath, string targetPath)
        {
            bool result;
            object missing = Type.Missing;
            MSExcel.ApplicationClass application = null;
            MSExcel.Workbook workBook = null;
            try
            {
                application = new MSExcel.ApplicationClass();
                object target = targetPath;
                workBook = application.Workbooks.Open(sourcePath, missing, missing, missing, missing, missing,
                        missing, missing, missing, missing, missing, missing, missing, missing, missing);

                workBook.ExportAsFixedFormat(MSExcel.XlFixedFormatType.xlTypePDF, target, MSExcel.XlFixedFormatQuality.xlQualityStandard
                    , true, false, missing, missing, missing, missing);
                result = true;
            }
            catch
            {
                result = false;
            }
            finally
            {
                if (workBook != null)
                {
                    workBook.Close(true, missing, missing);
                    workBook = null;
                }
                if (application != null)
                {
                    application.Quit();
                    application = null;
                }
                GC.Collect();
                GC.WaitForPendingFinalizers();
            }
            return result;
        }