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
workbook.save(‘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?
system
Closed
#4
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.