Read Range Workbook returns me error "Implement it based on poi 4.2 in the future"

Hi everyone,

I am currently struggling with Excel automation.
I have to Read a range of an excel sheet (very common action that used to work fine for me for the last 3 years). When the robot goes through that activity it returns that weird error message : Implement it based on poi 4.2 in the future

Does anyone know what it means? I am a bit lost…

@Ahmed_Loirdi

Try these setting on trust center…is the extension .xls?

https://www.clouddirect.net/knowledge-base/KB0011787/changing-file-block-settings-to-enable-old-excel-file-types-to-be-opened-as-normal

Cheers

Thank you for your support, I had already had that settings.

Apparently that’s an error message that pops up when a file could be encrypted.
I used that workaround:

  • Give up Read Range Workbook activity
  • Use (inside Excel Process Scope and Use Excel Files activities) a For each Sheet in Excel
  • Then add an If with the following condition: CurrentSheet.Name.Contains([KEYWORDS])
  • Finally add a Read Range from Excel package. This solution is slower but works fine
1 Like

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