如何让C#读取Excel文件内的行列? RT。分别读取指定Excel文件中,第2行第1列至第12列内容(可以用A~L这12个字母或数字作为其内容)循环该Excel文件内的所有行。行家来帮帮忙哦 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Excel.Range rang = sheet.get_Range("A2", "L2"); sheet.get_Range(sheet.Cells[2, 1], xlsheet.Cells[2,12]) //此程序是向窗体添加一个DataGridView 然后下面添加一个button1 即可,其它是自动生成的代码. 读取e:\works\sql.xls 文件 private void GetConnect() { //file://创建一个连接 string strCon = " Provider = Microsoft.Jet.OLEDB.4.0;Data Source =E:\\works\\sql.xls;Extended Properties=Excel 8.0"; OleDbConnection myConn = new OleDbConnection(strCon); string strCom = " SELECT * FROM [Sheet1$] "; myConn.Open(); OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn); myDataSet = new DataSet(); myCommand.Fill(myDataSet, "[Sheet1$]"); myConn.Close(); } private void button1_Click(object sender, EventArgs e) { dataGridView1.DataMember = "[Sheet1$]"; dataGridView1.DataSource = myDataSet; } }} //添加excel引用 object miss = Missing.Value; Excel.Application ea = new Excel.Application(); Excel.Workbook ew = ea.Workbooks.Open("C:\\Documents and Settings\\桌面\\1.xls", miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss); Excel.Worksheet es = (Excel.Worksheet)ew.Worksheets[1]; Excel.Range er = es.get_Range("A2","L2"); for (int i = 1; i < 13; i++) { MessageBox.Show(((Excel.Range)er.Cells[1, i]).Text.ToString()); } ea.Workbooks.Close(); ea.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(ea); ea = null; System.GC.Collect(); 如何在datagridview中直接显示数据库表中的所有内容 获取Falsh动画播放的时间 遍历窗口所有TextBox后,给每个TextBox加一个事件,如何做? c#进度条怎么制作啊!?请高手指教! .net写客户端将数据更新到java服务端的问题 如何写一个程序实现WINDOWS自动关机?? 文件权限 QUERY.DLL的LoadIFlter()函数 急求解答 各位大哥帮帮忙.数据库连接出错 !!----我实在想不出来 关于引用基类 请问如何用C#实现让程序运行指定长的时间? 【好心人指点一下】C# winform编程中,一般要在Program.cs中放入什么代码?
sheet.get_Range(sheet.Cells[2, 1], xlsheet.Cells[2,12])
private void GetConnect()
{
//file://创建一个连接
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0;Data Source =E:\\works\\sql.xls;Extended Properties=Excel 8.0";
OleDbConnection myConn = new OleDbConnection(strCon);
string strCom = " SELECT * FROM [Sheet1$] ";
myConn.Open(); OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
myDataSet = new DataSet();
myCommand.Fill(myDataSet, "[Sheet1$]");
myConn.Close(); }
private void button1_Click(object sender, EventArgs e)
{
dataGridView1.DataMember = "[Sheet1$]";
dataGridView1.DataSource = myDataSet;
}
}
}
//添加excel引用
object miss = Missing.Value;
Excel.Application ea = new Excel.Application();
Excel.Workbook ew = ea.Workbooks.Open("C:\\Documents and Settings\\桌面\\1.xls", miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss);
Excel.Worksheet es = (Excel.Worksheet)ew.Worksheets[1];
Excel.Range er = es.get_Range("A2","L2"); for (int i = 1; i < 13; i++)
{
MessageBox.Show(((Excel.Range)er.Cells[1, i]).Text.ToString());
} ea.Workbooks.Close();
ea.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(ea);
ea = null;
System.GC.Collect();