Sheet within a cell

[cool-RR]

My program outputs a JSONLA file which I open with VisiData, though I think this question would be relevant for any sheet. I want to have a cell that has an entire VisiData sheet in it, with columns and rows, so when I press zEnter on it, I'll see that sheet.

I tried to do that by putting {'col1': [0, 1, 2], 'col2': [0, 1, 2]} in there, but what I get when pressing zEnter is a sheet with columns key and value instead of col1 and col2.

How can I accomplish this?

[saulpw]

Try =json.loads(internalsheetcol) (you could make a type out of jsonl.loads instead). Then do zCtrl+Y on that cell.

I'm not sure if this will work, out of the box. As always, you'll get better answers if you provide a small example file.

[cool-RR]

Thank you.

[cool-RR]

Had to change it to [{'col1': 0, 'col2': 0}, {'col1': 1, 'col2': 1}, {'col1': 2, 'col2': 2}]. Verbose but works.