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

Discussion in 'Programming' started by DangerMouse, Jan 8, 2008.

  1. #1
    Hi, please forgive me if this is the wrong place to post this query - I've also posted under ASP (i'm happy to implement using either!)

    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. tbarr60

    tbarr60 Notable Member

    Messages:
    3,455
    Likes Received:
    125
    Best Answers:
    0
    Trophy Points:
    210
    #2
    I had a client ask me to use Excel as the "database" behind a website. It was just for a birthday club sign up so not so mission critical. I was able to place an Excel file on the webserver and set it as a datasource. The only thing special in ColdFusion was using brackets on some or all column names.
     
    tbarr60, Jan 8, 2008 IP