没有合适的资源?快使用搜索试试~ 我知道了~
导出Excel
资源推荐
资源详情
资源评论
/// <summary>
/// 将Dataset中的表导出到Excel中
/// </summary>
/// <param name="source">源数据集</param>
/// <param name="fileName">保存的文件名</param>
/// <param name="title">标题</param>
/// <param name="headers">列名</param>
/// <param name="explain">文件生成说明</param>
/// <param name="ps">注释</param>
public static void ExportToExcel(List<WJX.Model.SYS_USER> source, string fileName, string title, string[] ps, string explain)
{
Dictionary<string, string> headers_ColumnsName = new Dictionary<string, string>();
string[] headers = ExpToExcel.GetColumnNamesArray(source[0], ref headers_ColumnsName);
HttpResponse resp;
resp = HttpContext.Current.Response;
resp.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
resp.AppendHeader("Content-Disposition", "attachment;filename=" + fileName);
string startExcelXML = @"<?xml version=""1.0"" encoding=""utf-8""?>
<Workbook xmlns=""urn:schemas-microsoft-com:office:spreadsheet""
xmlns:o=""urn:schemas-microsoft-com:office:office""
xmlns:x=""urn:schemas- microsoft-com:office:excel""
xmlns:ss=""urn:schemas-microsoft-com:office:spreadsheet"">
<Styles>
<Style ss:ID=""Default"" ss:Name=""Normal"">
<Alignment ss:Horizontal=""Center"" ss:Vertical=""Center""/>
<Font/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
/// 将Dataset中的表导出到Excel中
/// </summary>
/// <param name="source">源数据集</param>
/// <param name="fileName">保存的文件名</param>
/// <param name="title">标题</param>
/// <param name="headers">列名</param>
/// <param name="explain">文件生成说明</param>
/// <param name="ps">注释</param>
public static void ExportToExcel(List<WJX.Model.SYS_USER> source, string fileName, string title, string[] ps, string explain)
{
Dictionary<string, string> headers_ColumnsName = new Dictionary<string, string>();
string[] headers = ExpToExcel.GetColumnNamesArray(source[0], ref headers_ColumnsName);
HttpResponse resp;
resp = HttpContext.Current.Response;
resp.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
resp.AppendHeader("Content-Disposition", "attachment;filename=" + fileName);
string startExcelXML = @"<?xml version=""1.0"" encoding=""utf-8""?>
<Workbook xmlns=""urn:schemas-microsoft-com:office:spreadsheet""
xmlns:o=""urn:schemas-microsoft-com:office:office""
xmlns:x=""urn:schemas- microsoft-com:office:excel""
xmlns:ss=""urn:schemas-microsoft-com:office:spreadsheet"">
<Styles>
<Style ss:ID=""Default"" ss:Name=""Normal"">
<Alignment ss:Horizontal=""Center"" ss:Vertical=""Center""/>
<Font/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID=""BoldColumn"">
<Borders>
<Border ss:Position=""Bottom"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Left"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Right"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Top"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
</Borders>
<Font ss:FontName=""宋体"" ss:Bold=""1"" x:CharSet=""134"" ss:Size=""12"" />
<Interior ss:Color=""#C0C0C0"" ss:Pattern=""Solid""/>
</Style>
<Style ss:ID=""StringLiteral"">
<NumberFormat ss:Format=""@""/>
<Borders>
<Border ss:Position=""Bottom"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Left"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Right"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Top"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
</Borders>
<Font ss:FontName=""宋体"" x:CharSet=""134"" ss:Size=""12"" />
</Style>
<Style ss:ID=""Decimal"">
<NumberFormat ss:Format=""0.00""/>
<Borders>
<Border ss:Position=""Bottom"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Left"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Right"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Top"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
</Borders>
<Font ss:FontName=""宋体"" x:CharSet=""134"" ss:Size=""12"" />
</Style>
<Borders>
<Border ss:Position=""Bottom"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Left"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Right"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Top"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
</Borders>
<Font ss:FontName=""宋体"" ss:Bold=""1"" x:CharSet=""134"" ss:Size=""12"" />
<Interior ss:Color=""#C0C0C0"" ss:Pattern=""Solid""/>
</Style>
<Style ss:ID=""StringLiteral"">
<NumberFormat ss:Format=""@""/>
<Borders>
<Border ss:Position=""Bottom"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Left"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Right"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Top"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
</Borders>
<Font ss:FontName=""宋体"" x:CharSet=""134"" ss:Size=""12"" />
</Style>
<Style ss:ID=""Decimal"">
<NumberFormat ss:Format=""0.00""/>
<Borders>
<Border ss:Position=""Bottom"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Left"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Right"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
<Border ss:Position=""Top"" ss:LineStyle=""Continuous"" ss:Weight=""1""/>
</Borders>
<Font ss:FontName=""宋体"" x:CharSet=""134"" ss:Size=""12"" />
</Style>
剩余8页未读,继续阅读
资源评论
jiancaixing
- 粉丝: 2
- 资源: 101
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功