python how to read a xlsx file
import pandas as pd
df = pd.read_excel (r'Path where the Excel file is storedFile name.xlsx')
print (df)python how to read a xlsx file
import pandas as pd
df = pd.read_excel (r'Path where the Excel file is storedFile name.xlsx')
print (df)update xls file using python
"""
Enter the following command `sudo pip install openpyxl
if this doesn't work download openpyxl zip file from
https://pypi.org/project/openpyxl/
after that extract it and then open the folder in terminal and write
`sudo python setup.py install`
""""
import openpyxl
try:
path = "pathOfxlsFile/filename.xls"
wb_obj = openpyxl.load_workbook(path.strip())
# from the active attribute
sheet_obj = wb_obj.active
# get max column count
max_column = sheet_obj.max_column
max_row = sheet_obj.max_row
print(f"nn coulumns {max_column} nn")
print(f"nn rows{max_row} nn")
for j in range(1,max_row):
#count starts form 1, don't use 0
cellThatIsToBeChanged = sheet_obj.cell(row=j, column=1)
cellThatIsToBeChanged.value = 'new modified value'
wb_obj.save('fileName.xlsx')
except Exception as e:
print(e)Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
