SSRS export to Excel UNFORMATTED

Question

Hey,

I'm looking into SSRS with intention of exporting a lot of the reports to excel. The problem is that when you export it changes cell sizes and removes borders to try and keep the original report format.

Is there anyway to stop this happening? So that the report exports to excel with the "usual" excel formatting? If it requires any coding that's fine as most of my reports will be run from C# code.

Thanks Mat

Answer 1

You could export to a CSV and import that into a spreadsheet, possibly with some sort of template sheet for the particular report.

Answer 2

You could export the data to Sheet2. Mark sheet 2 as hidden.

Create your designer report on Sheet1.

Run an Excel Macro to read data from Sheet2 and put on Sheet1.

Answer 3

It's not pretty, but you could consider generating Excel sheets from the XML renderer, as described here - this would give you full control over the appearance of the worksheet.