Get a reference to Excel spreadsheet?

Discussion in 'ASP .Net' started by CK, Feb 28, 2006.

  1. CK

    CK Guest

    I have an ASP.net app that uses the DataDynamics spreadbuilder. It basically
    creates an Excel spreadsheet and populates it with a dataset by looping
    through the set. Everything works great except that the spreadbuilder
    doesn't support formulas. I add formulas through the setvalue method but it
    just puts a string of the formula in the cell. I have to manually go to the
    cell and click the fx button with the formula cell selected. Is there some
    c# code that I can get a reference to the open workbook/worksheet and pass a
    cell reference so I can make sure and set it as a formula. Any ideas? I
    don't want to have to redo the project using just excel. Any help is always
    appreciated.

    Thanks In Advance,
    Chris
    CK, Feb 28, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. FSD
    Replies:
    0
    Views:
    1,180
  2. Tim Marsden

    Displaying an Excel spreadsheet

    Tim Marsden, Feb 20, 2004, in forum: ASP .Net
    Replies:
    5
    Views:
    2,617
    S. Justin Gengo
    Feb 20, 2004
  3. =?Utf-8?B?S2VpdGhSYWdpbkZAbmV3c2dyb3Vwcy5ub3NwYW0=

    Returning Excel Spreadsheet as web page

    =?Utf-8?B?S2VpdGhSYWdpbkZAbmV3c2dyb3Vwcy5ub3NwYW0=, Apr 23, 2004, in forum: ASP .Net
    Replies:
    10
    Views:
    2,718
    Steven Cheng[MSFT]
    May 6, 2004
  4. Roger Twomey
    Replies:
    1
    Views:
    12,578
    Roger Twomey
    Apr 27, 2004
  5. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,481
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
Loading...

Share This Page