Excel worksheets not opening as expected

[jmichels9]

I'm trying to open an Excel worksheet using the TryOpenWorksheet method from ExcelDataReader. However, the method is continuously returning false, and failing to open the sheet. After some initial debugging, I was able to get into the OpenWorksheet method of XlsxWorkbookReader. From there, I took this screenshot:

Based on that screenshot, you can see the sheet part variable (line 219) is including a leading \ character. There's logic in place (on line 220 in the screenshot) that appears to be removing a forward slash instead. I was curious if adding similar logic to strip the backslash is possible or advisable.

Thanks!

P.S. For reference, here are 2 files - the "bad" file which has a sheet failing to open and a nearly identical "good" file that loads as expected after I open/save the "bad" file directly in Excel:

sample_file_bad.xlsx
sample_file_good.xlsx

[MarkPflug]

This should be fixed in the next release. Fixed with #201