Excel is replacing blank value

Help Activities
, , , ,
1

In datatable i have blank value.i need to update the datatable in excel,but in excel there are some formula it’s getting replace by the blank value in excel what is the solution for this

2

Hello @sruthesanju

Could you please give more insights to your issue.

Are you getting this datatable from some other source and you are trying to write that to an Excel?
Else plz give some screenshot and explain the requirement.

3

Yes I am getting datable from othersource and updating in excel

4

Then which formulas are getting deleted? Are you keeping some default excel template and writing data to that?

5

Yes there is some default formula in excel

6

before writing to excel replace all null value with a zero and then write to excel.

7

If i replace the blank value in datatable to zero will it replace the formula in excel

8

I think no…That is your requirement ryt

9

It’s now replacing the formula in excel as zero

10

Can you share a screenshot of the excel and is it replacing other values??