Write data to .XLS instead of .XSLX

Is there a way to export my data to the old excel format .xls(1997-2003)
Some software I use requires it to be in that format.
Ive tried changing the extension before creating the file but this does not seem to work.

Change the extension after the file is written and saved.

I can save the file as an .xls after creating but that requires extra steps. This script will be used a lot and i try to make it perfect with the least amount of steps possible.

The program can change the file. No extra steps for the user. Simple to code.
Writing a new node to go directly to xls is a lot more steps. Pandas supports xls. So, that would be your direct route.

1 Like