Invoke python code

i writing sample python code in invoke python action, but Iam getting error like this (ModuleNotFoundError : No module named ‘openpyxl’)

My code :
import openpyxl

load the Excel workbook

workbook = openpyxl.load_workbook(‘jameer python.xlsx’)

select the worksheet to work with

worksheet = workbook[‘Sheet1’]

read data from a cell

cell_value = worksheet[‘A1’].value
print(‘Value of cell A1:’, cell_value)

write data to a cell

worksheet[‘B1’] = ‘Hello, World!’

save the changes to the workbook‘jameer python.xlsx’)

The error say you forgot to install openpyxml.
See here on how to do that

iam installed openpyxml in commmand prompt but still iam getting this error?

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.