Range does not exist while using write value


#1

I write the values from DataTable to Excel. i was able to see the values in excel.But my issue is, while apply the formula using write value, i am getting The range does not exist error. Can any one let me know, why i m getting this issue?

=======

I write the values from DataTable to Excel. i was able to see the values in excel.But my issue is, while apply the formula using write value, i am getting The range does not exist error. Can any one let me know, why i m getting this issue?


#2

can you share ur xaml file for debugging?


#3

Hi @kiran,

It basically happens when you are using ; inside the formula string, try replacing them with , (comma) at some places in the formula and test it again. Maybe it will help you.