在c＃asp.net中导出到具有多个工作表的Excel [英] Export to excel with multiple sheets in c# asp.net
本文介绍了在c＃asp.net中导出到具有多个工作表的Excel的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我想将我的数据表记录导出到excel，每行数据表应该在同一个excel的单独表格中导出。
这是我的代码：
Hi,
I want to export my datatable records to excel each row of datatable should export in separate sheet in same excel.
Here is my code:
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "confidential feedback.xls"));
Response.ContentType = "application/ms-excel";
Response.Write("");
Response.Write("<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">");
Response.Write("<body>");
Response.Write("<table border=0 bordercolor=black>");
Response.Write("<tr>");
Response.Write("<td colspan=9><b><center>");
Response.Write("<Font size=4 face='Times New Roman'color='blue'>Confidential Report</font>");
Response.Write("</b></center></td>");
Response.Write("</tr>");
Response.Write("<tr>");
Response.Write("</tr>");
Response.Write("<tr>");
Response.Write("<td colspan=6 align='left'><b><Font size=3 face='Times New Roman'>");
Response.Write("1(a).How much percentage of job satisfaction do you have ?");
Response.Write("</td>");
Response.Write("</tr>");
Response.Write("<tr>");
Response.Write("<td colspan=6 align='left'><Font size=3 face='Times New Roman'>");
Response.Write(dtitems.ItemArray[2].ToString().Trim());
Response.Write("</td>");
Response.Write("</tr>");
Response.Write("<tr>");
Response.Write("</tr>");
Response.Write("<tr>");
Response.Write("<td colspan=6 align='left'><b><Font size=3 face='Times New Roman'>");
Response.Write(" (b).What is required to be done to increase your job satisfaction ?");
Response.Write("</td>");
Response.Write("</tr>");
Response.Write("<tr>");
Response.Write("<td colspan=6 align='left'><Font size=3 face='Times New Roman'>");
Response.Write(dtitems.ItemArray[3].ToString().Trim());
Response.Write("</td>");
Response.Write("</tr>");
请帮助我
please help me
推荐答案
您可以使用OpenXML SDK创建多个工作表。
参考 - 使用工作表（Open XML SDK） [ ^ ]。
You can create multiple sheets with OpenXML SDK.
Refer - Working with sheets (Open XML SDK)[^].
这篇关于在c＃asp.net中导出到具有多个工作表的Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
