利用Excel生成Html页面

 利用Excel生成Html页面

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Reflection;//需要添加的命名空间//using Microsoft.Office.Interop;/// <summary>///Class1 利用Excel生成html文件/// </summary>/// namespace Microsoft.Office.Interop.Execl{//需要的命名空间    public class Class1    {        public Class1()        {            //            //TODO: 在此处添加构造函数逻辑            //        }        /// <summary>        /// 将Excel生成HTML文件        /// </summary>        /// <param name="fileName">本地Excel</param>        /// <param name="SheetName">Excel中的Sheet</param>        /// <param name="FilePath">保存在服务器中的html路径</param>        /// <returns></returns>        public string SaveSheet(string fileName, string SheetName, string FilePath)        {            try            {                Excel.Application oXL = new Excel.Application();                oXL.Workbooks.Open(fileName, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);                //新建一个名称                 string nowStr = " " + DateTime.Now.Year.ToString() + " " + DateTime.Now.Month.ToString() + " " + DateTime.Now.Day.ToString() + " ";                string newName = nowStr + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString();                newName = newName + DateTime.Now.Millisecond.ToString();                oXL.ActiveWorkbook.PublishObjects.Add(Excel.XlSourceType.xlSourceSheet, FilePath + "\\ " + newName + ".htm", SheetName, " ", Excel.XlHtmlType.xlHtmlStatic, "conn1_20957 ", Missing.Value).Publish(Missing.Value);                //oXL.Workbooks.Close();                oXL.Quit(); //从内存中退出Excel对像                //oXL = null;                return newName + ".htm";            }            catch (Exception theException)            {                String errorMessage;                errorMessage = "Error:   ";                errorMessage = String.Concat(errorMessage, theException.Message);                errorMessage = String.Concat(errorMessage, "   Line:   ");                errorMessage = String.Concat(errorMessage, theException.Source);                //KillExcelProcess();                 return " ";            }        }    }}