I have an excel spreadsheet that fails when I read it directly in python. So I read it in Power Query first, and I read it in python, but I lost the json double quotes when I read it in Power Query.
I tried demjson3, but can’t make it.
I tried reading by line in python,That’s not a good idea.
I expect to be able to present it as a json in python.
Primary file is :
enter image description here
Power Query files after processing:
enter image description here
New contributor
SHENLIN QIAN is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.