快捷導(dǎo)航

C#將Excel轉(zhuǎn)成PDF的方法

更新時(shí)間：2019年01月23日 09:54:10 作者：chenqiangdage

今天小編就為大家分享一篇關(guān)于C#將Excel轉(zhuǎn)成PDF的方法，小編覺(jué)得內(nèi)容挺不錯(cuò)的，現(xiàn)在分享給大家，具有很好的參考價(jià)值，需要的朋友一起跟隨小編來(lái)看看吧

PS:公司的業(yè)務(wù)中有個(gè)超級(jí)大的作業(yè)就是把OFFICE文檔轉(zhuǎn)成PDF,我猜之前沒(méi)程序猿們，公司那些人應(yīng)該是一個(gè)個(gè)手動(dòng)轉(zhuǎn)。強(qiáng)烈為猿們感嘆，幫你們做了這么多事，還在那抱怨....無(wú)法滿足你們的需求??；

微軟net平臺(tái)提供了對(duì)Office文檔非常好的支持；其中有com組件直接集成到了VS中。利用這些API可以快速的免去N多繁瑣的工作；

以下代碼是翻閱了公司的代碼，一個(gè)個(gè)敲出來(lái)的；奉上代碼：

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 類(lèi)
  class ExcelConverter
  {
    //構(gòu)造函數(shù)
    public ExcelConverter()
    { }
    /// <summary>
    /// 轉(zhuǎn)換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之后才有這函數(shù)      
        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 第一個(gè)選項(xiàng)指定轉(zhuǎn)出為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;
        } 
        //主動(dòng)激活垃圾回收器，主要是避免超大批量轉(zhuǎn)文檔時(shí)，內(nèi)存占用過(guò)多，而垃圾回收器并不是時(shí)刻都在運(yùn)行！
        GC.Collect();
        GC.WaitForPendingFinalizers();
      }
      return true;
    }
  }
}

總結(jié)

以上就是這篇文章的全部?jī)?nèi)容了，希望本文的內(nèi)容對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，謝謝大家對(duì)腳本之家的支持。如果你想了解更多相關(guān)內(nèi)容請(qǐng)查看下面相關(guān)鏈接

您可能感興趣的文章: