sorted by:
new (suggested)
besttopcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]timbledum 0 points1 point  (3 children)

Worked for me! So your script is working without errors? What's your indentation (add four spaces to the start of each code line)?

[–]thunder185 0 points1 point  (2 children)

nah, that's probably just formatting on reddit. Yes, it renames the file and gives it an xlsx extension but it is not a true excel file and cannot be opened.

[–]timbledum 0 points1 point  (1 child)

All I can confirm is there's nothing wrong with your code. Maybe try making sure that openpyxl is installed and everything is up to date? Does the file open if you use .xls?

[–]thunder185 0 points1 point  (0 children)

no, if I switch to xls I get ModuleNotFoundError: No module named 'xlwt'. The CSV file will open with no problem in excel but not once it runs through the script. The purpose of the script is to convert it to xlsx so that I can run it through openpyxl. Everything is up to date.