python学习之一 文件读取
文件逐行读取
import os
with open("***", "r") as f:
for line in f.readlines():
list = line.split(",")
print(list)
Excel表格操作
import os
import xlrd
import xlwt
import re
import time
from xlrd import open_workbook
from xlutils.copy import copy
fileUrl='E:/qingdan/2017-09-08.xls'
data = xlrd.open_workbook(fileUrl)
table = data.sheets()[0]
nrows = table.nrows
rb = open_workbook(fileUrl, formatting_info=True)
rs = rb.sheet_by_index(0)
wb = copy(rb)
ws = wb.get_sheet(0)
stimes=0
for n in range(nrows):
prices=table.row_values(n)[17]
if n==0:
stimes=time.time()
print stimes
elif len(prices.split(u"减"))==2:
pr=prices.split(u"减")[1].split(u"元")[0]
ws.write(n, 17,pr)
elif len(prices.split(u"条"))==2:
pr=prices.split(u"元")[0]
ws.write(n, 17, pr)
wb.save(fileUrl)
print time.time()-stimes