Help Needed: Read Range - Get the Pivot Data: Non-negative number required. Parameter name: lengths[0]

[Ajinya_jorwekar]

Hi everyone,

I’m encountering an issue while using the “Read Range” activity in UiPath. The error message I’m getting is:

Non-negative number required. Parameter name: lengths[0]

This error occurs when I’m trying to get pivot data from an Excel file. I’ve checked my data and everything seems fine, but I still can’t figure out what’s causing this error.

Earlier it is working fine, Suddenly gets this error in production machine, i have Updated all the packages with latest version, Still getting error
Please help me.

[pravallikapaluri]

Hi @Ajinya_jorwekar

Can you try by checking the strRange variable is holding value or not in the immediate panel while debugging.

Hope it helps!!

[Ajinya_jorwekar]

Yes.

[rlgandu (Rajyalakshmi Gandu)]

@Ajinya_jorwekar

In Range you pass StrRange Please check the Range of that variable either in Log Message or Debug the process and watch the value of StrRange in “Immediate Panel”

[Yoichi]

HI,

It may be Workbook-ReadRange (3rd party library) limitation regarding recent excel feature.
So, can you try to use UseExcelFile and ReadRange (ReadRangeX) instead of ReadRange(Workbook)?

Regards,

[pravallikapaluri]

@Ajinya_jorwekar

can you please check the data is passing to your dictionary var/arg also.

[Ajinya_jorwekar]

Thank You @Yoichi @pravallikapaluri @rlgandu for quick response.