I wanted to write formula in 100 columns of excel. I am writing the below formula - “=SUM(”“A”+ CellCounter.ToString +“B”+CellCounter.ToString)“” but it is giving the error like end of exxpression required.
The formula should written c1,c2,c3…c100 Cell of excel. The CellCounter is int variable whose value increasing each time in foreach look.
Please help .
This has removed the error but it is writing formula in excel and giving the proper result. Actually, It should type C2= A2 + B2 and result should be in cell but is not giving.
The value for CellCounter.ToString is not getting evaluvated which is the problem. We have addedd the double quotes around variable A WHICH CAUSING THIS issue.