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

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.

Yes I am getting datable from othersource and updating in excel

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

Yes there is some default formula in excel

before writing to excel replace all null value with a zero and then write to excel. [image] LINQ query to update(replace)datatable in uipath Help LINQ query to update(replace)datatable in uipath

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

I think no…That is your requirement ryt

It’s now replacing the formula in excel as zero

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

Excel is replacing blank value

Help Activities

Rahul_Unnikrishnan (Rahul Unnikrishnan) June 7, 2022, 6:22pm 6

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

Topic		Replies	Views
To Replace Blank Value in Column Studio datatable , excel , activities , studio , question , activities-panel	8	869	November 27, 2023
Replace Excel Cell value Studio excel , activities , studio , question , extension , system	1	1347	September 27, 2021
UiPath Excel Sheet Fields getting blank Activities excel , activities , question	3	333	October 13, 2023
Replace Blank\Null values on datatable Studio excel , activities , studio , question , microsoft-office365 , designer-canvas	22	3656	August 23, 2023
Check row is empty or not in excel and update value in another sheet of excel Automation Starter datatable , excel , activities , studio , question	5	1382	August 8, 2022

Excel is replacing blank value

Related topics