(Apologies if this is not the correct sub-forum for posting)
I would like to use some Python code to populate columns in the Edges and Vertices worksheets of an XLSX file saved after opening the NodeXL template using MS Excel 2016 on Win10.
The Python library I am using is openpyxl, and it successfully writes the data to the XLSX file. However, after I run my process and open the XLSX file, the NodeXL tab is no longer available.
I have made the folder where I store the XLSX file a trusted location for Excel. I also checked that I could save a blank XLSX file (made from the NodeXL template) to the same folder, close it, open it again and see the NodeXL tab (I can).
So it only seems to be after I manipulate the file with Python/openpyxl that the NodeXL tab disappears.