C#添加多个Sheet表

using System;
using System.Reflection;
using Microsoft.Office.Interop.Excel;

namespace Customize.Common
{
    ///
    /// Class1 的摘要说明
    ///
    public class ExcelHelper
    {
        public ExcelHelper()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }

　　  ///
        /// 添加多个Excel的Sheet
        /// 使用此方法应该注意:在web.config文件的中加入
        /// 添加dll的引用 和 using System.Reflection; 的引用
        ///
        ///
        public static string MakeMoreSheet()
        {
            string results = string.Empty;
            //const int nCells = 5;
            Application app = new Application();
            if (app == null)
            {
                results = "FileNotExists";
            }

            app.Visible = true;
            //Getting the workbooks collection
            Workbooks workbooks = app.Workbooks;
           

            //Adding a new workbook The following line is the temporary workaround for the LCID problem
            _Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);//添加一个Sheet表
            //Getting the worksheets collection 得到sheet的集合
            Sheets sheets = workbook.Worksheets;
            _Worksheet worksheet1 = (_Worksheet)sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value);//添加第二个sheet

            //_Worksheet worksheet = (_Worksheet)sheets.get_Item(1);
            // This paragraph puts the value 5 to the cell G1
            //Range range1 = worksheet.get_Range("G1", Missing.Value);           
            //range1.Value2 = nCells;

            //_Worksheet worksheet2 = (_Worksheet)sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value); //
            //_Workbook workbook1 = workbooks.Add(XlWBATemplate.xlWBATWorksheet);
            //Sheets sheets2 = workbook.Worksheets;

            //_Worksheet worksheet2 = (_Worksheet)sheets.get_Item(2);
            // This paragraph puts the value 5 to the cell G1
            //Range range2 = worksheet2.get_Range("G2", Missing.Value);
            //range2.Value2 = nCells;
            return results;
        }

}

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12639172/viewspace-664578/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12639172/viewspace-664578/