PDA

View Full Version : GridPanel paging and Google Spreadsheet based store



friism
19 Feb 2010, 8:40 AM
I'm trying to create a paging gridpanel backed by a store that gets paged data from a Google Spreadsheet. I'm using Google Visualization API/DataTable to grab data from the spreadsheet since that best lets me control columns, offset and pagesize.

I can do an initial store/gridpanel just fine using an ArrayStore filled with data from the google DataTable. What I can't figure out is, how to hook up to the "get next page" event and fill the store with a new batch of data queried from the spreadsheet. Which store should I use, and what events to hook up to? Note that I can't really expose a json-url via the spreadsheet (not paged anyway), so I need to handle querying the data and filling the store in Javascript.

Regards
Michael