Python读åEXCELæ件常ç¨æ¹æ³å¤§å
¨
Huny ä¿¡æ¯ç½ç»å·¥ç¨ç 究ä¸å¿ 2020-12-19
1 åè¨
python读åexcelçæ¹å¼æå¾å¤ï¼ä¸åç模åå¨è¯»åç讲æ³ä¸ç¨æåºå«ï¼è¿éæ主è¦ä»ç»å 个常ç¨çæ¹å¼ã
ç¨xlrdåxlwtè¿è¡excel读åï¼
ç¨openpyxlè¿è¡excel读åï¼
ç¨pandasè¿è¡excel读åï¼
åèï¼
https://www.python-excel.org/https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html#pandas.read_excelhttps://www.jianshu.com/p/19219542bf232 æ°æ®åå¤
为äºæ¹ä¾¿æ¼ç¤ºï¼æè¿éæ°å»ºäºä¸ä¸ªdata.xlsådata.xlsxæ件ï¼ç¬¬ä¸ä¸ªå·¥ä½è¡¨sheet1åºåâA1:E5âçå
容å¦ä¸ï¼ç¨äºæµè¯è¯»åexcelç代ç ï¼

3 xlrdåxlwt
xlrdæ¯ä¸ä¸ªåºï¼ç¨äºä»Excelæ件ä¸ä»¥.xlsæ ¼å¼è¯»åæ°æ®åæ ¼å¼åä¿¡æ¯
xlwtæ¯ä¸ä¸ªåºï¼ç¨äºå°æ°æ®åæ ¼å¼åä¿¡æ¯åå
¥è¾æ§çExcelæ件(ä¾å¦:.xls)ã
示ä¾
pip install xlrd
pip install xlwt

æ们å¼å§æ¥è¯»åæ件çå
容
import xlrd
import os
file_path = os.path.dirname(os.path.abspath(__file__))
base_path = os.path.join(file_path, 'data.xlsx')
book = xlrd.open_workbook(base_path)
sheet1 = book.sheets()[0]
nrows = sheet1.nrows
print('è¡¨æ ¼æ»è¡æ°', nrows)
ncols = sheet1.ncols
print('è¡¨æ ¼æ»åæ°', ncols)
row3_values = sheet1.row_values(2)
print('第3è¡å¼', row3_values)
col3_values = sheet1.col_values(2)
print('第3åå¼', col3_values)
cell_3_3