excel_to_json-for-Elasticsearch/kibana
Excel File to JSON conversion for Elasticsearch In Python
create ={ "create" : { "_index" : fileName[0], "_type" :vartype[:-1] , "_id" : counter } }
----for each row in the excel
how to Run : in the same directory open cmd with the administator privilage python 3 need be install
after that run
python py_script.py input_excel_file.xlsx Sheet_name convert_json_file_name.json
this screenshort my help you
new date and time convert to as it is to strings in excel file
look at the codes
