读Excel并写入json文件

#!/usr/bin/python

# -*- coding: utf-8

import xlrd

import json

def read_excel():

    table = xlrd.open_workbook("./querynote.xlsx")

    sheet = table.sheet_by_name("querynote")

    b = {}

    for rowNum in range(sheet.nrows):

        for colNum in range(sheet.ncols):

            cell = sheet.cell(rowNum, colNum)

                if colNum ==1:

                    discription = cell.value

                elif colNum ==2:

                    value = cell.value

       b["{}".format(discription)] = value

#把字典写入json文件

    file ="a.json"

    with open(file,"w")as f:

        d = json.dumps(b,ensure_ascii=False)

        f.write(d)

#打印第一列的所有值

    for rowNumin range(sheet.nrows):

            colNum =1

            cell = sheet.cell(rowNum,colNum)

            value = cell.value

            print(value)

if __name__ =="__main__":

m = read_excel()