question

dcrooks avatar image
dcrooks asked

Import an Excel Spreadsheet into ReportWriter and generate Excel files

Is there a way import a complex Excel spreadsheet in RS and use that to generate new spreadsheets with having Excel installed? TIA!

David L. Crooks

sql-server-2008ssrsexcel
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sp_lock avatar image
sp_lock answered

If you wanting to use a SSRS model to report from the Report Builder you can create a view that looks at the EXCEL sheet as a "linked server".

Once the view is created you can create a dsv with SSRS and then you will be able to report off that model.

Then, using the export function or subscription you can generate xls/csv files.

JL

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.