本期主題：
python使用xlrd讀取excel的腳本

---

往期鏈接：

• python實用腳本（一）—— 批量修改目標文件夾下的文件名

---

# extract number of rows using Python import xlrd# Give the location of the file loc = "sample.xls" wb = xlrd.open_workbook(loc)# return self._sheet_list[sheetx] # 選擇excel表中的哪一個sheet sheet = wb.sheet_by_index(0)# cell_value選擇具體哪個元素,前為行，后為列 (row ,col) print(sheet.cell_value(0, 0)) # Extracting number of rows print(sheet.nrows)# extract number of columns in Python print(sheet.ncols)# extracting all columns name in Python for i in range(sheet.ncols):print(sheet.cell_value(0, i))# extracting first column sheet = wb.sheet_by_index(0) for i in range(sheet.nrows):print(sheet.cell_value(i, 0))# extract a particular row value sheet = wb.sheet_by_index(0) print(sheet.row_values(1))

增加一個新版本，可以讀取合并單元格里的值

# extract number of rows using Python import xlrddef str_compare(sheet):"""匹配對應字符"""result = 0for i in range(sheet.ncols):str1 = sheet.cell_value(0, i)if str1 == "B":print(i)result = ibreakprint("find B result is ", result)def get_basic_info(sheet):print("行數為： ", sheet.nrows)print("列數為： ", sheet.ncols)print("第一行的值為: ", sheet.row_values(0))print("第二行的值為: ", sheet.row_values(1))# mc = sheet.merged_cells# print("mc is ", mc)def get_cells_value(sheet, row, col):"""獲取excel中的cell元素值，如果是merged_cells，就返回Merged_cells的值,否則直接返回對應元素值"""merged_cells = sheet.merged_cells# judge if in mergedfor merged in merged_cells:if (merged[0] <= row < merged[1]and merged[2] <= col < merged[3]):print("This is a merged cell, val is ", sheet.cell_value(merged[0], merged[2]))return sheet.cell_value(merged[0], merged[2])print("unmerged cell, val is ", sheet.cell_value(row, col))return sheet.cell_value(row, col)def main():loc = "sample.xls"wb = xlrd.open_workbook(loc, formatting_info=True) # formatting_info代表著是否需要管理合并的單元格# 選擇excel表中的哪一個sheetsheet = wb.sheet_by_index(0)# 獲取基本信息get_basic_info(sheet)# 將合并的單元格數據整理for i in range(sheet.nrows):for j in range(sheet.ncols):print("i, j, val", i, j, get_cells_value(sheet, i, j))# 匹配對應字符# str_compare(sheet)if __name__ == "__main__":main()

總結

以上是生活随笔為你收集整理的python实用脚本（二）—— 使用xlrd读取excel的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。