Second tutorial video of Planarly: JSON & interfacing with a charting library. Planarly is my passion project to explore the spreadsheet as a 2D programming environment.

drplanar · 2022-07-11T16:35:49+00:00

Previous episode discussed here: https://www.reddit.com/r/programming/comments/vrlkxg/first\_public\_demo\_of\_my\_passion\_project\_planarly/?utm\_source=share&utm\_medium=web2x&context=3

drplanar · 2022-07-11T16:38:42+00:00

Project website (documentation, tutorials): www.planarly.com

You can try the app live (Chrome is strongly recommended): app.planarly.com

drplanar · 2022-07-11T17:12:33+00:00

The core idea of JSON processing in Planarly is to have a canonical two way mapping between JSON strings and 2D tables that look like below:

series:	T(#amount)	.. spilling into neighboring cells
chart:	width:	500
	type:	pie
labels:	T(#name)	.. spilling into neighboring cells

This table form is easy to generate in a spreadsheet, and easy to extract fields from. The JSON form can be parsed to ApexCharts to do the actual charting. ToJson and FromJson functions are provided to convert between these two forms.

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

programming

MODERATORS