Post reply

Writing to an existing excel spreadsheet

  • 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!

  • October 19, 2009 at 12:59 am

    #1067525

    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

  • October 20, 2009 at 3:00 am

    #1068027

    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

  • October 20, 2009 at 9:41 am

    #1068309

    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.

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

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