利用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 " ";
            }
        }
    }
}