Hi everyone, i have an excel with a date column in it at certain rows it has date value in it and at certain rows date value is missing i have to fill those missing values in excel. i dont have any idea how to do it. can anybody help me in this? i am attaching an excel for the same. GL.xls (1.9 MB) …

Try This one @aamir (From p In HdfcSelcolumns.Select() Where convert.ToInt32(DateTime.ParseExact(p.Item("Transaction Date").ToString().Replace(" 00:00","").Replace(" 12:00 AM","").Replace("-","/"),"dd/MM/yyyy",Globalization.CultureInfo.InvariantCulture).Day)>=15 And convert.ToInt32(DateTime.ParseEx…

Hi Mahesh, i tried with this. Its throwing an error. [image] [image]

@aamir , [image] MAHESH1: row((datatablevariable.Rows.IndexOf(row))-1)(“Date”) Instead of above, use this datatable variable.Rows(datatablevariable.Rows.IndexOf(row)-1)(“Date”) Regards, Dominic :slight_smile:

if u completed can you share this task xmal files or upload here

@aamir Sorry I failed to mention datatable variable in assign activitry. Use this in assign activity - datatable variable.Rows(datatablevariable.Rows.IndexOf(row)-1)(“Date”) It will work thank you @Dominic Regards Mahesh

@aamir Use write range after updating values Regards, Mahesh

Hi @aamir , First using read range activity store int into datatable, then loop through it if the date field is empty update the previous date field value. Refer the below xaml file. Main.xaml (12.4 KB) Regards, Arivu

@arivu96 [image] Filling missing values in Excel Help Hi @aamir , First using read range activity store int into datatable, then loop through it if the date field is empty update the previous date field value. Refer the below xaml file. Main.xaml (12.4 KB) Regards, Ar…

Hi @MAHESH1 , please verify the xaml file, i checked that condition also if it’s empty first row until gate find it ll not write the date value in the upcoming rows. once find the value then next field i empty it ll write the date value in that field., Regards, Arivu

Filling missing values in Excel

Help

aamir (saif) January 28, 2018, 5:00am 8

HI dominic,

This time it ran without throwing any error but its not written anything in my excel my excel is same as before not changed how should i write this and make changes. in my excel File.

Topic		Replies	Views
Selecting a row from excel from a particular ramge of date Help datatable , excel , activities	24	5054	February 26, 2018
Date format issue of excel file Activities excel , activities , question	21	1279	June 14, 2023
Problems in DateTime Help	27	5969	October 29, 2018
Date format change in excel column Activities excel	29	6193	October 22, 2020
How to replace existing row of excel based on condition date is greater than existing? Activities uiautomation , activities , studio , question	20	209	August 14, 2024

Filling missing values in Excel

Related topics