import xlrd

import xlrd

'''

读取Excel每个sheet的第一列和第二列的值,拼接成json串,写入文件

'''

def resolveExcel():

    # 获取excel文件

    data = xlrd.open_workbook("/you/excel/location/?.xlsx",encoding_override='utf-8')

    #获取一个excel有多少个sheet

    sheetNames = list(data.sheet_names())

    print(sheetNames)

    #写入目标文件位置

    with open('/aim/file/location/?.txt', "r+") as f:

        read_data = f.read()

        f.seek(0)

        f.truncate()   #清空文件

   #遍历sheet

    for name in sheetNames:

        # 获取sheet

        sheet = data.sheet_by_name(name)

        # 获取总行数

        nrows = sheet.nrows

        print(nrows)

        # 获取总列数

        ncols = sheet.ncols

        print(ncols)

        # 获取一行的数值

        #table.row_values(i)

        # 获取第一、二列的数值

        ncol0 = sheet.col_values(0)

        ncol1 = sheet.col_values(1)

        #获取具体单元格的值

        # cell_value = table.cell(0,1).value

        # print(cell_value)

        #获取一个单元格的数值

        count = 1

        chineseStr = ""

        while count <= nrows - 1:

            chineseString = "\""+ncol0[count]+"\" = " + "\""+ncol1[count] +"\""+ ";\n"

            chineseStr = chineseStr + chineseString

            count = count + 1

        chinestfile = open('/aim/file/location/?.txt', 'a+', encoding='utf-8')

        chinestfile.write(chineseStr)

if __name__ == '__main__':

    resolveExcel()