c# 读取excel文档中的某行某列_WhenIGrowUp

个人资料

微博

正文字体大小：大中小

c# 读取excel文档中的某行某列

(2016-11-15 18:16:02)

分类： C#

页面需要引入文件：Microsoft.Office.Interop.Excel.dll

protected Microsoft.Office.Interop.Excel.Application objExcelApp;//定义Excel Application对象

private Microsoft.Office.Interop.Excel.Workbooks objExcelWorkBooks;//定义Workbook工作簿集合对象

protected Microsoft.Office.Interop.Excel.Workbook objExcelWorkbook;//定义Excel workbook工作簿对象

private Worksheet objExcelWorkSheet;//定义Workbook工作表对象

objExcelApp = new Microsoft.Office.Interop.Excel.ApplicationClass();

objExcelWorkBooks = objExcelApp.Workbooks;

string strFileFullName = @"D:\AAA.xlsx";

objExcelWorkbook = objExcelWorkBooks.Open(strFileFullName, 0, false, 5, "", "", true,

Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);

objExcelWorkSheet = (Worksheet)objExcelWorkbook.Worksheets["sheet1"]; //strSheetName是指的Exce工作簿的Sheet名，如果没有命名则为"1"

objExcelWorkSheet.Select(Type.Missing);

Worksheet objExcelWorkSheetTemp = (Worksheet)objExcelApp.ActiveSheet;

Range objRange = objExcelWorkSheetTemp.get_Range(objExcelWorkSheetTemp.Cells[i, j], objExcelWorkSheetTemp.Cells[i, j]);

string str = objRange.Value2.ToString().Trim();

i表示第i行，j表示第j列，索引均从1开始

阅读┊ 收藏 ┊ 喜欢 ▼ ┊打印┊举报/Report