Excel Calculation Engine … does it or does it not exist in open xml sdk?

Home › Forums › Open-Xml-Sdk › Excel Calculation Engine … does it or does it not exist in open xml sdk?

This topic contains 1 reply, has 2 voices, and was last updated by  Eric White 8 years, 4 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • June 21, 2016 at 4:13 pm #3518

    hchan
    Participant

    Hi,

    I’m a bit confused as to what the open xml sdk offers and what it does not wrt Excel.

    Does it have a calculation engine?

    If I open an excel file, change a value(A1) and read another cell(B2) that uses a formula(A1*2)
    will B2 update with that value?

    If it doesn’t update immediately (cache or something), can I save the changed cell (A1) into the existing .xlsx file and REOPEN the file again. i.e., if “re”-calculate doesn’t work, does “calculate” on open work?

    thx,

    Henry

    June 27, 2016 at 1:43 pm #3532

    Eric White
    Keymaster

    Hi Henry,

    The Open-Xml-Sdk does not contain a calculation engine. Its purpose is only to read and write the file formats.

    Typical uses with regards to Excel are:

    • Generation of spreadsheets
    • Querying spreadsheets and retrieving data

    Modifying existing spreadsheets is a less common and useful scenario for the Open-Xml-Sdk.

    If you need to have an actual calculation engine, you need to automate Excel. I believe that there are commercial products other than Excel that contain Excel compatible calculation engines, but I have no experience with them.

    Regards, Eric

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.