批量导出多Sheet Excel文件的方法

/// <summary>
/// 通过传入的数据源生成Excel文件
/// </summary>
/// <param name="source"></param>
/// <param name="fileName"></param>
public static void exportToExcel(DataSet source, string fileName)   
{   
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:Vertical=""Center""/><Borders/><Font ss:Size=""12""/><Interior/><NumberFormat/><Protection/></Style> 
<Style ss:ID=""BoldColumn""><Font x:Family=""Swiss"" ss:Bold=""1"" ss:Size=""12""/></Style>
<Style ss:ID=""s113""><Alignment ss:Horizontal=""Center"" ss:Vertical=""Center""/><Font ss:FontName=""Arial"" x:Family=""Swiss"" ss:Size=""14"" ss:Color=""#000000"" ss:Bold=""1""/><Interior ss:Color=""#00B050"" ss:Pattern=""Solid""/></Style>
<Style ss:ID=""s62""><Font ss:FontName=""Arial"" x:Family=""Swiss"" ss:Size=""12"" ss:Bold=""1""/></Style>               
<Style ss:ID=""StringLiteral""><NumberFormat ss:Format=""@""/></Style><Style ss:ID=""Decimal""><NumberFormat ss:Format=""0.00""/></Style>  
<Style ss:ID=""Integer""><NumberFormat ss:Format=""0""/></Style><Style ss:ID=""DateLiteral""><NumberFormat ss:Format=""Short Date""/></Style><Style ss:ID=""Linker""><Font x:Family='Swiss' ss:Size=""12"" ss:Color='#0000FF' ss:Underline='Single'/><NumberFormat /></Style> 
</Styles>";  
string endExcelXML = "\r\n</Workbook>";   
  
int rowCount = 0;   
int sheetCount = 0;   
resp.Write(startExcelXML);

for (int i = 0; i < source.Tables.Count; i++)   
{   
sheetCount = 0;   
resp.Write("\r\n<Worksheet ss:Name=\"" + source.Tables[i].TableName + "\">");
resp.Write("\r\n<Table>");
resp.Write("\r\n<Row>");


for (int x = 0; x < source.Tables[i].Columns.Count; x++)   
{   
resp.Write("\r\n<Cell ss:StyleID=\"s113\"><Data ss:Type=\"String\">");
if (source.Tables[i].Columns[x].ColumnName.Length > 5 && source.Tables[i].Columns[x].ColumnName.Substring(0, 5).Equals("HREF:"))   
{   
resp.Write(source.Tables[i].Columns[x].ColumnName.Split(":".ToCharArray())[1]);
}   
else  
{   
resp.Write(source.Tables[i].Columns[x].ColumnName); 
}   
resp.Write("</Data></Cell>");
}   
resp.Write("</Row>"); 
foreach (DataRow x in source.Tables[i].Rows)   
{   
rowCount++;   
//if the number of rows is > 64000 create a new page to continue output   
if (rowCount == 64000)   
{   
rowCount = 0;