c# word ppt excel转pdf

最新推荐文章于 2023-09-12 14:14:12 发布

转载最新推荐文章于 2023-09-12 14:14:12 发布 · 3.5k 阅读

标签

#excel #c# #application #null #object

.Net 专栏收录该内容

6 篇文章

订阅专栏

本文介绍如何使用C#将Microsoft Office文档（包括Word、Excel和PowerPoint）转换为PDF格式。通过添加必要的引用并利用Interop组件，实现了自动化转换过程。

命名空间“Microsoft”中不存在类型或命名空间名称“Office ”（是缺少程序集引用吗？）

解决办法：
添加引用/com/Microsoft Office 11.0 Object Library

然后在程序中
C#代码
1.using Microsoft.Office.Interop.Excel;
using Microsoft.Office.Interop.Excel;

也许程序中还会出现其他错误

有

命名空间“Microsoft office”中不存在类型或命名空间名称“Interop” (是缺少程序集引用吗?)

命名空间“Microsoft.Office.Interop”中不存在类型或命名空间名称“Excel”(是缺少程序集引用吗?)

找不到类型或命名空间名称“Workbook”(是否缺少 using 指令或程序集引用?)

找不到类型或命名空间名称“Worksheet”(是否缺少 using 指令或程序集引用?)

那么再添加一个引用/com/Microsoft Excel 11.0 Object Library

问题解决

黑色头发：http://heisetoufa.iteye.com

                                                                                                                                                                                                                                                            using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using Word = Microsoft.Office.Interop.Word;using Excel = Microsoft.Office.Interop.Excel;using PowerPoint = Microsoft.Office.Interop.PowerPoint; using Microsoft.Office.Core; namespace ConvertToPDF{    public partial class Form1 : Form    {         public Form1()        {            InitializeComponent();        }        private void button1_Click(object sender, EventArgs e)        {            if (DOCConvertToPDF("C:/test.doc", "C:/testD.pdf"))            {                MessageBox.Show("DOC转换成功！");            }            else            {                MessageBox.Show("对不起，转换失败！");            }            if (XLSConvertToPDF("C:/test.xls", "C:/testX.pdf"))            {                MessageBox.Show("XLS转换成功！");            }            else            {                MessageBox.Show("对不起，转换失败！");            }            if (PPTConvertToPDF("C:/需求提纲.pptx", "C:/testP.pdf"))            {                MessageBox.Show("PPT转换成功！");            }            else            {                MessageBox.Show("对不起，转换失败！");            }                    }        //Word转换成pdf        /// <summary>        /// 把Word文件转换成为PDF格式文件        /// </summary>        /// <param name="sourcePath">源文件路径</param>        /// <param name="targetPath">目标文件路径</param>         /// <returns>true=转换成功</returns>        private bool DOCConvertToPDF(string sourcePath, string targetPath)         {             bool result=false;            Word.WdExportFormat exportFormat = Word.WdExportFormat.wdExportFormatPDF;            object paramMissing = Type.Missing;             Word.ApplicationClass wordApplication = new Word.ApplicationClass();             Word.Document wordDocument = null;             try             {                 object paramSourceDocPath = sourcePath;                 string paramExportFilePath = targetPath;                 Word.WdExportFormat paramExportFormat = exportFormat;                 bool paramOpenAfterExport = false;                 Word.WdExportOptimizeFor paramExportOptimizeFor = Word.WdExportOptimizeFor.wdExportOptimizeForPrint;                 Word.WdExportRange paramExportRange = Word.WdExportRange.wdExportAllDocument;                 int paramStartPage = 0;                 int paramEndPage = 0;                 Word.WdExportItem paramExportItem = Word.WdExportItem.wdExportDocumentContent;                 bool paramIncludeDocProps = true;                 bool paramKeepIRM = true;                 Word.WdExportCreateBookmarks paramCreateBookmarks = Word.WdExportCreateBookmarks.wdExportCreateWordBookmarks;                 bool paramDocStructureTags = true;                 bool paramBitmapMissingFonts = true;                 bool paramUseISO19005_1 = false;                 wordDocument = wordApplication.Documents.Open(                 ref paramSourceDocPath, ref paramMissing, ref paramMissing,                 ref paramMissing, ref paramMissing, ref paramMissing,                 ref paramMissing, ref paramMissing, ref paramMissing,                 ref paramMissing, ref paramMissing, ref paramMissing,                 ref paramMissing, ref paramMissing, ref paramMissing,                 ref paramMissing);                 if (wordDocument != null)                 wordDocument.ExportAsFixedFormat(paramExportFilePath,                 paramExportFormat, paramOpenAfterExport,                 paramExportOptimizeFor, paramExportRange, paramStartPage,                 paramEndPage, paramExportItem, paramIncludeDocProps,                 paramKeepIRM, paramCreateBookmarks, paramDocStructureTags,                 paramBitmapMissingFonts, paramUseISO19005_1,                 ref paramMissing);                 result = true;            }            catch            {                result = false;            }            finally             {                 if (wordDocument != null)                 {                     wordDocument.Close(ref paramMissing, ref paramMissing, ref paramMissing);                     wordDocument = null;                 }                 if (wordApplication != null)                 {                     wordApplication.Quit(ref paramMissing, ref paramMissing, ref paramMissing);                     wordApplication = null;                 }                 GC.Collect();                 GC.WaitForPendingFinalizers();                 GC.Collect();                 GC.WaitForPendingFinalizers();             }            return result;         }         /// <summary>        /// 把Excel文件转换成PDF格式文件        /// </summary>        /// <param name="sourcePath">源文件路径</param>        /// <param name="targetPath">目标文件路径</param>         /// <returns>true=转换成功</returns>        private bool XLSConvertToPDF(string sourcePath, string targetPath)        {            bool result = false;            Excel.XlFixedFormatType targetType = Excel.XlFixedFormatType.xlTypePDF;            object missing = Type.Missing;            Excel.ApplicationClass application = null;            Excel.Workbook workBook = null;            try            {                application = new Excel.ApplicationClass();                object target = targetPath;                object type = targetType;                workBook = application.Workbooks.Open(sourcePath, missing, missing, missing, missing, missing,                        missing, missing, missing, missing, missing, missing, missing, missing, missing);                workBook.ExportAsFixedFormat(targetType, target, Excel.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();                GC.Collect();                GC.WaitForPendingFinalizers();            }            return result;        }        /// <summary>        /// 把PowerPoing文件转换成PDF格式文件        /// </summary>        /// <param name="sourcePath">源文件路径</param>        /// <param name="targetPath">目标文件路径</param>         /// <returns>true=转换成功</returns>        private bool PPTConvertToPDF(string sourcePath, string targetPath)        {            bool result;            PowerPoint.PpSaveAsFileType targetFileType = PowerPoint.PpSaveAsFileType.ppSaveAsPDF;            object missing = Type.Missing;            PowerPoint.ApplicationClass application = null;            PowerPoint.Presentation persentation = null;            try            {                application = new PowerPoint.ApplicationClass();                persentation = application.Presentations.Open(sourcePath, MsoTriState.msoTrue, MsoTriState.msoFalse, MsoTriState.msoFalse);                persentation.SaveAs(targetPath, targetFileType, Microsoft.Office.Core.MsoTriState.msoTrue);                result = true;            }            catch            {                result = false;            }            finally            {                if (persentation != null)                {                    persentation.Close();                    persentation = null;                }                if (application != null)                {                    application.Quit();                    application = null;                }                GC.Collect();                GC.WaitForPendingFinalizers();                GC.Collect();                GC.WaitForPendingFinalizers();            }            return result;        }      }}