Home › Forums › NodeXL Data Importers: Issues with Twitter, Facebook, YouTube and other network importers › [Python] openpyxl breaking NodeXL file?
Tagged: python
- This topic has 0 replies, 1 voice, and was last updated 5 years, 1 month ago by
ferstaberinde.
- AuthorPosts
- August 15, 2018 at 10:24 am #7961
ferstaberinde
Participant(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.
Is there a way for me to re-enable the tab?
Many thanks in advance for any pointers!
- AuthorPosts
- You must be logged in to reply to this topic.