Read Excel files from Python[转]

http://scienceoss.com/read-excel-files-from-python/

 

 

Use the excellent xlrd package, which works on any platform. That means you can read Excel files from Python in Linux! Example usage:

Open the workbook

import xlrd

wb = xlrd.open_workbook(myworkbook.xls)

Check the sheet names

wb.sheet_names()

Get the first sheet either by index or by name

sh = wb.sheet_by_index(0)

sh = wb.sheet_by_name(uSheet1)

Iterate through rows, returning each as a list that you can index:

for rownum in range(sh.nrows):

 print sh.row_values(rownum)

If you just want the first column:

first_column = sh.col_values(0)

Index individual cells:

cell_A1 = sh.cell(0,0).value

cell_C4 = sh.cell(rowx=3,colx=2).value

(Note Python indices start at zero but Excel starts at one)

Turns out the put_cell() method isn’t supported, so ignore the following section (Thanks for the heads up, John!)

Put something in the cell:

row = 0

col = 0

ctype = 1 # see below

value = asdf

xf = 0 # extended formatting (use 0 to use default)

sh.put_cell(row, col, ctype, value, xf)

sh.cell(0,0) # text:uasdf

sh.cell(0,0).value # asdf

Possible ctypes: 0 = empty, 1 = string, 2 = number, 3 = date, 4 = boolean, 5 = error

欢迎加群互相学习，共同进步。QQ群：iOS: 58099570 | Android: 330987132 | Go：217696290 | Python：336880185 | 做人要厚道，转载请注明出处！