Question

c# 如何往excel中填入数据

创建一个excel ，输入1,2,3,4,5如图。第一次使用c#操作excel，能不能给点最基础的资料，谢谢！！！我就10分了

Answer 1

举个例子：将id，txt作为字段放入boox1.xls,然后放入十个数
private void add()
{ OleDbConnection conn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;extended properties=excel 8.0;data source=" + Server.MapPath("Book1.xls"));
conn.Open();
OleDbCommand cmd = new OleDbCommand("create table tb(id int,txt string)", conn);
cmd.ExecuteNonQuery();
for(int i=0;i<10;i++)
{
cmd.CommandText = "insert into tb(id,txt) values('" + i.ToString() + "','" + i.ToString() + "')";
cmd.ExecuteNonQuery();
}
conn.Close();
}

Answer 2

for( int i = 1; i <=5; i ++)
{
ActiveSheet.Range(i, 1).Value = i
}