XLSTOJson.py

import xlrd
import json as json
import re
import glob
import os
import sys
reload(sys)
sys.setdefaultencoding('UTF8')

source = glob.glob("D:\\*.xlsx") #insert target folder

class x2json(object):

    def __init__(self,object):
        self.book = xlrd.open_workbook(object)
        self.name = object.lstrip('D:\\').rstrip('-export.xlsx')

        BookName = self.name+'.json'
        MyBook=[]
        for i in range(self.book.nsheets):
            SheetName = self.book.sheets()[i].name
            MySheet=[]
            for j in range(self.book.sheet_by_index(i).nrows):
                RowName = self.book.sheet_by_index(i).row_values(0)
                RowData = self.book.sheet_by_index(i).row_values(j)
                MyRow=[]
                for k in range(len(self.book.sheet_by_index(i).row_values(j))):
                    try:
                        MyRow.append({RowName[k].encode('utf-8'):RowData[k].encode('utf-8')})
                    except AttributeError:
                        MyRow.append({RowName[k].encode('utf-8'):RowData[k]})
                MySheet.append({SheetName:MyRow})
            MyBook.append({BookName:MySheet})
        f=open(BookName,'w')
        MyDumps = json.dumps(MyBook,separators=(',',':'))
        f.write(MyDumps)
        f.close()
f=open('matchdata.json','w')
for i in source:
    x2 = x2json(i)