January 8, 2016 at 8:32 am
Looked round the web and cant see an answer anywhere - is it possible to export to excel and have the headers of a table as teh headers in excel. I can envisage users not being able to run say a mailmerge or some such thing, if headers arent there.
Thanks in advance.
January 8, 2016 at 2:50 pm
Hi,
If you export to Excel the tablix heading will export too. CSV exports will only export with the Textbox Name properties as headings. Do you have a scenario or example where the Excel export isn't exporting the headings?
January 11, 2016 at 4:10 am
Sorry - what I mean is teh header is exported but as line one of data in excel. Since its teh header in SSRS i want it a the header/field names in ecxel.
THanks
January 11, 2016 at 6:31 am
So you want to export as an Excel Table (https://support.office.com/en-us/article/Overview-of-Excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c)?
If that is the case I do not think it is possible. You can use a report as a data source for a Table using the OData / Atom source but, tbh, it doesn't work very well.
January 11, 2016 at 6:48 am
No dont need most parts of that - just the headers being teh header in the datasheet, ie replacing A , B , C etc
January 11, 2016 at 7:09 am
Excel doesn't really work like that, there isn't any schema for the data in the spreadsheet, it works on cell references so the worksheet headers will always be A-Z etc.
Some functions have behaviors where they will treat data in the first row as column names but it is just convention.
This is how Excel works by design so chances are if users are doing mail merges etc the software they are using would handle this or they would be able to themselves.
January 11, 2016 at 7:24 am
Cheers - your absolutely right - I have no idea why I thought otherwise - thanks - that solves that! 🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply