• C#实现office文档转换为PDF格式


     

    C#实现office文档转换为PDF格式

    需要安装office 2007 还有一个office2007的插件OfficeSaveAsPDFandXPS
    下载地址
    这是一个微软官方出的office插件。
    office2010里好像能直接将文件另存为.PDF格式的
     
    安装好之后,打开VS,以VS2005为例
    新建windows应用程序项目
    添加以下com组件的引用
    Microsoft Word 12.0 Object Library
    Microsoft PowerPoint 12.0 Object Library
    Microsoft Excel 12.0 Object Library
     
    ------------------------------------------------------
    using Word = Microsoft.Office.Interop.Word; using Excel = Microsoft.Office.Interop.Excel; using PowerPoint = Microsoft.Office.Interop.PowerPoint;
    using Microsoft.Office.Core;
     
    我们可以使用一个枚举类型来决定生成文件的类型
    Word.WdExportFormat wd = Microsoft.Office.Interop.Word.WdExportFormat.wdExportFormatPDF;
    Excel.XlFixedFormatType excelType = Microsoft.Office.Interop.Excel.XlFixedFormatType.xlTypePDF; PowerPoint.PpSaveAsFileType ppType = Microsoft.Office.Interop.PowerPoint.PpSaveAsFileType.ppSaveAsPDF;
      //将word文档转换成PDF格式
    private bool Convert(string sourcePath, string targetPath, Word.WdExportFormat exportFormat)
    {
    bool result;
    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;
    }
    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;
    }

    //将excel文档转换成PDF格式
    private bool Convert(string sourcePath, string targetPath, XlFixedFormatType targetType)
    {
    bool result;
    object missing = Type.Missing;
    Excel.ApplicationClass application = null;
    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, 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;
    }

    //将ppt文档转换成PDF格式
    private bool Convert(string sourcePath, string targetPath, PpSaveAsFileType targetFileType)
    {
    bool result;
    object missing = Type.Missing;
    PowerPoint.ApplicationClass application = null;
    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;
    }
    现在遇到的问题:
    在本地运行起来没有问题(通过Vs调试也能顺利的将文件转换成PDF格式),但我把网站部署在IIS上,页面就一直在加载,片刻之后就会提示我计算机内存不足,整个电脑就卡死在哪儿了,不知哪位大虾遇到过此类问题,为小弟指点迷津......感激不尽
     
    最佳答案
    0
    1. 在组件服务中添加权限
    单击开始,单击运行, 然后键入 DCOMCNFG。选择要自动运行的应用程序。应用程序名称如下所示:
    Microsoft Access 97 - Microsoft Access 数据库
    Microsoft Access 2000/2002 - Microsoft Access 应用程序
    Microsoft Excel 97/2000/2002 - Microsoft Excel 应用程序
    Microsoft Word 97 - Microsoft Word Basic
    Microsoft Word 2000/2002 - Microsoft Word 文档
    单击属性打开此应用程序的属性对话框。
     

    1)标示—运行此应用程序的用户账户—下列用户;然后输入Administrator用户组中的一个用户。

    注:更改服务器中组件服务所用到的用户密码时,须在组件中重新输入新的密码,才能正常生成Word。

    2)安全—启动和激活权限,选择“自定义”,添加IIS_WPG用户的本地启动、本地激活权限;

    3)安全—访问权限,选择“自定义”,添加IIS_WPG用户的本地访问权限;

     
     
    其他回答(2)
    0

    1、服务器安装了office没

    2、服务器上.net有调用office的权限没。

    3、转换的文档是不是太大了。

     
    Top
  • 相关阅读:
    前端面试题及答案整理(一)
    关于提高网站性能的几点建议(二)
    关于提高网站性能的几点建议(一)
    基于ArcGIS JS API的在线专题地图实现
    关于婚姻的本质(转)
    14亿人的战争:中国人用了30年望见计算力的珠峰(转载)
    高效能人士的七个习惯--读书笔记
    乔布斯在斯坦福大学的演讲
    疫情加速医疗信息化行业景气上升,医疗信息化新黄金时代即将开启(转自公众号:先知研报)
    oracleXEUniv最大连接数修改
  • 原文地址:https://www.cnblogs.com/baishiying/p/2726452.html
Copyright © 2020-2023  润新知