Converting cells in excel to JSON format

Thread Rating:

Thread Modes

Converting cells in excel to JSON format

desmondtay
Unladen Swallow

Posts: 3

Threads: 1

Joined: May 2022

Reputation: 0

May-23-2022, 07:29 AM

Hi all,

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

Attached Files

dataframe.xlsx (Size: 10.1 KB / Downloads: 184)

Find

Messages In This Thread

RE: Converting cells in excel to JSON format - by desmondtay - May-23-2022, 07:29 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Convert Json to table format	python_student	4	14,633	Dec-05-2024, 04:32 PM Last Post: Larz60+
	format json outputs !	evilcode1	3	2,652	Oct-29-2023, 01:30 PM Last Post: omemoe277
	Converting a json file to a dataframe with rows and columns	eyavuz21	13	14,019	Jan-29-2023, 03:59 PM Last Post: eyavuz21
	How to properly format rows and columns in excel data from parsed .txt blocks	jh67	7	3,844	Dec-12-2022, 08:22 PM Last Post: jh67
	How to format Excel column with comma?	dee	0	1,998	Jun-13-2022, 10:11 PM Last Post: dee
	json format	Bubu93200	6	3,876	Apr-23-2022, 08:59 AM Last Post: Bubu93200
	Openpyxl-change value of cells in column based on value that currently occupies cells	phillipaj1391	5	16,044	Mar-30-2022, 11:05 PM Last Post: Pedroski55
	Need Help writing data into Excel format	ajitnayak87	8	4,059	Feb-04-2022, 03:00 AM Last Post: Jeff_t
	Exporting dataframes to excel without loosing datetime format	Rafa	0	1,695	Oct-27-2021, 10:42 AM Last Post: Rafa
	Python “Formula” Package: How do I parse Excel formula with a range of cells?	JaneTan	1	3,568	Jul-12-2021, 11:09 AM Last Post: jefsummers

Users browsing this thread: 1 Guest(s)