C#操作Excel的类.docVIP

C# 操作Excel的类(上) 2008-11-27 22:32 using System;using Microsoft.Office.Core;using Excel;namespace WebExcell1{/// summary/// Class1 的摘要说明。/// /summary class ExcelEdit{?? string myFileName;?? Excel.Application myExcel;?? Excel.Workbook myWorkBook; ?? public string MyFileName?? {??? get??? {???? return myFileName;??? }??? set??? {???? myFileName = value;??? }?? } ?? /// summary?? /// 构造函数，不创建Excel工作薄?? /// /summary?? public ExcelEdit()?? {??? //请不要删除以下信息??? //版权：http://XingFuS?? } ?? /// summary?? /// 创建Excel工作薄?? /// /summary?? public void CreateExcel()?? {??? myExcel = new Excel.Application();??? myWorkBook = myExcel.Application.Workbooks.Add(true);?? } ?? /// summary?? /// 显示Excel?? /// /summary?? public void ShowExcel()?? {??? myExcel.Visible = true;?? } ?? /// summary?? /// 将数据写入Excel?? /// /summary?? /// param name=data要写入的二维数组数据/param?? /// param name=startRowExcel中的起始行/param?? /// param name=startColumnExcel中的起始列/param?? public void WriteData(string[,] data, int startRow, int startColumn)?? {??? int rowNumber = data.GetLength(0);??? int columnNumber = data.GetLength(1); ??? for (int i = 0; i rowNumber; i++)??? {???? for (int j = 0; j columnNumber; j++)???? {????? //在Excel中，如果某单元格以单引号“”开头，表示该单元格为纯文本，因此，我们在每个单元格前面加单引号。 ????? myExcel.Cells[startRow + i, startColumn + j] = + data[i, j];???? }??? }?? } ?? /// summary?? /// 将数据写入Excel?? /// /summary?? /// param name=data要写入的字符串/param?? /// param name=starRow写入的行/param?? /// param name=startColumn写入的列/param?? public void WriteData(string data, int row, int column)?? {??? myExcel.Cells[row, column] = data;?? } ?? /// summary?? /// 将数据写入Excel?? /// /summary?? /// param name=data要写入的数据表/param?? /// param name=startRowExcel中的起始行/param?? /// param name=startColumnExcel中的起始列/param?? public void WriteData(System.Data.DataTable data, int startRow, int startColumn)?? {??? for (int i = 0; i = data.Rows.Count - 1; i++)??? {???? for (int j = 0; j = data