Report Builder 2.0
How to export data from Report builder 2.0 to Excel 2007 format?
April 14th, 2011 10:37am
Hello,
With Excel 2007 format do you mean the new XLSX format?
Actually it's not possible to render a XLSX file, see also thread
Problem: export to excel 2007 in SSRSOlaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich tglich
Blog
Xing
Free Windows Admin Tool Kit Click here and download it now
April 14th, 2011 10:52am
Hi BharatJoshi,
SSRS does not export directly to the xlsx format (the Office 2007 format). It does export to the .xls format and that format
is fully supported in Office 2007. Users will be able to open, view and edit the reports without any issue. As far as adding direct support for the Office 2007 formats is concerned, it is something that we are considering for a future release.
There are two third party components available in the market which support excel 2007 format.
Here are the links:
1. http://www.aspose.com/categories/ssrs-rendering-extensions/aspose.cells-for-reporting-services/default.aspx
2. http://officewriter.softartisans.com/officewriter-250.aspx
Except the above, you can wirte your own custom extension by extending the render interface, for more information about Rendering Extensions please see:
http://msdn.microsoft.com/en-us/library/ms154606.aspx
Thanks,
Challen Fu
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
April 18th, 2011 3:55am
So how do we get around the row constraint of 65k when exporting to excel?
Free Windows Admin Tool Kit Click here and download it now
June 22nd, 2011 5:18pm