c#导出Excel里面设置单元格问题
Response.Write("\n <head>");
Response.Write("\n <xml>");
Response.Write("\n <x:ExcelWorkbook>");
Response.Write("\n <x:ExcelWorksheets>");
Response.Write("\n <x:ExcelWorksheet>");
Response.Write(string.Format("\n <x:Name>{0}</x:Name>", ExportTableName));
Response.Write("\n <x:WorksheetOptions>");
Response.Write("\n <x:FrozenNoSplit/>");
Response.Write("\n <x:SplitHorizontal>4</x:SplitHorizontal>");
Response.Write("\n <x:TopRowBottomPane>4</x:TopRowBottomPane>");
Response.Write("\n <x:ActivePane>2</x:ActivePane>");
Response.Write("\n </x:WorksheetOptions>");
Response.Write("\n </xml>");
Response.Write("\n </head>");
Response.Write("\n <body>");
Response.Write("<table borderColor=black border=1>");
StringBuilder sb = new StringBuilder();
sb.Append("\n <tr style=\"font-size:13px;\" align=\"right\" >");
for (int j = 0; j < 16; j++)
{
switch (j)
{
case 0://序号
sb.Append("\n <td>");
sb.Append("" + j + 1 + "");
sb.Append("\n </td>");
break;
}}
我是这样拼接起来的,如何一次性设置导出的格式为文本格式???
Response.Write() 就是下面这种格式,但是在excel里面就会出现如果是0就省略掉··我想直接设置文本格式,如何设置?
<tr style="font-size:13px;" align="right" >
<td>1
</td>
<td>李四
</td>
<td>2500.00
</td>
<td>6
</td>
<td>6
</td>
<td>2100.00
</td>
<td>420.00
</td>
<td>300.00
</td>
<td>60.00
</td>
<td>60.00
</td>
<td>12.00
</td>
<td>120.00
</td>
<td>24.00
</td>
<td>1725.00
</td>
<td>345.00
</td>
<td>0.0000
</td>
<td>0.00
</td>
<td>4305.00
</td>
<td>861.00
</td>
<td>6000.0000
</td>
<td>6000.0000
</td>
<td>11166.0000
</td>
<td>600
</td>
<td>600
</td>
<td>600
</td>
<td>12966.0000
</td>
</tr>