python之讀取Excel 檔案

標籤：ble   style   基本   override   mod   rbo   log   data   api   

 1 # -*- coding: utf-8 -*- 2 """ 3 Created on Thu May 24 13:53:10 2018 4  5 @author: Frank 6 """ 7  8 import xlrd　　#xlrd is a library for reading data and formatting information from Excel files, whether they are .xls or .xlsx files. 9 10 data = xlrd.open_workbook(‘通訊錄.xlsx‘)#開啟 Excel檔案11 print(type(data))12 table = data.sheets()[0]13 print(type(table))14 nrows = table.nrows #行數15 print("行數:{}".format(nrows))16 ncols = table.ncols #列數17 print("列數:{}".format(ncols))18 for i in range(0,nrows):19     rowValues = table.row_values(i) #某一行資料 20     #print(type(rowValues))21     #print(rowValues)22     print("姓名:{}<-->電話:{}".format(rowValues[0], rowValues[1]))

 

xlrd.open_workbook(filename=None, logfile=<_io.TextIOWrapper name=‘<stdout>‘ mode=‘w‘ encoding=‘UTF-8‘>, verbosity=0, use_mmap=1, file_contents=None, encoding_override=None, formatting_info=False, on_demand=False, ragged_rows=False)

開啟一個Excel檔案。

這裡先簡單的介紹基本的參數，以後有用到再添加。

Parameters:

　　filename – The path to the spreadsheet file to be opened.

　　　　指定要開啟檔案的路徑

　　logfile – An open file to which messages and diagnostics are written　　

Returns:

　　An instance of the Book class.

 

book.sheets()

Return:　　A list of all sheets in the book. 返回Excel中所有的表，並儲存在list中。

　　All sheets not already loaded will be loaded.

 

classxlrd.sheet.Sheet(book, position, name, number)

 

Contains the data for one worksheet.

In the cell access functions, rowx is a row index, counting from zero, and colx is a column index, counting from zero. Negative values for row/column indexes and slice positions are supported in the expected fashion.

Note: You don’t instantiate this class yourself. You access Sheet objects via the Book object that was returned when you called xlrd.open_workbook().

nrows= 0

　　Number of rows in sheet. A row index is in range(thesheet.nrows).

ncols= 0

　　Nominal number of columns in sheet. It is one more than the maximum column index found, ignoring trailing empty cells. See also the ragged_rows parameter to open_workbook() and row_len().

row_values(rowx, start_colx=0, end_colx=None)

　　Returns a slice of the values of the cells in the given row.該函數返回一個list，預設包含這一行的cells的所有內容。

python之讀取Excel 檔案