This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I tried Package.installPackages(['openpyxl']) same error
My code is used to connect to an excel workbook and extract each sheet in new a workbook that work fine outside Alteryx.
from openpyxl import load_workbook, Workbook
wb = openpyxl.load_workbook(r"My workbook")
for sheet in wb.worksheets:
new_wb = Workbook()
ws = new_wb.active
for row_data in sheet.iter_rows():
for row_cell in row_data:
ws[row_cell.coordinate].value = row_cell.value