Python action on Excel

Learn: Original link: 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.

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] #通过索引顺序GetTable = Data.sheet_by_index (0) #通过索引顺序Get

Table = data.sheet_by_name (U ' Sheet1 ') #通过名称获取 get the values (arrays) for the entire row and the entire columnTable.row_values (i) table.col_values (i) get the number of rows and columnsnrows = table.nrows Ncols = Table.ncols cyclic row and column table dataFor I in Range (nrows): Print table.row_values (i) Cell CellCELL_A1 = Table.cell (0,0). Value cell_c4 = Table.cell (2,3). Value using row and column indexesCELL_A1 = Table.row (0) [0].value cell_a2 = Table.col (1) [0].value a simple writerow = 0 col = 0 # type 0 empty,1 string, 2 number, 3 date, 4 Boolean, 5 Errorctype = 1value = ' cell values 'XF = 0# Extended FormattingTable.put_cell (Row, col, CType, value, XF) Table.cell (0,0) #单元格的值 ' Table.cell (0,0). Value #单元格的值 '

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 action on Excel