Hi,
I was wondering if it is possible to get xl notation such as AA1,AB2 etc from coordinates like (27,1) and (28,2).
my scenario is similar to the following
say i want to list 40+ products, column wise and just below each product name there is purchase cost, margin and selling price.
now i want to calculate selling price using xl formula like this '=SUM(AA2:AA3)'
In my program i am using integers to locate cells like this worksheet.Cell(27,4).value="xyz"
to set the formula i need excel notation like AA1 etc right?
so i was wondering if there is an easy way like this '=SUM( cell(27,2) , cell(27,3) )'
where cell(x,y) will automatically translate its coordinate to xl notation
Please tell me how to do this. is there a way to do this with ClosedXML already?
Thanks
