I am getting this error while running read range workbook activity. Please help me solve it

I am getting this error while running read range workbook activity. Please help me solve it.

NU1102: Unable to find package DocumentFormat.OpenXml with version (>= 2.20.0)

Read Range Workbook: Could not load file or assembly ‘DocumentFormat.OpenXml, Version=2.7.2.0, Culture=neutral, PublicKeyToken=8fb06cb64d019a17’. The system cannot find the file specified.

@Mayur_N

  1. Try changing the excel package version and check
  2. Try to use excel scope activities instead

cheers

Hi @Mayur_N

Update the UiPath.Excel.Activities package to latest version and select the Lowest as applicable in the Runtime rule option in Manage packages and check.

Hope it helps!!

@Mayur_N

Even excel scope read range will give a datatable

cheers

Please check out my full error which I have updated now.

Thanks!

@Mayur_N

then in your manage packages select lowest applicable

else try the other two ways mentioned above

cheers

Hi,

Update your studio & restart the studio as well as the machine. This will hopefully resolve your issue.

Thanks

@Mayur_N did you find any solution for this? I’m also facing the same issue and could not find any solution for this issue…