You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Versions of xlwings, Excel and Python (e.g. 0.11.8, Office 365, Python 3.7)
Python 3.10 64 bit, xlwings 0.20.08
Describe your issue (incl. Traceback!)
I have script to create pivot tables in excel using xlwings. I get an error saying Kernel died when the code execution reaches to creating pivot table. it runs fine untill the point of creating a cahce. I checked memory usage and somehow at that point memory usage spikes up. the data files are relatively small around 250-600Kb range. Not sure why it the kernel keeps dying. I use Jupyter Notebook and I have tried using spider, PyCharm and was able to replicate same issue in other IDEs.
# Your traceback hereKerneldied
Include a minimal code sample to reproduce the issue (and attach a sample workbook if required!)
for file_name in os.listdir(folder_path):
if file_name.endswith('.xlsx'):
file_path = os.path.join(folder_path,file_name)
@fzumstein - thanks felix for your response. I actually found a solution in other threads. explicitly defnining TableDestination values helped resolve the issue. Thank you again for your time!
OS (e.g. Windows 10 or macOS Sierra)
WIndows 11
Versions of xlwings, Excel and Python (e.g. 0.11.8, Office 365, Python 3.7)
Python 3.10 64 bit, xlwings 0.20.08
Describe your issue (incl. Traceback!)
I have script to create pivot tables in excel using xlwings. I get an error saying Kernel died when the code execution reaches to creating pivot table. it runs fine untill the point of creating a cahce. I checked memory usage and somehow at that point memory usage spikes up. the data files are relatively small around 250-600Kb range. Not sure why it the kernel keeps dying. I use Jupyter Notebook and I have tried using spider, PyCharm and was able to replicate same issue in other IDEs.
Include a minimal code sample to reproduce the issue (and attach a sample workbook if required!)
for file_name in os.listdir(folder_path):
if file_name.endswith('.xlsx'):
file_path = os.path.join(folder_path,file_name)
The text was updated successfully, but these errors were encountered: