Hello all community friends.
I have excel table that column contain a date.
However, some date is missing.
So, I would like to write UiPath that can read the date and insert column of missing date.
Please refer picture of table below.
P.S. In table you will see 09/08/2025 then jump to 13/08/2025.
I need UiPath to insert 10-12/08/2025,
Hope to receive advice from you all.
Hi, @MontikaChaikittiporn first you can Read Range → get your table into a DataTable.
Then Get all date columns → dt.Columns.Cast(Of DataColumn).Select(Function(c) DateTime.Parse(c.ColumnName)).OrderBy(Function(d) d).ToList()
After that Loop through dates → check if NextDate = CurrentDate.AddDays(1); if not, insert missing columns using Add Data Column activity with that missing date as column name.
Hello @MontikaChaikittiporn
Try below flow
Forum_column_manipulation.zip (8.5 KB)
It will definitely work
Regards,
Rajesh Rane
Thank you for your advice. However, I didn’t have write range workbook activity.
Can I use write range instead?
Hello @MontikaChaikittiporn,
Are you using my workflow?
If yes then its because of the package issue
Install the package UiPath.Excel.Activities
I already installed it. It still didn’t work. 
Try installing UiPath.UIAutomation.Activities
It didn’t work too. So sad.
Hello @MontikaChaikittiporn
If you are free then we can connect on a call for 15 min.
its small error , will not take much time
Regards,
Rajesh Rane
hi, @MontikaChaikittiporn check packages version and update same as in Screenshot
