此外做了个导出Excel的功能,主要代码如下:
1
private
void
DumpExcel(GridView gv,
string
FileName)
2![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{//带格式导出
3
string style = @"<style> .text { mso-number-format:\@; } </script>";
4
Response.ClearContent();
5
Response.Charset = "GB2312";
6
Response.ContentEncoding = System.Text.Encoding.UTF8;
7
Response.AddHeader("content-disposition", "attachment; filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
8
Response.ContentType = "application/excel";
9
StringWriter sw = new StringWriter();
10
HtmlTextWriter htw = new HtmlTextWriter(sw);
11
gv.RenderControl(htw);
12
// Style is added dynamically
13
Response.Write(style);
14
Response.Write(sw.ToString());
15
Response.End();
16
}
17
public
override
void
VerifyRenderingInServerForm(Control control)
18![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
19
}
20
上面的行17的重载函数是必须的,否则会报“GridView要在有run=server的From体内”的错。
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/InBlock.gif)
5
![](/Images/OutliningIndicators/InBlock.gif)
6
![](/Images/OutliningIndicators/InBlock.gif)
7
![](/Images/OutliningIndicators/InBlock.gif)
8
![](/Images/OutliningIndicators/InBlock.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/InBlock.gif)
12
![](/Images/OutliningIndicators/InBlock.gif)
13
![](/Images/OutliningIndicators/InBlock.gif)
14
![](/Images/OutliningIndicators/InBlock.gif)
15
![](/Images/OutliningIndicators/InBlock.gif)
16
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
17
![](/Images/OutliningIndicators/None.gif)
18
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
19
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
20
![](/Images/OutliningIndicators/None.gif)
此外,变量style的作用是控制 GridView 列的样式,避免发生excel表中字符前导0被当成数字给截掉这样的问题, 通过Response.Write方法将其添加到输出流中。最后把样式添加到ID列。这一步需要在RowDataBound事件中完成:
1
protected
void
gvUsers_RowDataBound(
object
sender, GridViewRowEventArgs e)
2![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
3
if (e.Row.RowType == DataControlRowType.DataRow)
4![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
{
5
e.Row.Cells[1].Attributes.Add("class", "text");
6
}
7
}
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
3
![](/Images/OutliningIndicators/InBlock.gif)
4
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](https://www.cnblogs.com/Images/dot.gif)
5
![](/Images/OutliningIndicators/InBlock.gif)
6
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
7
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)