asp.Net数据导出问题 急急急

Question

导出成 csv 嘛，看你的格式也是 csv的格式撒或者在点击下载时判断行数，然后传递参数，比如起始行-结束行，开几个下载页面

Answer 1

直接说吧！导出到多个excel的多个sheet中。有什么难的？

Answer 2

导出多个sheet文件
根据数据集部门添加多sheet
Excel.Application app = new Excel.ApplicationClass();   
app.Visible = true;   
Excel.Workbook workBook = app.Workbooks.Open(templetFile,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing,missing);   
Excel.Worksheet workSheet = (Excel.Worksheet)workBook.Sheets.get_Item(1);   
for(int i=1;i <sheetCount;i++)   
{   
((Excel.Worksheet)workBook.Worksheets.get_Item(i)).Copy(missing,workBook.Worksheets[i]);   
 
}   
Response.ClearContent();
    Response.BufferOutput = true;
    Response.Charset = "utf-8";
    Response.ContentType = "text/xml";
    Response.ContentEncoding = System.Text.Encoding.UTF8;
    Response.AppendHeader("Content-Disposition", "attachment;filename="+Server.UrlEncode(filename)+".xls");
    Response.Write(@"\r\n<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' xmlns:html='http://www.w3.org/TR/REC-html40'>");
    Response.Write(@"\r\n<DocumentProperties xmlns='urn:schemas-microsoft-com:office:office'>");

Answer 3

大侠呀  我是真的看不明白  才毕业没有接触到这个  能不能在给我说说  是个什么思路呀   我返回的是一个datatable   数据太多了   怎么把他一次全部导出呢  在不同的sheet里面也行