Python Operations Excel Table read-write--XLRD module

Reproduced original address: http://www.cnblogs.com/lhj588/archive/2012/01/06/2314181.html

First, install the XLRD module

Download the HTTP://PYPI.PYTHON.ORG/PYPI/XLRD module installation to the Python website, provided the Python environment is already installed.

Install: Unpack the package, Windows command line mode, go to unzip file directory, execute: Python setup.py install

Second, the use of the introduction

1. Import Module

Import xlrd

2. Open Excel file to read data

data = Xlrd.open_workbook ('excelfile.xls')

3, the use of skills

Get a worksheet

        Table = data.sheets () [0]          #            obtained by index order           # obtained by index order = Data.sheet_by_name (U'Sheet1')# gets by name

get the values (arrays) for the entire row and the entire column

         Table.row_values (i)          table.col_values (i)

get the number of rows and columns　

        nrows = table.nrows         = Table.ncols

cyclic row and column table data

 for inch Range (nrows):    　　 Print table.row_values (i)

Cell Cell

    CELL_A1 = Table.cell (0,0). Value     = Table.cell (2,3). Value

using row and column indexes

    CELL_A1 = table.row (0) [0].value     = table.col (1) [0].value

a simple write

row == 0  #  type 0 empty,1 string, 2 number, 3 date, 4 Boolean, 5 error' unit Lattice values '#  extended format Table.put_cell (Row, col, CType, value, XF) Table.cell (0,0)   # the value of the cell '  # value of cell '

Third, demo code

The demo code is simple enough to read the Excel data.

#-*-coding:utf-8-*-Importxdrlib, sysImportxlrddefOpen_excel (file='File.xls'):    Try: Data=xlrd.open_workbook (file)returnDataexceptexception,e:PrintStr (e)#get data parameters in Excel table According to index: File:excel file path Colnameindex: Table header column name is the row, so by_index: Index of TabledefExcel_table_byindex (file='File.xls', colnameindex=0,by_index=0): Data=open_excel (file) Table=data.sheets () [By_index] nrows= Table.nrows#Number of rowsNcols = Table.ncols#Number of columnsColnames = Table.row_values (Colnameindex)#a row of dataList =[]     forRowNuminchRange (1, nrows): Row=table.row_values (rownum)ifRow:app= {}              forIinchRange (len (colnames)): App[colnames[i]]=Row[i] List.append (APP)returnList#get data parameters in Excel table by name: File:excel file path Colnameindex: The header column name is the row, so the By_name:sheet1 namedefExcel_table_byname (file='File.xls', Colnameindex=0,by_name=u'Sheet1'): Data=open_excel (file) Table=data.sheet_by_name (by_name) nrows= Table.nrows#Number of rowsColnames = Table.row_values (Colnameindex)#a row of dataList =[]     forRowNuminchRange (1, nrows): Row=table.row_values (rownum)ifRow:app= {}              forIinchRange (len (colnames)): App[colnames[i]]=Row[i] List.append (APP)returnListdefMain (): Tables=Excel_table_byindex () forRowinchtables:PrintRow Tables=Excel_table_byname () forRowinchtables:PrintRowif __name__=="__main__": Main ()

Python Operations Excel Table read-write--XLRD module