Query google spreadsheet rows
I am using c # google spreadsheets api to work with our spreadsheets.
I have a problem requesting the sheets we have.
Namely, I am having a problem trying to get certain rows based on their name, which is the value in the first cell of the row, we are not currently using headers in our tables as we need a vertical layout and not a horizontal one.
listQuery.SpreadsheetQuery = "Select A";
from reading the api docs, which should be all I need to do, but it throws an error, which is a bad request with a null response message.
AtomLink ListFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.ListRel, null);
ListQuery listQuery = new ListQuery(ListFeedLink.HRef.ToString());
if (!string.IsNullOrEmpty(spreadsheetQuery))
{
listQuery.SpreadsheetQuery = "age=25";
}
ListFeed listFeed = myService.Query(listQuery);
Im using the above code
Does anyone have any hints for querying spreadsheets this way?
source to share
You say, "We don't currently use headers in our tables." When I tested ListFeed it needed headers, it was optional. CellFeed does not require headers and has a search type request, see https://code.google.com/p/gdata-java-client/source/browse/trunk/java/sample/spreadsheet/cell/CellDemo.java
source to share