Csharp调用微软COM转换excel为HTML

使用微软的office中的excel软件只要使用另存为就可以把一个excel保存为HTML网页文件。但如何通过程序调用完成转化呢？

以下使用office 2007为例，其他版本略有不同。

 1添加引用，对于不同的版本，有所不一样。当然前提自然是安装了对应的微软office软件。

2转换代码如下：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Excel = Microsoft.Office.Interop.Excel;

namespace CommonConvert
{
    public class ExcelToHtml
    {
        /// <summary>
        /// 使用反射调用方法,返回生成的HTML文件路径
        /// </summary>
        /// <param name="excelFileName"></param>
        /// <returns></returns>
        public string ExcelToHtmlFile(object excelFileName)
        {
            //在此处放置用户代码以初始化页面 
            Excel.Application excel = new Excel.Application();
            Type wordType = excel.GetType();
            Excel.Workbooks docs = excel.Workbooks;
            //打开文件 
            Type docsType = docs.GetType();
            Excel.Workbook doc = (Excel.Workbook)docsType.InvokeMember("Open", System.Reflection.BindingFlags.InvokeMethod, null, docs, new Object[] { excelFileName, true, true });
            
            Type docType = doc.GetType();             
            string htmlFullFileName = excelFileName + ".html"; //HTML文件路径   
            object ofmt = Excel.XlFileFormat.xlHtml;
            //转换格式，另存为 
            docType.InvokeMember("SaveAs", System.Reflection.BindingFlags.InvokeMethod, null, doc, new object[] { htmlFullFileName, ofmt});
            docType.InvokeMember("Close", System.Reflection.BindingFlags.InvokeMethod, null, doc, null);      
            //退出  
            wordType.InvokeMember("Quit", System.Reflection.BindingFlags.InvokeMethod, null, excel, null);
            return htmlFullFileName.ToString();
        }
        /// <summary>
        /// 直接调用方法，不使用反射
        /// </summary>
        /// <param name="excelFullFileName"></param>
        /// <returns></returns>
        public string ExcelToHtmlFile2(string  excelFullFileName)
        {

            Excel.Application excel = new Excel.Application();           
            Excel.Workbooks docs = excel.Workbooks;
            //打开文件  
          //  Excel.Workbook doc = docs.Open(excelFullFileName.ToString(), Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            Excel.Workbook doc = docs.Open(excelFullFileName.ToString());
           
            string htmlFullFileName = excelFullFileName + ".html"; //HTML文件路径 
            object ofmt = Excel.XlFileFormat.xlHtml;
            //转换格式，另存为 
            // doc.SaveAs(htmlFullFileName, ofmt, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
           // doc.SaveAs(htmlFullFileName, ofmt, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange);
            doc.SaveAs(htmlFullFileName, ofmt);
            doc.Close();
            //退出             
            excel.Quit();
            return htmlFullFileName;
        }    
    }
}