Converting cells in excel to JSON format

Thread Rating:

Thread Modes

Converting cells in excel to JSON format

snippsat

Administrators

Posts: 7,315

Threads: 123

Joined: Sep 2016

Reputation: 506

May-19-2022, 11:03 AM

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.

Find

Messages In This Thread

RE: Converting cells in excel to JSON format - by snippsat - May-19-2022, 11:03 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Convert Json to table format	python_student	4	14,493	Dec-05-2024, 04:32 PM Last Post: Larz60+
	format json outputs !	evilcode1	3	2,628	Oct-29-2023, 01:30 PM Last Post: omemoe277
	Converting a json file to a dataframe with rows and columns	eyavuz21	13	13,754	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,794	Dec-12-2022, 08:22 PM Last Post: jh67
	How to format Excel column with comma?	dee	0	1,985	Jun-13-2022, 10:11 PM Last Post: dee
	json format	Bubu93200	6	3,807	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	15,841	Mar-30-2022, 11:05 PM Last Post: Pedroski55
	Need Help writing data into Excel format	ajitnayak87	8	3,978	Feb-04-2022, 03:00 AM Last Post: Jeff_t
	Exporting dataframes to excel without loosing datetime format	Rafa	0	1,684	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,550	Jul-12-2021, 11:09 AM Last Post: jefsummers

Users browsing this thread: 1 Guest(s)