python文件读写总结

0. python 读取excel

__author__ = 'HM'
#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(u'Sheet1')
#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 th