I'm looking to get the name of the cell given by the row / column pair. I need a name to use in the formula For example, I want to set a formula (3, 4) in a formula that combines the values of cells (4, 4) and (5, 4) is.
Cell (3, 4) is D5
; (4, 4) is E5
, and (5, 4) is F5
. Therefore, my formula should look like this:
= E5 + F5
I can format my form in such a way:
constant int col = 3; Const int row = 4; Worksheet Seals [row, cola]. Formula = string. Do not use the format ("= {0} {1} + {2} {3}", (four) ('A' + Col 1) // & lt; 1, (four) ('A' + 2 + 2) //
This column works fine for A..Z, but with the name breaks right next to the column I could use it, but the problem seems so basic That he should not need coding on his part.
That's right, you do not need this code, because Asaj has done this for you. Their Cells is the method in the Helpper class, which does exactly what you do:
const int col = 3; Const int row = 4; Worksheet Seals [row, cola]. Formula = $ "= {cel. Helper.cllandexioName (row, collect + 1)} + {cilsehalfper.SilindExtam (line, cl + 2)}";
No comments:
Post a Comment