Bug: Create excel with sheet named "sheet"
Code Sample, a copy-pastable example
writer = pd.ExcelWriter("test.xlsx", engine="openpyxl")
pd.DataFrame().to_excel(writer, sheet_name="sheet", index=False)
writer.save()
pd.read_excel("test.xlsx", sheet_name="sheet")
>> KeyError: 'Worksheet sheet does not exist.'
Problem description
Executing DataFrame.to_excel() with sheet_name="sheet" creates an Excel with a sheet named "sheet1" instead of the requested name "sheet".
Expected Output
An Excel with a sheet named "sheet".