Read Range X Failed - Exception has been thrown by the target of an invocation (Text method of WorksheetFunctuon class failed)

Help StudioX
,
1

Hi I’m using StudioX and i’m trying to read data from an excel sheet and paste it another excel template. But when I run the bot, it throws me this error. Please let me know what i’m doing it wrong.

1 Use Excel File > 1.1 Read Range (selected the sheet tab inside the excel file) Has Headers :heavy_check_mark: Visible rows only :heavy_check_mark:

Save to (Created a variable name).

2

Hi,

Can you share screenshot of your workflow?

Regards,

3

Hi heres the screenshot

StudioX error
StudioX error743×848 38.2 KB

5

image
image719×831 67.7 KB

6

Hi,

It seems your workflow has no problem. There might be something data / formula UiPath cannot handle.
For now, can you try to change to DisplayValue or RawValue at ReadFormatting of UseExcelFile?

Regards,

7

Hi Yoichi, i use Rawvalue and it works! Thank you :grin:

1 Like