I have a sidepane app in MS Excel and I'm trying to use GetDataAsync to read a table binding. I need to get the first row, which is a row of headers. In the documentation:
http://msdn.microsoft.com/en-us/library/office/fp161073%28v=office.1501401%29.aspx
It says that I need to specify a coercionType: 'matrix' to read the first row. But when I do that I get an error saying that that coercion type isn't compatible with my binding.
When I use coercionType: 'table', the data in the retrieved array starts with row 2, or the first row of content. How can I read the table headers?