将数据表导出到excel时如何将格式/样式应用于excel [英] how to apply formats/styles to excel when exporting datatable to excel
本文介绍了将数据表导出到excel时如何将格式/样式应用于excel的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我已经阅读了将数据表导出到excel文件的这篇文章.效果很好.
I have read this article that exports datatable to excel file. It worked great.
dt = city.GetAllCity();//your datatable
string attachment = "attachment; filename=city.xls";
Response.ClearContent();
Response.AddHeader("content-disposition", attachment);
Response.ContentType = "application/vnd.ms-excel";
string tab = "";
foreach (DataColumn dc in dt.Columns)
{
Response.Write(tab + dc.ColumnName);
tab = "\t";
}
Response.Write("\n");
int i;
foreach (DataRow dr in dt.Rows)
{
tab = "";
for (i = 0; i < dt.Columns.Count; i++)
{
Response.Write(tab + dr[i].ToString());
tab = "\t";
}
Response.Write("\n");
}
Response.End();
但我想将格式应用于Excel,如何将格式应用于Excel?谁能帮我
在此先感谢.......
but i want to apply formats to excel,how to apply the formats to excel? can any one help me
Thanks in advance.......
推荐答案
使用Excel Interop对象模型:
提示:以编程方式将Excel范围设置为表格格式 [ ^ ]
Use Excel Interop Object Model :
Tip: Format an Excel Range as a Table Programatically[^]
这篇关于将数据表导出到excel时如何将格式/样式应用于excel的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文