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!


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.