String Value from a Cell with Japanese Characters is not being Read Consistently

Help Activities
, ,
1

Hi, hope you can help me with this. I have two test data (same Excel template, different data) each having different date (cell value) but having the same formula. I would like to read the value from the cell itself that contains Japanese characters and not anything from the formula and output it in UiPath. In Test Data 1, it’s being read correctly but in Test Data 2 it’s not… it’s getting a value from the formula and not the date written exactly on the cell. I’m not sure what’s wrong with the other template and why it’s not being read correctly.

Test Data 1 Cell Value:

enter image description here

Output Value from Read Cell (Correct Value):

enter image description here

Test Data 2 Cell Value:

enter image description here

Output Value from Read Cell activity (Incorrect Value):

enter image description here

I’m using String data type for the Output Value.

2

Hi,

For now, can you try to turn on PreserveFormat option?

Or

Can you share the numeric value when you use GenericValue?

Regards,

3

Hi @Yoichi,

I tried to mark PreserveFormat but it’s returning the same value from the formula:
image

For the GenericValue, I updated the post it’s on the different tool I’m working on sorry I got confused. I tried to change the data type for the output of this one to GenericValue as well but still the same output.

4

Hi,

Can you share your workbook? Dummy data is no problem if we can reproduce the issue.

Regards,

5

Kindly check this dummy. Thanks
Main.xaml (4.7 KB)

6

Hi,

Thank you for sharing.
Can you try to use ExcelApplicationScope and ReadCell activity?
Probably, this matter is caused something wrong with processing the formula in NPOI/ClosedXML.

OR

Can you try to modify the formula to the following in B1 cell? It will work with Workbook-ReadCell.

=IF(RIGHT($A1,2)="1Q",MID($A1,4,4)&"年"&"6月",IF(RIGHT($A1,2)="2Q",MID($A1,4,4)&"年"&"9月",IF(RIGHT($A1,2)="3Q",MID($A1,4,4)&"年"&"12月",IF(RIGHT($A1,2)="4Q",(VALUE(MID($A1,4,4))+1)&"年"&"3月","Error"))))

Regards,

7

I’m having issue with ExcelApplicationScope, tried the repair option but still the same error
image

Will try to modify the formula. Thank you

8

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