How to read from excel and write in json file using python?

Question

I am trying to create a json file which reads data from test.xlsx. My sample code is below.

Instead of "WO-12345" and other values, I want that to be read from the excel sheet, like I want it to be read from a particular cell in excel.

import xlrd
from collections import OrderedDict
import simplejson as json
import json

jsonfile = open('data1.json', 'w')
data_list = []
data = OrderedDict()

data['workOrder'] = "WO-12345"
data['alternateStart'] = "2018-01-13T10:00:00Z"
data['mobileNumber'] = "(555) 555-5555"
data['officeNumber'] = "(555) 555-5554"
data['description'] = "Testing"
data['equipment'] = "Testing"

data_list.append(data)

j = json.dumps(data_list)


json.dump(data, jsonfile, indent=3, sort_keys=False)
jsonfile.write('\n')

Possible duplicate of Read Excel File in Python

Born Tbe Wasted
– Born Tbe Wasted

2019-04-01 08:20:24 +00:00
Commented Apr 1, 2019 at 8:20 — Born Tbe Wasted
– Born Tbe Wasted, Commented Apr 1, 2019 at 8:20

Giacomo Sachs · Accepted Answer · 2019-04-01 08:15:04Z

3

If you want to read an Excel there's pandas pandas.read_excel, it returns a pandas.DataFrame that has the to_json method.

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.html

answered Apr 1, 2019 at 8:15

Giacomo Sachs

2411 gold badge2 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to read from excel and write in json file using python?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related