Convert xls format to xlsx

Question

I have created an SSRS report using SQL server reporting services 2005. When I export to excel the report, it is saved in xls(2003) format. I want the report to be saved in xlsx(2007) format. Please give me a solution.
If SSRS 2005 does not support this then is there any other way to achieve like using a VB code we can convert xls to xlsx format?

Answer 1

After exporting in .xls format, you can SAVEAS the .xls to .xlsx format if you have MSOffice 2007 installed.

Upto my knowledge sql server 2005 doesnt directly export to .xlsx format.... please let me know if you find any other solution though.!!

Thanks

Answer 2

Hi Nisha,

As Kumar03 said, by default, the Reporting Services does not support Excel 2007 data render extension.

We have implemented the functionaly in SQL Server Reporting Services 2008 R2.

Thanks,
Jin Chen

---

Jin Chen - MSFT

Answer 3

Hai Jin

But the solution "SAVEAS the .xls to .xlsx format " should be done manually. I want an automated method to do it.

Answer 4

Hai Nisha,

For that you need to have SSRS 2008 Release2?

Which SSRS version are you using?

Thanks


Kumar