[100分]Repeater怎么导出到excel?

[SnApnet]

RT，不相干的URL就不要帖了！谢谢 ！

[Proyang]

把repeater的数据(表格形式),做成一个字符串.比如<table><tr>.............</tr></table>
然后用response.write输出.

最重要的是添加http的header部分,让IE知道它是一个excel.
ContentType = "application/ms-Excel"
Response.AddHeader("Content-Disposition", "inline;filename=test.doc")

[owenbeckham]

转贴一个别人的导excel入sql数据库的我正用的程序,是button1按钮一点就开始导入,导的是excel是第二三colum..如下:

private void Button1_Click(object sender, System.EventArgs e)
{


string mystring="Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = 'D:/ExportToExcel/excel/test.xls';Extended Properties=Excel 8.0";
OleDbConnection cnnxls = new OleDbConnection (mystring);
OleDbDataAdapter myDa =new OleDbDataAdapter("select * from [Sheet1$]",cnnxls);
DataSet myDs =new DataSet();
myDa.Fill(myDs);

if(myDs.Tables[0].Rows.Count > 0)
{
string strSql = "";
string CnnString="Provider=SQLOLEDB;database=testnews;server=(local);uid=sa;pwd=";
OleDbConnection conn =new OleDbConnection(CnnString);
conn.Open ();
OleDbCommand myCmd =null;

for(int i=0; i<myDs.Tables[0].Rows.Count; i++)
{
strSql="insert into news(title,body) values ('";
strSql += myDs.Tables[0].Rows[i].ItemArray[1].ToString() + "', '";
strSql += myDs.Tables[0].Rows[i].ItemArray[2].ToString() + "')";

try
{
myCmd=new OleDbCommand(strSql,conn);
myCmd.ExecuteNonQuery();
Label8.Text = "<script language=javascript>alert('数据导入成功.');</script>";
}
catch
{
Label8.Text = "<script language=javascript>alert('数据导入失败.');</script>";
}
}
conn.Close();
}

}
}

[SnApnet]

up

[ghchen]

顶

[SnApnet]

无人能解?

[tigerwen01]

这个文章好
http://www.yesky.com/49/1890549.shtml

[SnApnet]

看过了,谢谢.

看看别人有没有高见

[renyu732]

http://www.cnblogs.com/renyu732/archive/2005/06/15/174866.html

[SnApnet]

看看,还有没有人知道

[Truly]

1楼的方法就行
不过Response.AddHeader("Content-Disposition", "inline;filename=test.doc")

应该是
Response.AddHeader("Content-Disposition", "inline;filename=test.xls")

[SnApnet]

解决喽,算帐