Different Type Result In excel Write range

Help Activities
, , , ,
1

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

image

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

2

@Aldhyt_Wirangga1

try to use this once

image
image1172×862 54.8 KB

select custom and pass the format which you want and try

cheers

3

thank you for reply, i hope there is a workaround without use excel file activity

4

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.

5

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

6

@Aldhyt_Wirangga1 ,

As already suggested, could you try writing to a Different file and check if it is the same output ?