python2.7读取excel,Python读取Excel⽂件1.读取Excel(需要安装xlrd)：
#-*- coding: utf8 -*-
import xlrd
fname = "reflect.xls"
bk = xlrd.open_workbook(fname)
shxrange = range(bk.nsheets)
try:
sh = bk.sheet_by_name("Sheet1")
except:
print "no sheet in %s named Sheet1" % fname
#获取⾏数
nrows = sh.nrows
#获取列数
ncols = sh.ncols
print "nrows %d, ncols %d" % (nrows,ncols)
#获取第⼀⾏第⼀列数据
cell_value = sh.cell_value(1,1)
#print cell_value
row_list = []
#获取各⾏数据
for i in range(1,nrows):
row_data = sh.row_values(i)
row_list.append(row_data)
2.写⼊Excel(需安装pyExcelerator)
from pyExcelerator import *
w = Workbook()    #创建⼀个⼯作簿
ws = w.add_sheet('Hey, Hades')    #创建⼀个⼯作表
ws.write(0,0,'bit')    #在1⾏1列写⼊bit
ws.write(0,1,'huang')  #在1⾏2列写⼊huang
ws.write(1,0,'xuan')  #在2⾏1列写⼊xuan
w.save('mini.xls')    #保存
3.再举个⾃⼰写的读写Excel的例⼦
python怎么读入excel
读取reflect.xls中的某些信息进⾏处理后写⼊mini.xls⽂件中。
#-*- coding: utf8 -*-
import xlrd
from pyExcelerator import *
w = Workbook()
ws = w.add_sheet('Sheet1')
fname = "reflect.xls"
bk = xlrd.open_workbook(fname)
shxrange = range(bk.nsheets)
try:
sh = bk.sheet_by_name("Sheet1")
except:
print "no sheet in %s named Sheet1" % fname nrows = sh.nrows
ncols = sh.ncols
print "nrows %d, ncols %d" % (nrows,ncols) cell_value = sh.cell_value(1,1)
#print cell_value
row_list = []
mydata = []
for i in range(1,nrows):
row_data = sh.row_values(i)
pkgdatas = row_data[3].split(',')
#pkgdatas.split(',')
#获取每个包的前两个字段
for pkgdata in pkgdatas:
pkgdata = '.'.join((pkgdata.split('.'))[:2]) mydata.append(pkgdata)
#将列表排序
mydata = list(set(mydata))
print mydata
#将列表转化为字符串
mydata = ','.join(mydata)
#写⼊数据到每⾏的第⼀列
ws.write(i,0,mydata)
mydata = []
row_list.append(row_data[3])
#print row_list
w.save('mini.xls')
4.现在我需要根据Excel⽂件中满⾜特定要求的apk的md5值来从服务器获取相应的apk样本，就需要这样做：#-*-coding:utf8-*-
import xlrd
import os
import shutil
fname = "./excelname.xls"
bk = xlrd.open_workbook(fname)
shxrange = range(bk.nsheets)
try:
#打开Sheet1⼯作表
sh = bk.sheet_by_name("Sheet1")
except:
print "no sheet in %s named Sheet1" % fname
#获取⾏数
nrows = sh.nrows
#获取列数
ncols = sh.ncols
#print "nrows %d, ncols %d" % (nrows,ncols)
#获取第⼀⾏第⼀列数据
cell_value = sh.cell_value(1,1)
#print cell_value
row_list = []
#range(起始⾏，结束⾏)
for i in range(1,nrows):
row_data = sh.row_values(i)
if row_data[6] == "HXB":
filename = row_data[3]+".apk"
#print "%s  %s  %s" %(i,row_data[3],filename)
filepath = r"./1/"+filename
print "%s  %s  %s" %(i,row_data[3],filepath)
if ists(filepath): py(filepath, r"./myapk/")

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。