#电量表读取
from collections import OrderedDict
from pyexcel_xls import get_data
from pyexcel_xls import save_data
import random
x = 3
y = 8
yEnd = 58
sheet = []
row_top_data = [u"A路电量", u"B路电量", u"A路电量", u"B路电量"]
sheet.append(row_top_data)
def read_xls_file():
xls_data = get_data(r"C:\Users\Administrator\Desktop\test\番禺机房红手指客户机柜电量.xls")
#print("Get data type:", type(xls_data))
for sheet_n in xls_data.keys():
row = xls_data[sheet_n]
print(sheet_n, ":\n")#, row)
if(sheet_n == "当日电量抄表"):
for i in range(y - 1, len(row) - 1):
if(i == yEnd + 1):
return
col = row[i]
A0 = col[x - 1]
B0 = col[x - 1 + 1]
A1 = col[x - 1 + 7]
B1 = col[x - 1 + 8]
print("[", i, "]: ", A0, B0, A1, B1, "\n")
if(type(A0) == type(" ")):
A0 = 0
else:
A0 = (A0 * 10 + random.randint(-3,3))/10
if(type(B0) == type(" ")):
B0 = 0
else:
B0 = (B0 * 10 + random.randint(-3,3))/10
if(type(A1) == type(" ")):
A1 = 0
else:
A1 = (A1 * 10 + random.randint(-3,3))/10
if(type(B1) == type(" ")):
B1 = 0
else:
B1 = (B1 * 10 + random.randint(-3,3))/10
sheet.append([A0, B0, A1, B1])
# 写Excel数据, xls格式
def save_xls_file():
data = OrderedDict()
# sheet表的数据
row_top_data = [u"A路电量", u"B路电量", u"A路电量", u"B路电量"] # 每一行的数据
# 添加sheet表
data.update({u"这是XX表": sheet})
# 保存成xls文件
save_data(r"C:\Users\Administrator\Desktop\test\test.xls", data)
if __name__ == '__main__':
read_xls_file()
save_xls_file()
源
目标