I am having following requirement.
Suppose in Cell A1, I am having Value as 10.
Now I want to append string "Total Number of Days" + Cell A1 value in other Cell.
In normal excel file , we can write formula like
="Total Number of Days"&A1
But for the above thing, how to do using C#.
I used below code, its not working
string str="\"Total Number of Days\"";
workSheet.Cells[3,1].Formula="="+ str + "A$1";
Please any one can help out.