pip install xlrd

import xlrd

# 給出excel文件絕對路徑
loc = ("path of file") 
# 打開工作表
wb = xlrd.open_workbook(loc)   
# 這里讀取的是第一個sheet   
sheet = wb.sheet_by_index(0)

>>> print(sheet.cell_value(0, 0) )
'NAME'

>>> print(sheet.nrows) # 行數   
4  
>>> print(sheet.ncols) # 列數   
3　

>>> for i in range(sheet.ncols):          
        print(sheet.cell_value(0, i))  
NAME   
SEMESTER   
ROLL NO

>>> for i in range(sheet.nrows):  
        print(sheet.cell_value(i, 0))  
NAME   
ALEX   
CLAY   
JUSTIN

>>> print(sheet.row_values(1))    
['ALEX', 4.0, 2011272.0]

pip install xlwt

import xlwt    
from xlwt import Workbook

# 創建workbook   
wb = Workbook()    
# 使用add_sheet函數創建新的sheet   
sheet1 = wb.add_sheet('Sheet 1')   
# 寫入數據，參數分別為行、列、數據 
sheet1.write(1, 0, 'ISBT DEHRADUN')    
sheet1.write(2, 0, 'SHASTRADHARA') 
sheet1.write(3, 0, 'CLEMEN TOWN')  
sheet1.write(4, 0, 'RAJPUR ROAD')  
sheet1.write(5, 0, 'CLOCK TOWER')  
sheet1.write(0, 1, 'ISBT DEHRADUN')    
sheet1.write(0, 2, 'SHASTRADHARA') 
sheet1.write(0, 3, 'CLEMEN TOWN')  
sheet1.write(0, 4, 'RAJPUR ROAD')  
sheet1.write(0, 5, 'CLOCK TOWER')  
# 保存到excel表格   
wb.save('xlwt example.xls')

# 先導入xlrt庫
import xlwt
# 創建workbook
workbook = xlwt.Workbook()
# 創建sheet
sheet = workbook.add_sheet("Sheet Name")
# 給單元格內容添加格式：加粗、標紅
style = xlwt.easyxf('pattern: pattern solid, fore_colour red;')
# 在單元格中寫入數據
sheet.write(0, 0, 'SAMPLE', style)
# 保存excel
workbook.save("sample.xls")