Pycharm sync

[PTPeter]

I have used VBA for years to build Excel macro's, but now I am learning how to use Python for this as it appears to be much better. I am working on an iMac and got the advice to install Pycharm for coding.

In the tutorials I am following, often new .xlsx files are made and then edited.
But each time I make a change in Pycharm, I have to close the .xlsx file and reopen it to be able to see the changes.

1. Is Pycharm the best free program to code in Openpyxl on Mac OS X?
2. Is there a way to make Pycharm (or any program) reload the .xlsx file automatically after I save?

Many thanks, I am just a n00b here ;-)

[DeaD_EyE]

1. Is Pycharm the best free program to code in Openpyxl on Mac OS X?

I use this IDE, but there is no "best" free program.

2. Is there a way to make Pycharm (or any program) reload the .xlsx file automatically after I save?

Indirect, but you have to program it. Maybe you could use also inotify watches on Mac OS. You observe the file change and if the file has been changed, the program have to read again the file.