Header row data not included in with cell row data

[stulees]

Since only a list based feed is used to obtain the sheet data, there is no header row data returned in the google-sheet-data event and thus no way of obtaining the content of the header row cells.

When working with the data returned and want to display it in HTML, the header row cells are essential for displaying column titles, particularly in the case of displaying the data as a table.

Is this a limitation of this web component? Are there plans to include this header row data? Is there an alternative or workaround? Thanks

[ebidel]

Is there a way to get that in the Spreadsheets API? I haven't looked.

[stulees]

There is another style of feed you can retrieve which is a cell based feed and when using it, each entry represents a single cell. Cells are referred to by position.

https://developers.google.com/google-apps/spreadsheets/#working_with_cell-based_feeds

The list based feed does work nicely in the context of this web component since the rows are defined as entries and makes it easy to bind as a model. However cell feed is a way to obtain that header row data and was wondering if it was possibly considered to add in somehow to this component so that data is available.

[oneezy]

@ebidel @stulees , have you guys explored this further? I'm trying to do the same thing and/or looking for workarounds.

---

I've asked a question on SO that addresses it:
http://stackoverflow.com/questions/39944753/load-multiple-tabs-data-in-website-using-polymers-google-sheets-custom-elemen

[stulees]

@oneezy Our company ended up building our own web component to address this because using cell based feeds is necessary for us as well as we required other aspects too.

[oneezy]

@stulees , Nice! would it happen to be opensource?