TST: Change a failing wb test #8768
Fixes a previously poorly designed test in io.wb.

Closes #8768

merged via https://github.com/pydata/pandas/commit/a617b0b60bc5b1a768b39b8ca4488b6399417ad4

thanks!
