JSFiddle - React, Tailwind, and code Playground

by pierian_design

JavaScript

var info = 	{
	"aFirstColumns":[7,10],
  "aFirstRows":[10,9],
  "aLastColumns":[7,10],
  "aLastRows":[12,13],
  "aRows":[
  	{"indexRow":10,"startColumn":7,"endColumn":7,"includeRange":"G10:G12","offsetRow":1,"offsetColumn":0},
    {"indexRow":11,"startColumn":7,"endColumn":7,"includeRange":"G10:G12","offsetRow":2,"offsetColumn":0},
    {"indexRow":12,"startColumn":7,"endColumn":7,"includeRange":"G10:G12","offsetRow":3,"offsetColumn":0},
    {"indexRow":9,"startColumn":10,"endColumn":10,"includeRange":"J9:J13","offsetRow":0,"offsetColumn":3},
    {"indexRow":10,"startColumn":10,"endColumn":10,"includeRange":"J9:J13","offsetRow":1,"offsetColumn":3},
    {"indexRow":11,"startColumn":10,"endColumn":10,"includeRange":"J9:J13","offsetRow":2,"offsetColumn":3},
    {"indexRow":12,"startColumn":10,"endColumn":10,"includeRange":"J9:J13","offsetRow":3,"offsetColumn":3},
    {"indexRow":13,"startColumn":10,"endColumn":10,"includeRange":"J9:J13","offsetRow":4,"offsetColumn":3}
  ],
  "aColumns":[
  	{"indexColumn":7,"startRow":10,"endRow":12,"includeRange":"G10:G12","offsetColumn":0,"offsetRow":1},
    {"indexColumn":10,"startRow":9,"endRow":13,"includeRange":"J9:J13","offsetColumn":3,"offsetRow":0}
  ],
  "aRanges":[
  	{"a1Notation":"G10:G12","firstRowOfRange":10,"firstColumnOfRange":7,"aValues":[[8],[9],[10]]},
    {"a1Notation":"J9:J13","firstRowOfRange":9,"firstColumnOfRange":10,"aValues":[[25],[26],[27],[28],[29]]}
  ],
  "aResultRanges":[]
}

var aDataValues = [
	[null,  null,  null,  25],
  [  8,   null,  null,  26],
  [  9,   null,  null,  27],
  [ 10,   null,  null,  28],
  [null,  null,  null,  29]
]