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./12639172/viewspace-664578/,如需转载,请注明出处,否则将追究法律责任。
|