import xlrd

# data = xlrd.open_workbook('个人代理渠道.xlsx')
data = xlrd.open_workbook('DEA-ANN数据.xlsx')
# table1 = data.sheet_by_name('Sheet1')
table2 = data.sheet_by_name('01编码整理')

def getT1StartSub(x): # T1各公司起始列号
    return (x-1)*11

def getT2StartSub(x): # T2各公司起始列号
    return (x-1)*3

comNum=0
year=1
d1=2 # d1-d8

def getCellT1(x,y):
    return table1.cell(x, y).value

def getCellT2(x,y):
    return table2.cell(x, y).value

def writeFile(filePath, content):
    print('Write info to file:Start...')
    # 将文件内容写到文件中
    with open(filePath, 'a', encoding='utf-8') as f:
        f.write(content)
        print('Write info to file:end...')

def readFile(filepath):
    f=open(filepath,'r')
    return f.read()