python 读写 Excel

#电量表读取
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()

源

目标