Clarify what options there are for read_options for calamine in read_excel

[mdavis-xyz]

Description

The docs for read_excel say:

read_options
Options passed to the underlying engine method that reads the sheet data. Where supported, this allows for additional control over parsing. The specific read methods associated with each engine are:
“calamine”: ExcelReader.load_sheet_by_name

There's no hyperlink there. I think there should be.

What is ExcelReader.load_sheet_by_name? It's quite hard to find. (I've never heard of calamine before.)

• I went to the docs for the rust calamine crate here. There is no load_sheet_by_name
• I looked up pycalamine. There is no load_sheet_by_name
• Elsewhere in the docs for read_csv there is mention of fastexcel. here are the docs for that, which does have a load_sheet_by_name method

If that last link is correct, then I think the docs should have a hyperlink to it, or at least name which package the listed method is from.

Link

https://docs.pola.rs/api/python/dev/reference/api/polars.read_excel.html

[cmdlineluser]

Yeah, it's a bit confusing because the Python module name is fastexcel.

• http://fastexcel.toucantoco.dev/fastexcel.html#ExcelReader.load_sheet_by_name

[alexander-beedie]

Yup, some links would be helpful here... 📖🤔