locked
Issue on Populating Data in Macro enabled excel Template - OpenXml SDK package RRS feed

  • Question

  • Hi All,

    I am facing an issue to populate Data in formulae enabled cells. The value I am passing through code is disappearing after clicking on

    Enable editing in the generated excel template.

    After generation from code,

    "Unit of 
    Measure" Start Date End Date
    HOUR 7/1/2017 11/30/2017
    HOUR 6/1/2017 12/31/2017
    HOUR 8/1/2017 10/31/2017
    HOUR 7/1/2017 9/30/2017

    After clicking on enabled editing on excel sheet , the values are getting change as per the formulae applied in the cell.

    "Unit of 
    Measure" Start Date End Date
    HOUR 6/1/2017 12/1/2017
    HOUR 6/1/2017 12/1/2017
    HOUR 6/1/2017 12/1/2017
    HOUR 6/1/2017 12/1/2017

    But I wanted to retain the values which I am writing from the code.

    Is there any way to achieve this using excel settings?

    And , is there any method to remove the formulae only for particular cells using openxml sdk package without any template contents loss?

    I am using openxml sdk package to write the value in the excel template.

    Thanks in Advance,

    Rupesh


    Tuesday, October 24, 2017 12:45 PM