【在线等】Excel 读取指定行列数据! 例如,读取第4行第5列的数据!网上好多例子都说不清楚 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 excelApplication = new Excel.ApplicationClass(); excelWorkBooks = excelApplication.Workbooks; excelWorkBook = ((Excel.Workbook)excelWorkBooks.Open(path,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value)); excelApplication.Visible = false;excelWorkSheet = (Excel.Worksheet)excelWorkBook.Worksheets[1];string s=((Excel.Range)excelWorkSheet.Cells[4, 5]).Text.ToString() 这个是用sql实现的。数据放到了datatable里了# string strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;"; # strConnection += @"Data Source=C:\Documents and Settings\v-changl\My Documents\couse.xlsx;"; # strConnection += "Extended Properties=\"Excel 12.0 Xml;HDR=YES\";"; # OleDbConnection objConnection = new OleDbConnection(strConnection); # objConnection.Open(); # OleDbDataAdapter myCommandd = new OleDbDataAdapter("select * from [Sheet1$]", objConnection); # DataSet ds = new DataSet(); # myCommandd.Fill(ds, "[Sheet1$]"); # System.Data.DataTable dt = ds.Tables["[Sheet1$]"]; 第4行第5列的数据!dt.Rows[4][5].ToString()或者ds.Tables[0].Rows[4][5].ToString() Excel.Application myExcel;public string ReadData(int row, int column) { Excel.Range range = myExcel.get_Range(myExcel.Cells[row, column], myExcel.Cells[row, column]); return range.Text.ToString(); } 或读取excel到数据集如dataset,判断dataset行数,获取数据ds.Tables[0].Rows[3][4].ToString() C#基础问题??? 动态加载WPF窗体 求一个c#条码打印的实例要源代码带效果的 checkedListBox绑定值 如何制作ie ActiveX (ie插件) 啊 C#调用VC开发的dll,遇到一个函数参数转换问题,CWnd*对应于C#什么类型? 如何操纵另一个窗体里的控件? dataGridView1显示问题,从另一个类传过来,可什么也不显示???? 在C#下如何获的STRUCT的长度 硬盘序列号,如何取得? C#打包应用程序,能否让在没有装.net上运行 请帮我推荐一本C#基础书,要求内容量大,比较基础,写作水平高
excelApplication = new Excel.ApplicationClass();
excelWorkBooks = excelApplication.Workbooks;
excelWorkBook = ((Excel.Workbook)excelWorkBooks.Open(path,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value,Missing.Value));
excelApplication.Visible = false;
excelWorkSheet = (Excel.Worksheet)excelWorkBook.Worksheets[1];string s=((Excel.Range)excelWorkSheet.Cells[4, 5]).Text.ToString()
# string strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;";
# strConnection += @"Data Source=C:\Documents and Settings\v-changl\My Documents\couse.xlsx;";
# strConnection += "Extended Properties=\"Excel 12.0 Xml;HDR=YES\";";
# OleDbConnection objConnection = new OleDbConnection(strConnection);
# objConnection.Open();
# OleDbDataAdapter myCommandd = new OleDbDataAdapter("select * from [Sheet1$]", objConnection);
# DataSet ds = new DataSet();
# myCommandd.Fill(ds, "[Sheet1$]");
# System.Data.DataTable dt = ds.Tables["[Sheet1$]"];
dt.Rows[4][5].ToString()
或者
ds.Tables[0].Rows[4][5].ToString()
public string ReadData(int row, int column)
{
Excel.Range range = myExcel.get_Range(myExcel.Cells[row, column], myExcel.Cells[row, column]);
return range.Text.ToString();
}
ds.Tables[0].Rows[3][4].ToString()