Excel.Workbook theWorkbook=Class读取数据库_ds.LoadExecl(@"D:\Documents and Settings\user\My Documents\新建文件夹_养老险名单\2004养老险人名单1-1.xls");
Excel.Sheets sheets=theWorkbook.Worksheets;
Excel.Worksheet thesheet=(Excel.Worksheet)sheets.get_Item(1);
int cols=thesheet.Columns.Count;
int rows=thesheet.Rows.Count;
int nowcols=thesheet.get_Range("A1","A1").CurrentRegion.Columns.Count;
int nowrows=thesheet.get_Range("A1","A1").CurrentRegion.Rows.Count;
Excel.Range range=thesheet.get_Range(thesheet.Cells[1,1],thesheet.Cells[nowrows,nowcols]);
System.Array myvalues=(System.Array)range.Cells.Value;
用myvalues.GetValue(i,1) 取得第i行第1列的值