Converting cells in excel to JSON format

[desmondtay]

Hi,

I am new to Python, need some help from the experts. I need to convert certain cells in 2 worksheets in excel to JSON format. How can i do it using Python. Any good advises? Thanks.

[snippsat]

The easiest way is to use Pandas read in read_excel and use to_json.
Give it try(search many example out there),post back if problems.

[desmondtay]

okie, let me give a try.

Is there any difference when converting to JSON Vs NDJSON format?

[desmondtay]

Hi all,

attached is the dataframe that i had managed to read out. Any idea how can I write into ndjson file?

[Larz60+]

There are several packages available here: https://pypi.org/search/?q=ndjson
see (for example -- which I have never used): https://stackoverflow.com/a/51301673