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.
I have dates in my excel. When i delete all the range in my excel file to write the new datatable (without the line which have an “OK” on the status), the format of the date change (French to US). How i can keep the good format.
Maybe there is a solution without delete all the range and just remove directly on the excel file ???
If anyone have a solution, please help me
Thank all !