Jul-15-2024, 06:36 PM
I am trying to make devs aware of issue I ran into.
Basically,
I've already solved my issue by choosing another name, but this was weird enough that I wanted to post about it.
FYI, I know that excel files have length limits (in the 200s) but the full path named I used has 109 characters. Finally, I will mention that record is a variable name for a string and 'Record' is a key in a pd.DataFrame previously in the code.
Basically,
pd.ExcelWriter(output_path+'\\'+'HiT Nano battery title info2.xlsx',engine='xlsxwriter') is accepted. But, when I change the title to include anything including the string 'record' it was rejected. By rejected, I mean the file was created but I couldn't open it. Windows file explorer would tell me that the file is corrupted and python environment said something about a xls issue (even though everything else I could find clearly identified the file as xlsx).I've already solved my issue by choosing another name, but this was weird enough that I wanted to post about it.
FYI, I know that excel files have length limits (in the 200s) but the full path named I used has 109 characters. Finally, I will mention that record is a variable name for a string and 'Record' is a key in a pd.DataFrame previously in the code.