اولین “گام کودک” من در خودکارسازی وظایف در پایتون برای پروژه دستیار واتسون من

import os
import jpype

path = "/mypath"
fname = []
excelCounter = 0
arrayExtension = ['.xlsx','.xls','.xlsm']

jpype.startJVM()

def convert2json(arg1, arg2):
    from asposecells.api import Workbook
    arg1 = path + "https://dev.to/" + arg1
    workbook = Workbook(arg1+arg2)
    jsonfile = arg1 + '.json'
    workbook.save (jsonfile)
    print("JSON file created = %s" % jsonfile)



for root, d_names, f_names in os.walk(path):
    for f in f_names:
       fname.append(os.path.join(root, f))
       split_tup = os.path.splitext(f)
       file_name = split_tup[0]
       file_extension = split_tup[1]
       if file_extension in arrayExtension:
          excelCounter = excelCounter + 1
          print("File to be converted = %s" % f)
          print("excelCounter = %s" % excelCounter)
          convert2json(file_name, file_extension)

jpype.shutdownJVM()

/mypath/Dev/PycharmProjects/exportExcel2JSON/xxxprj/bin/python /mypath/PycharmProjects/exportExcel2JSON/main.py 

File to be converted = Current-Intent-Entity-Training3.xls
excelCounter = 1
JSON file created = /maypath/Current-Intent-Entity-Training3.json
File to be converted = Current-Intent-Entity-Training.xlsx
excelCounter = 2
JSON file created = /maypath/Current-Intent-Entity-Training.json
File to be converted = Current-Intent-Entity-Training2.xlsx
excelCounter = 3
JSON file created = /maypath/Current-Intent-Entity-Training2.json

Process finished with exit code 0