Hi everyone, That’s my issue with excel file : My bot add row in an excel file and after the bot check on the datatable if there is an “OK” on status column, if there is an “OK” the bot take the row > Add to a collection > and for each row in the collection the bot remove the row in the data table…

@Srini84 Thanks for your help but i found the solution on my side :slight_smile: I use Write Range workbook and nothing change ! If a person encounter this issue where formats for date or something like that change, need to use Write range for Workbook and not for Excel.

Delete range in excel file (issue with date format)

Help

Srini84 (Srinivas Kadamati) September 2, 2020, 10:22am 4

@BCdev

For adding the value you have to use assign activity

You can use both keep and delete options

Check below post for your reference

In the above one I am using

DT.Rows(IndexofRow).Item(ColoumnName) = Your Value

Topic		Replies	Views
Deleting a row from excel on a date based condittion Help datatable , excel , question	10	2294	March 13, 2020
Remove rows from Excel sheet Help datatable , excel , activities , question	20	1392	December 20, 2019
After reading excel table date row is becoming double values Activities datatable , excel , activities , question	15	2287	March 25, 2021
Write range date formatting Activities excel , activities , question	16	2757	February 3, 2022
Deleting a row from excel on specific condition Help datatable , excel , activities , question	18	5393	June 21, 2023

Delete range in excel file (issue with date format)

Related topics