Writing to an existing excel spreadsheet

Question

Writing to an existing excel spreadsheet

daveb-840383

SSC-Addicted

Points: 477
More actions
October 15, 2009 at 5:06 pm

#385591

Hello,
I need some advice for writing a report.
They want me to use an existing excel spreadsheet that already has built-in calculations. (see attachment)
Should I use SSRS or SSIS? What's the best way to approach this?
Thanks in advance!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Arunkumar S P SSCertifiable Points: 6415 More actions · Answer 1

What you want to do with this excel?. Sorry. I'm not getting you

-----------------------------------------------------------------------------------------------------------------------------------------------------------
Please feel free to let me know if you are not clear or I’ve misunderstood anything.

Thanks,
Arunkumar S P

Neuro Ten Centuries Points: 1063 More actions · Answer 2

Taking a long shot here without know the full description :

neither you could do this in Excel with SQL

create a separate excel sheet for you to download the data into (datasheet)

and attach lookups that pick up the data from the data sheet

but you probably want to write a macro for getting the data into the spreadsheet

neither of the above is very hard and a quick google will show you the macros you need to write

Robert.Smith-1001156 Mr or Mrs. 500 Points: 502 More actions · Answer 3

I can tell you what NOT to do: Don't be tempted to go down the OPENROWSET wormhole.

I spent hours trying to figure out why stored procedures that use OPENROWSET to update an Excel spreadsheet would work sometimes and not others.

It turns out that you can't use OPENROWSET to update Excel cells that have a formula in them, so if the user has entered 48 (for example) in a cell then you can update that row but if the user has entered 4 * 12 in a cell then you can't update that row.