C#将Excel转成PDF的方法

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;    }  }}