使用Asp.net SSRS 2008（RDLC）命名表格以导出到Excel

3 回答

• 0

  我将升级到RDL 2010架构 - 它支持Excel命名表（以及其他有用的增强功能）：

  http://msdn.microsoft.com/en-us/library/ee960138.aspx

  回复于 2024-04-20T07:48:04+08:00
• -1

  RDLC报告的版本不支持工作表重命名 . 我猜你不能升级 . 所以这是一个解决方法：将报告正常保存到文件中 . 然后使用Microsoft.Office.Interop.Excel或任何其他Excel库再次打开它以重命名工作表 . 一旦你这样做保存，你就完成了 .

  using Excel = Microsoft.Office.Interop.Excel; 
  
  
  Excel.ApplicationClass xl=new Excel.ApplicationClass();
      Excel.Workbook xlBook;
      Excel.Worksheet xlSheet;
      string filePath = Server.MapPath(@"\report.xls");
      xlBook = (Workbook)xl.Workbooks.Open(filePath,Type.Missing,
        Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing
       ,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing);
      xlSheet = (Worksheet)xlBook.Worksheets.get_Item(1);
      xlSheet.Name = "New Sheet Name";
      xlBook.Save();
      xl.Application.Workbooks.Close();
  

  如果这个库不适合您可以使用的不同库的列表：免费库1.关闭XML库 - http://closedxml.codeplex.com/documentation 2.打开XML SDK - http://msdn.microsoft.com/en-us/library/bb448854.aspx 3. NOPI - http://npoi.codeplex.com/ 4. CarlosAG - http://www.carlosag.net/Tools/ExcelXmlWriter/

  付费图书馆5.电子表格装备6.智能XLS 7. Office Writer 8. Spire

  回复于 2024-04-20T07:48:04+08:00
• 2

  你无法做到这一点 .

  http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/54caf25b-b17b-474c-aa47-fc884f90af03

  http://go4answers.webhost4life.com/Example/reportviewer-eport-excel-naming-sheets-157612.aspx

  http://forums.asp.net/post/4140154.aspx

  This may help for post processing using excels xml dialect:

  http://spacefold.com/lisa/post/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx

  回复于 2024-04-20T07:48:04+08:00