C#导出数据到Excel通用的方法类
2024-10-15 03:02:34
导出数据到Excel通用的方法类,请应对需求自行修改。
资源下载列表
using System.Data;
using System.IO; namespace IM.Common.Tools
{
public class Export
{
public string Encoding = "UTF-8";
System.Web.HttpResponse response = System.Web.HttpContext.Current.Response; public void EcportExcel(DataTable dt, string fileName)
{ if (dt != null)
{
StringWriter sw = new StringWriter();
CreateStringWriter(dt, ref sw);
sw.Close();
response.Clear();
response.Buffer = true;
response.Charset = Encoding;
//this.EnableViewState = false;
response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + ".xls");
response.ContentType = "application/ms-excel"; //response.ContentEncoding = System.Text.Encoding.GetEncoding(Encoding)
response.ContentEncoding = System.Text.Encoding.UTF8;
response.Write(sw);
response.End();
} } private void CreateStringWriter(DataTable dt, ref StringWriter sw)
{
string sheetName = "sheetName"; sw.WriteLine("<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">");
sw.WriteLine("<head>");
sw.WriteLine("<!--[if gte mso 9]>");
sw.WriteLine("<xml>");
sw.WriteLine(" <x:ExcelWorkbook>");
sw.WriteLine(" <x:ExcelWorksheets>");
sw.WriteLine(" <x:ExcelWorksheet>");
sw.WriteLine(" <x:Name>" + sheetName + "</x:Name>");
sw.WriteLine(" <x:WorksheetOptions>");
sw.WriteLine(" <x:Print>");
sw.WriteLine(" <x:ValidPrinterInfo />");
sw.WriteLine(" </x:Print>");
sw.WriteLine(" </x:WorksheetOptions>");
sw.WriteLine(" </x:ExcelWorksheet>");
sw.WriteLine(" </x:ExcelWorksheets>");
sw.WriteLine("</x:ExcelWorkbook>");
sw.WriteLine("</xml>");
sw.WriteLine("<![endif]-->");
sw.WriteLine("</head>");
sw.WriteLine("<body>");
sw.WriteLine("<table>");
sw.WriteLine(" <tr>");
string[] columnArr = new string[dt.Columns.Count];
int i = ;
foreach (DataColumn columns in dt.Columns)
{ sw.WriteLine(" <td>" + columns.ColumnName + "</td>");
columnArr[i] = columns.ColumnName;
i++;
}
sw.WriteLine(" </tr>"); foreach (DataRow dr in dt.Rows)
{
sw.WriteLine(" <tr>");
foreach (string columnName in columnArr)
{
sw.WriteLine(" <td style='vnd.ms-excel.numberformat:@'>" + dr[columnName] + "</td>");
}
sw.WriteLine(" </tr>");
}
sw.WriteLine("</table>");
sw.WriteLine("</body>");
sw.WriteLine("</html>");
}
}
}
最新文章
- JAVA Thread线程异常监控
- Fedora javac 命令提示 [javac: 未找到命令...]
- Android 友盟分享躺过的几个坑,大坑,坑爹啊
- html textarea 获取换行
- 关于java.lang.reflect.InvocationTargetException
- c++随机数生成
- 李洪强漫谈iOS开发[C语言-006]-程序的描述方式
- MultiSet
- go与json
- c - 计算1到20的阶乘
- cp命令的实现
- Git 忽略特殊文件的功能
- UWP--页面传值
- Spring MVC 项目搭建 -2- 添加service ,dao,junit
- Activiti常见问题解决
- Jmeter + Ant 测试环境搭建 及解决问题: the <;jmeter>; type doesn&#39;t support nested text data
- Linux lvs-NAT模式配置详解
- SQL Server - 四种排序, ROW_NUMBER() /RANK() /DENSE_RANK() /ntile() over()
- Android获取手机号码
- .net core 生成