How to update Micro-enabled excel (*.xlsm)?

Home › Forums › SpreadsheetML › How to update Micro-enabled excel (*.xlsm)?

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

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • July 7, 2016 at 6:43 am #3559

    vishalk
    Participant

    Hi Eric,

    Can Micro enabled excel file updatable using OpenXMLPowertools?

    If we update some specific cell which is referenced in same excel file but in another sheet, does it calculate and update the value in it?

    Does it support custom functions as well?

    Thanks in advance for you help.

    August 25, 2016 at 5:57 pm #3691

    Eric White
    Keymaster

    Hi,

    Very sorry for the slow response – have been on vacation, traveling, etc.

    You can open a macro enabled XLSM using the Open-Xml-Sdk, but you are limited to directly changing the contents. There is no calculation engine in the Open-Xml-Sdk, so if you change values, it does not change the values in the dependent cells. And custom functions are also not part of the functionality of the Open-Xml-Sdk and Open-Xml-PowerTools.

    Cheers, Eric

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

You must be logged in to reply to this topic.