Interface Automation Test Python (2) _ Use Python to manipulate Excel

How to use Python to do simple work with Excel

I. install XLWT via PIP, xlrd these two modules

*pip Install XLWT

*pip Install xlrd

Two. Prepare a copy of the interface test case, Excel document

Three. Python script reads Excel content

#ReadExcelContent
Import xlrd

#GetExcelFile storage Address
data = Xlrd.open_workbook (‘.. \dataconfig\interfacetestcase.xlsx ')
#Get the first1ASheet
tables = Data.sheets () [0]
# print sheet name
print data.sheet_names ()
# Print line number
print tables.nrows
# print 3 line 4 column
print tables.cell_value ( 23)

The results of the operation are as follows:

Interface Automation Test Python (2) _ Use Python to manipulate Excel