object[] rv=new object[2];
			rv[0]=null;
			rv[1]="";

			//創(chuàng)建一個(gè)名為ExcelApp的組件對象
//			ExcelApplication excel = new ExcelApplication();
            Excel.Application excel = new Excel.Application();
			excel.DisplayAlerts=false;
			excel.AskToUpdateLinks=false;
			Excel.Workbook xb=excel.Workbooks.Add(_filename);
//獲取活動的 worksheet和 excel sheet的個(gè)數(shù),準(zhǔn)備遍歷sheets
			Worksheet worksheet = (Worksheet) excel.ActiveSheet;
			sheetCount=excel.Sheets.Count;  
			int	startSheetIndex=1;
			int	endSheetIndex=sheetCount;
			DataSet ds=new DataSet();
//遍歷sheets
            for (int currentIndex = startSheetIndex; currentIndex <= endSheetIndex; currentIndex++)
            {
                worksheet = (Worksheet)excel.Worksheets[currentIndex];
                worksheet.Activate();
                
                //處理每一個(gè)sheet.....

            }

//獲取起始單元和截止單元格，以確定有效區(qū)域

                Excel.Range _startcell=worksheet.Range["A1","A1"]; //默認(rèn)為第一個(gè)單元格
				if(startaddress!="")
				{
					try
					{
						_startcell=worksheet.Range[startaddress,startaddress];
					}
					catch(Exception ex)
					{
						rv[1]+=string.Format("{1}指定的起始單元格地址{0}，不是合法的地址。\r\n",startaddress,worksheet.Name);
						//					KillProcessByStartTime("EXCEL",beforetime,aftertime);
						continue;
					}
				}

				Excel.Range _lastcell=worksheet.Cells.SpecialCells(XlCellType.xlCellTypeLastCell,Type.Missing);
//默認(rèn)獲取有值的最后一個(gè)有效的單元格


                excel.Cells[1, _lastcell.Column + 1] = "vcol"+ (_lastcell.Column + 1).ToString();
                _lastcell = worksheet.Cells.SpecialCells(XlCellType.xlCellTypeLastCell, Type.Missing);
 

				if(endaddress!="")
				{
					try
					{
						_lastcell=worksheet.Range[endaddress,endaddress];
					}
					catch(Exception ex)
					{
						rv[1]+=string.Format("{1}指定的結(jié)束單元格地址{0}，不是合法的地址。\r\n",endaddress,worksheet.Name);
						//					KillProcessByStartTime("EXCEL",beforetime,aftertime);
						//						return rv;
						continue;
					}
				}


//遍歷有效區(qū)域單元格

                    foreach (Excel.Range aicell in worksheet.Range[_startcell,_lastcell])
                    {
                        if (aicell.MergeCells.ToString() == "True")
                        {
                            //處理合并單元格
                            object temp_merge_value = aicell.Value2; //備份單元格的值
                            int u_row = aicell.Row;  //記錄單元格的首行索引
                            int u_rows = aicell.MergeArea.Rows.Count; //記錄單元格的合并區(qū)域包含的行數(shù)
                            int u_col = aicell.Column; //記錄單元格的首列索引
                            int u_cols = aicell.MergeArea.Columns.Count; //記錄單元格的合并區(qū)域包含的列數(shù)
                            aicell.MergeArea.UnMerge();  //取消合并，拆分單元格
                            Excel.Range new_aicell = worksheet.Range[worksheet.Cells[u_row, u_col], worksheet.Cells[u_row + u_rows - 1, u_col + u_cols - 1]];  //獲取拆分后單元格后的有效區(qū)域
                            new_aicell.Value2 = temp_merge_value; //將拆分的單元格重新賦值(備份值)
                        }
                    }

				System.Data.DataTable dt=ds.Tables.Add();
				dt.TableName=worksheet.Name;  //表名為worksheet的名稱
				for(int i=_startcell.Column;i<=_lastcell.Column;i++)
				{
					Excel.Range _cell=worksheet.Range[worksheet.Cells[_startcell.Row,i],worksheet.Cells[_startcell.Row,i]];
								string _colname=hastitle==true?_cell.Value2.ToString():"C"+(i-_startcell.Column+1).ToString(); //如果第一行是標(biāo)題，則賦單元格的值，否則以C開頭加序號
						DataColumn dc=dt.Columns.Add();
						dc.ColumnName=_colname;
						dc.DataType=System.Type.GetType("System.String");
						dc.AllowDBNull=true;
				}
				

object[,] cells=null;  定義二維對象數(shù)組
    if(hastitle) //如果首行包含列，則加行索引加1取數(shù)據(jù)行
	{
		startrow=_startcell.Row+1;  
    }
//將有效區(qū)域單元格轉(zhuǎn)化賦值為 object[,]	
cells=(object[,])worksheet.Range[worksheet.Cells[startrow,_startcell.Column],worksheet.Cells[_lastcell.Row,_lastcell.Column]].Value2;

//遍歷數(shù)組，添加行數(shù)據(jù)到 DataTable里
int _rowcount=cells.GetLength(0);
int _colcount=cells.GetLength(1);
for(int i=0;i<_rowcount;i++)
{
	object[] newrowdata=new object[_colcount];
	for(int j=0;j<_colcount;j++)
	{
		newrowdata[j]=cells[i,j];
	}
	DataRow dr=dt.Rows.Add(newrowdata);
}

_lastcell = excel.Cells[_lastcell.Row, _lastcell.Column - 1];
dt.Columns.Remove(dt.Columns[dt.Columns.Count - 1]);