Python uses xlrd to retrieve a column in excel containing a specified string record-Python tutorial

This article mainly introduces how to use xlrd in python to retrieve a column containing a specified string record in excel. it involves the skills of using xlrd module to retrieve Excel, which is very useful, for more information, see the following example. Share it with you for your reference. The specific analysis is as follows:

Xlrd is used to retrieve records containing the specified string from a column of data in excel and generate a txt file named after this string.

import osimport xlrd,sys# input the excel fileFilename=raw_input('input the file name&path:')if not os.path.isfile(Filename):  raise NameError,"%s is not a valid filename"%Filename#open the excel filebk=xlrd.open_workbook(Filename)#get the sheets numbershxrange=range(bk.nsheets)print shxrange#get the sheets namefor x in shxrange:  p=bk.sheets()[x].name.encode('utf-8')  print "Sheets Number(%s): %s" %(x,p.decode('utf-8'))# input your sheets namesname=int(raw_input('choose the sheet number:'))try:  sh=bk.sheets()[sname]except:  print "no this sheet"  #return Nonenrows=sh.nrowsncols=sh.ncols# return the lines and col numberprint "line:%d col:%d" %(nrows,ncols)#input the check columncolumnnum=int(raw_input('which column you want to check pls input the num(the first colnumn num is 0):'))while columnnum+1>ncols:  columnnum=int(raw_input('your num is out of range,pls input again:'))# input the searching string and columntestin=raw_input('input the string:')#find the cols and save to a txtoutputfilename=testin + '.txt'outputfile=open(outputfilename,'w')#find the rows which you want to select and write to a txt filefor i in range(nrows):  cell_value=sh.cell_value(i, columnnum)  if testin in str(cell_value):    outputs=sh.row_values(i)    for tim in outputs:      outputfile.write('%s  ' %(tim))    outputfile.write('%s' %(os.linesep)) outputfile.close()

I hope this article will help you with Python programming.