Preserve SSRS formatting when exporting to excel
I'm pretty sure SSRS doesn't do this on its own, but I was wondering if someone could help me find a third party product that could accomplish what I need from SSRS.
Specifically, I need SSRS to preserve settings when I export a report to excel for such things as excel page headers and footers, print range, column width, etc.
How can I accomplish this with SSRS, or what third party API will accomplish this?
Thanks!
February 15th, 2011 2:23pm
Any help?
February 17th, 2011 2:07pm
Hi Barron,
You culd refer to this two third-part products:
http://officewriter.softartisans.com/default.aspx?pageid=250
http://www.aspose.com/categories/ssrs-rendering-extensions/aspose.cells-for-reporting-services/default.aspx
Thanks,
Challen FuChallen Fu [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2011 3:54am
Hi All...
I searched so many sites to find "Direct Export to excel/word from ssrs reports in asp.net c# windows or console application code?" but i did't get the right code and also save the exported excel file in specific folder.. Please provide
me best solution to solve my problem...
Best regards
September 30th, 2012 5:10am