Formula for Excel Cell - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Formula for Excel Cell

mumpizmumpiz Posts: 75Member

Im creating an Excel Export class that fills Excel sheets with
various values created by some construction application.

So far everything works well, but now Users would like to use sheets as proper excel sheets, so all the cells that hold calculated values are supposed to be created as such, and not just hold my calculated value.

This is to enable the user to e.g. add values and sheet automatically calculates a new sum, multiplication, or division value. I could use string to format cell, like:
mExcelSheet.Cells[iRow, iColum] = "=SUM(D1:F1)";

but thatll be harder for localization,

does anyone know how to do it without localized strings???


Sign In or Register to comment.