I'm working on displaying a spreadsheet in a datatable visualization. My
original spreadsheet has 2 rows as "header rows." When I use this for my
datasource, I get the top row displayed accurately as the header. Of course
this misses the second row which is intended as a header as well, so in a
spreadsheet copy I "merge" the two into one header row (as in move the
relevant info from the second to the first and delete the second row), but
now the spreadsheet api call has this first row as an actual row and not
the header.
The row is "frozen", it's the first (0) entry in the api response, the
"cols" json is: "cols": [
{
"id": "A",
"label": "",
"type": "string",
"pattern": ""
}, etc., etc. for "B", "C"
Does anyone have any ideas why the spreadsheet api will not recognize the
first row as a header? I know it can.
Pretty desperate, about to make an ugly hack around it. Any ideas will be
extremely appreciated!
Thank you!
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
