Create/ Edit a Excel File using Python Tool

Nuno_Meneses

Hello guys,

I have a couple of working python scripts to format excel that is working fine in VS. When I try to run them in alteryx python tool the excel files always get corrupted. 

I tried to run it on Alteryx version 2024.1 and 2023.1 and the results are the same. Your help would be very appreciated!

Thank you

import openpyxl

# Make a new notebook (workbook)
workbook = openpyxl.Workbook()

# Open a page (sheet) in the notebook
sheet = workbook.active

# Write something on the page
sheet['A1'] = 'Hello'
sheet['B1'] = 'World'

# Save your notebook with a special name
workbook.save(PATH)

Nuno_Meneses

I was getting this error using both pandas and openpyxl to create/edit an excel file. I upgraded the version of these libraries and the problem is solved.

@apathetichell Thank you for your help!