Hello guys Im trying to write range all my data to another excel when i am using debug mode and looks the inside of datatable the result are fine but when im writing to excel the result lil bit different
as u can see in i have no issue from before and after rows in yellow marks im converting MM/dd/yyyy to IND version but there is only one row with issue
try to use this once
select custom and pass the format which you want and try
cheers
thank you for reply, i hope there is a workaround without use excel file activity
Hi @Aldhyt_Wirangga1 ,
Could you let us know if this another Excel File is already present or it is being created by the Robot ? If it is already present, it could be that the Format of the Excel file is present in that way where the one Cell is formatted in a Different way.
To confirm you could try writing the datatable to a different file or a new File that the Robot itself creates.
thanks for the reply, the excel file was builded by manual its just making the headers and all format type is general but when that rows writing its changing by itself to custom format
As already suggested, could you try writing to a Different file and check if it is the same output ?
