read and write to excel in python (xlrd and openpyxl)

How to automate your work and read and write to excel files using python language. using xlrd and openpyxl libraries. (with English captions)
#python #openpyxl #xlrd #jupyeter #notebook
-------------------------------------------------------------------------------
The code :

import xlrd
from openpyxl import load_workbook
print (var1)
Sheet1 = wb2 [sheets[1]]

[graceangeline]

i update data in my existing excel sheet but but existing data deleted and new data only there... so what can i do?

[arpittrivedi]

Few system it will not work with xlsx then try to use xls. and save excel file in excel '97-2003 workbook' at a time of saving file.

[harshitmodi]

Can you please also make a video on how we can update the already existing excel sheet rather than creating a new one?