如何把gridview转化为excel表格

[沉默老哥]

asp.net如何把gridview转化为excel表格

[huangwenquan123]

Response.Clear();
        Response.Buffer = false;
        Response.Charset = "GB2312";
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
        Response.AppendHeader("content-disposition", "attachement;filename=out.xls");
        Response.ContentType = "application/excel";
        StringWriter sw = new StringWriter(sb);
        HtmlTextWriter htw = new HtmlTextWriter(sw); 
        gridview1.RenderControl(htw); 
        Response.Write(htw);
        Response.Flush();
        Response.Close();
        Response.End();

[spring2007]

thanks,mark

[wangan2008]

sql有专门的导入导出语句

[春天的气息]

导出就行了。实质就是读取GridView，然后写入Excel单元格！

[phoenix124124]

2楼， 正解。

[whb147]

百度一下,很多的
我就不去帮你拷贝了

[沉默老哥]

用vb语言 ，asp.net如何把gridview转化为excel表格

[wuyq11]

gridview 导出excle
如果编码单元格使用模板列
protected void Btn_Click(object sender, EventArgs e)
{
string style = @"<style> .text { mso-number-format:\@; } </script> ";
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gridview1.RenderControl(htw);
Response.Write(style);
Response.Write(sw.ToString());
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
}

[fhjzgsy]

顶 个

[灵雨飘零]

gridview 导出excle

protected void Btn_Click(object sender, EventArgs e) 
{ 
string style = @" <style> .text { mso-number-format:\@; } </script> "; 
Response.ClearContent(); 
Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls"); 
Response.ContentType = "application/excel"; 
StringWriter sw = new StringWriter(); 
HtmlTextWriter htw = new HtmlTextWriter(sw); 
gridview1.RenderControl(htw); 
Response.Write(style); 
Response.Write(sw.ToString()); 
Response.End(); 
} 
public override void VerifyRenderingInServerForm(Control control) 
{ 
} 

[灵雨飘零]

public override void VerifyRenderingInServerForm(Control control)
{
}


必须写

[likevs]

GG一下,代码一堆,实在不行PM我,我有现成的生成Excle文件下载保存代码

现在不在公司的电脑上,没法搞出来给你

[liuhongyu_cjzm]

protected void btnExcel_Click(object sender, EventArgs e)
    {
        DataTable dt = GetAllData(out iTotalCount);
            try
            {
                //string writeStr = "";
                System.Text.StringBuilder sb = new System.Text.StringBuilder();
                Response.Clear();
                Response.Buffer = true;
                Response.Charset = "GB2312";
                Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("excel名称") + DateTime.Now.ToString("yyyy-MM-dd") + ".xls");
                //如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码！！！
                Response.ContentEncoding = System.Text.Encoding.UTF7;
                Response.ContentType = "application/vnd.ms-excel";//设置输出文件类型为excel文件。
                sb.Append("<table border=\"1\" align=\"center\"><tr><td height=\"25\">标题1</td><td>标题2</td><td>标题3</td><td>标题4</td><td>标题5</td><td>标题6</td>");
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    sb.Append("<tr><td height=\"25\" align=\"left\">" + dt.Rows[i]["UserName"].ToString() + "</td><td align=\"left\">" + dt.Rows[i]["SurroName"].ToString() + "</td><td align=\"left\" style=\"vnd.ms-excel.numberformat:@\">" + dt.Rows[i]["PhoneCard"].ToString() + "</td><td>" + dt.Rows[i]["SendCount"].ToString() + "</td><td>" + Convert.ToDouble(dt.Rows[i]["GMMoney"]).ToString("0.00元") + "</td><td>" + Convert.ToDouble(dt.Rows[i]["SurroMoney"]).ToString("0.00元") + "</td></tr>");
                }
                Response.Output.Write(sb.ToString() + "</table>");
                Response.Flush();
                Response.End();
            }
            catch { }
    }