Python---file read

1. Required libraries

XLRD: File Read

Xlwt:xls Excel Table

Excel tables in OPENPYXL:XLSX format

2 functions to be used, objects

Workbooks:excel File Object

1. New Workbook ()

2. Open

Load_workbook ("File path + name. xlsx")

Sheets:sheet Page Object

1. New

Wb.active return Sheet Object
Title () Set sheet name

2 Open

workbooks instance [Name of work sheet page]

Cells: Cell Object

1.cell[' position '].value = Value_zhi

Three-step operation Excel:

1.open (new) Excel file-----> Locate Sheet-----> Manipulate cells---->save

Preference

[1]https://openpyxl.readthedocs.io/en/default/

Python---file read