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"\n\n coulumns {max_column}  \n\n")
    print(f"\n\n rows{max_row}  \n\n")
    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)

Similar codes

0 vote238 views1 answer
Django-multivaluedictkeyerror-error
Python Django
0 vote275 views1 answer
Write a Python program to accept two strings as input and check if they are identical copy of each other or if the second string is a substring of the first string.
Python
3 votes200 views2 answers
Python set cwd to script directory
Python
0 vote208 views1 answer
Create a distance matrix from a coordinate matrix in python
Python
7 votes226 views1 answer
Python primality test
Python
21 votes189 views5 answers
Base64 encode python
Python
1 vote196 views1 answer
UnicodeEncodeError: 'latin-1' codec can't encode character '\u2013' in position 83: ordinal not in range(256)
Python
0 vote206 views1 answer
Use nltk to remove stop words
Python
0 vote237 views1 answer
Python compactar arquivo antes de exportar
Python
1 vote202 views2 answers
Python listen to keyboard input linux
Python