Python Forum

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.

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.

okie, let me give a try.

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

Hi all,

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

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