1.安裝
pip install xlrd
pip install xlwt
2.xlrd讀excel
import xlrd
path=""
book=xlrd.open_workbook(path)
sheet0=book.sheets()[0]#表格索引，從0開始
print(sheet0)
sheet1=book.sheets()[1]
print(sheet1)
rows=sheet1.nrows
cols=sheet1.ncols
print("表格總行數：",rows)
print("表格總列數：",cols)
print("第一行的值:",sheet1.row_values(0))
print("第一列的值:",sheet1.col_values(0))
print("第一行第一列的值為：",sheet1.cell(0,0).value)
excel表格內容為:
運行結果為：
<xlrd.sheet.Sheet object at 0x0000023EEF7C29C8>
<xlrd.sheet.Sheet object at 0x0000023EEF7C2188>
表格總行數： 4
表格總列數： 4
第一行的值: ['0.0', '0.1', '0.2', 0.3]
第一列的值: ['0.0', '1.0', '2.0', '3.0']
第一行第一列的值為： 0.0
3.xlwt寫excel
import xlwt
path2=""
book=xlwt.Workbook()
sheet0=book.add_sheet('testsheet0')
sheet0.write(0,0,"name")
sheet0.write(0,1,'sex')
sheet0.write(0,2,'age')
sheet0.write(1,0,'Tom')
sheet0.write(1,1,'mail')
sheet0.write(1,2,18)
sheet0.write(2,0,'Jain')
sheet0.write(2,1,'famail')
sheet0.write(2,2,22)
book.save(path2)
運行結果為：
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/271986.html
標籤：python