Export data from Repeater to EXCEL

protected void btnexcel_click(object sender, eventargs e)

true;

utf-8";

content-disposition", "attachment;filename=" + "Name", +".xls");

gb2312");Set the output stream to Chinese Simplified.

false;

mycitrad = new "zh-cn", true);

ostringwriter = new ;

ohtmltextwriter = new ;

id;; of the repeater control;

What you want is pure data, don't output in the form of html tags, **change it to the following try, this is an export data operation under the button button. = true;

content-disposition", attachment;filename=" "yyyymmddhhmmss") csv");Save the end in the format you want to save.

false;

string sql = "Your query statement");

datatable dt = ;Replace it with your dbhelper query method.

Export field one", export field two",.Add the data field information you want to export here))).

datatable dt = new admin())getadmin_print();

dt;Belong to the addition of datatable, each same.

sw = new ;

hw = new ;;

true;content-disposition", attachment;filename=");File name settings.

Let's announce the answer as well

Someone will come to search for this question in the future.

Your repeater must have a data source, and you can export the data source directly, and export it all.

Eh, may I ask the questioner how did you solve your problem?

datatable dt = new admin())getadmin_print();

dt;This belongs to adding a datatable, which is different for everyone.

sw = new ;

hw = new ;;

true;

content-disposition", attachment;filename=");Here is the file name setting. """;

Override this event to prevent errors when exporting from GridView to Excel.

public override void verifyrenderinginserverform(control control)

public void export(string filetype, string filename)

protected void button1_click(object sender, eventargs e)

Let's announce the answer as well

Someone will come to search for this question in the future.

Encapsulate the repeater's data into a datatable. Import them one by one to Excel