python-excel,logging

再总计下python-logging模块

#-*-coding:utf-8-*-
import logging
import logging.handlers
import time

try:
    logger1 = logging.getLogger()#实例
    logger2 = logging.getLogger()
    logger1.setLevel(logging.DEBUG)#定义BUG级别
    format = logging.Formatter('%(asctime)s-%(name)s-%(message)s',datefmt=time.strftime('%Y%m%d'))#格式
    fh=logging.FileHandler('D:\\doc\\hello.log')#文件句柄
    fh.setLevel(logging.DEBUG)
    fh.setFormatter(format)
    logger1.addHandler(fh)#添加文件句柄
    logger1.debug('hello')
    ch=logging.FileHandler('D:\\doc\\he.log')
    ch.setLevel(logging.INFO)
    ch.setFormatter(format)
    logger2.addHandler(ch)
    logger2.info('hello11')
except Exception ,e:
        print e

另外一个python操作excel:

简单的说,就是

读取一张表格->读取具体的一张表单->读取行列数据

#-*-coding:UTF-8-*-
import xlrd
from urllib2 import urlopen

excel=xlrd.open_workbook('d:\\doc\\quanshang.xls')//读取一个excel
sheet=excel.sheet_by_index(0)//读取某一张表单
url_columu=sheet.col_values(3)//读取某一列,返回一个list
md5_columu=sheet.col_values(4)
i=j=0
for num in range(1,len(url_columu)):
    text=urlopen(url_columu[num].encode("utf-8")).read()
    if text.find(md5_columu[num].encode("utf-8"))!= -1:
        print 'find'
        i=i+1
    else:
        print 'sorry',num+1
        j=j+1
print i

获取每一行的信息

#打印每行的信息 
for rownum in range(sheet.nrows):
#每一行的信息 
print  sheet.row_values(rownum) #列表

最后根据索引来确定:

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

X是row,Y是col

posted @ 2012-05-02 19:35  RINA  阅读(334)  评论(0编辑  收藏  举报