MS Excel - write to and read from the same file?

Discussion in 'C#' started by DangerMouse, Jan 8, 2008.

0
  1. #1
    Hi,

    I have been given a spreadsheet with some fairly hardcore formulas/calculations that needs to be translated into a web application.

    It would make my life a million times simpler if I could feed in my data (via a web form) to cells a1, a2 and a3... let Excel do the clever stuff... and read the output from cell z1

    Is this possible or should I start breaking it apart now?

    Thanks for any help anyone is able to give!
     
    DangerMouse, Jan 8, 2008 IP
  2. ludwig

    ludwig Notable Member

    Messages:
    2,253
    Likes Received:
    66
    Best Answers:
    0
    Trophy Points:
    225
    #2
    ludwig, Jan 8, 2008 IP
  3. jlogic

    jlogic Peon

    Messages:
    25
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    You can also load up the Excel API. I remember doing it back with VS6.0 loading it as a COM object. It should work roughly the same. Then you can create an object in ASP load the spreadsheet in the object then feed it back in.

    The post above with Excel through ADO is a better idea though.
     
    jlogic, Jan 9, 2008 IP