zero88 / robotframework-excel

Robot-framework auto-test excel
Apache License 2.0
20 stars 12 forks source link

Get Column Count does not return number of columns due to XLRDError #19

Open dxtr80 opened 4 days ago

dxtr80 commented 4 days ago

Get Column Count doesn't work as expected and return XLRDError: No sheet named <b'AC_25_1150_PTP'> Good to mention that file is opened and Get Sheet Names return in my case proper names of sheets like: @{Sh_names} = [ AC_25_1150_PTP | AC_25_1150_GTG | AC_25_1000_PTP | AC 25_800_PTP | ACC_20_1150 ]

Environment

To Reproduce

  1. Open any Excel (xls) file with couple of sheets inside
  2. Use Get Sheet Names to get sheet names
  3. Use Get Column Count to get number of sheets inside

Exception Log

  1. XLRDError: No sheet named <b'AC_25_1150_PTP'>

Expected behavior

  1. Get Column Count should report "4" sheets in my case

Additional context

zero88 commented 3 days ago

Thank you for reporting. I will find a time this week to reproduce the issue and fix it, if possible.