The value is different in the table and in the Excel

Hi,
I try to add a row into a database with the value {“chao”,“”,“VietTravel Airlines”}
But I dont know why when I write the database into Excel, it turns out “Vietnam Airlines”.
And when I try to print the message box of the value in that position in the database, it still gives me the value “VietTravel Airlnes”


I’m so confused rn :((.
Thanks for helping me

@QUY_T_TAM_8.0_IELTS

can you pass the entire value as “chao VietTravel Airlines”

so that you will get the value as required when you place it in message box

if your are expecting any different way
please let me know

no, I mean when I call the value, It is still “VietTravel Airlines” in the sam position as in the database
But when I write data table to Excel using Write Range, I dont know why VietTravel Airlines be converted to VietNam Airlines

@QUY_T_TAM_8.0_IELTS

can you check the database table before you write it to excel

how the values your getting

Yah, the message box prints the right value “Chao”, “VietTravel Airlines”
But the only problem here is when I use UI Path to write this data to Excel, it changes my values to VietTravel Airlines

1 Like

@QUY_T_TAM_8.0_IELTS

you need to print entire table before writing it to excel

and compare the entire datatable

So that you can find out the issue where it is occuring either datatable or writerange

Hope this helps

1 Like

Hi @QUY_T_TAM_8.0_IELTS ,

Could you also check with the Write Line activity and inspect the Output Panel ?

Also, Could you let us know if you are modifying the datatable value after reading it or are you directly writing it to an Excel sheet using Write Range activity ? We would need to know if there are any additional activities involved so that we can eliminate the obvious.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.