Read Range Workbook: Cannot convert 'Invoiced Data'!AN5's value to System.String

[Akhil_Jose1 (Akhil Jose)]

While reading excel file throwing this error “Read Range Workbook: Cannot convert ‘Invoiced Data’!AN5’s value to System.String”

Invoice Date is the sheet name

AN5 is the column(contains formula)

Kindly help!

[ashokkarale]

@Akhil_Jose1,

It might be happening due to AN5. May be Read Range is considering it as Cell address AN5.

Show the Read Range activity you are using and sample file if possible.

Thanks,
Ashok

[Akhil_Jose1 (Akhil Jose)]

Hi Ashok,

Thanks for the quick response.

Please check the screenshot.

I can’t share the file due to the company policies.

“=OFFSET($HR$5,0,MATCH(AM5,$HR$5:$QE$5))” it is the formula used in AN5

[ashokkarale]

@Akhil_Jose1,

Try checking PreserveFormat property if this helps.

If not, what’s the visible value at AN5 cell?

Thanks,
Ashok

[Akhil_Jose1 (Akhil Jose)]

Preserve format property I have already tried.

Value inside AN5 cell “202406”

Thanks
Akhil

[Yoichi]

HI,

As workaround, can you try to use ReadRangeX or ExcelReadRange with UseExcelFile?

Regards,

[ashokkarale]

@Akhil_Jose1,

Ok. Data also seems fine. Give it a try by Excel Process scope as suggested by Yoichi.

Thanks,
Ashok

[Akhil_Jose1 (Akhil Jose)]

Hi Yoichi/Ashok,

Thanks for the solution.

It worked using Excel process scope & UseExcelFile