Datatable - excel - formula

[Vivek_Arunagiri]

In write cell, you can just need to write the formula. Please check the below post.

Write excel formula for row count

Hi, Facing problem while trying to set a formula in a desired cell(AZ1) of the sheet. The intention is to get the the last row with values in it, add +1 to it and use the new row to continue writing to the sheet. Formula : =MATCH(REPT(“z”,255),A:A) + 1 The C# escape sequence doesn’t work over here and unable to assign the same in variable. Tried to have the formula in Notepad and then copy the contents over to the cell but its giving error like “System.ServiceModel.FaultException: …