public void AddCell(Cell cell)
{
CellList.Add(cell);
}
public ActionResult MySpreadsheets()
{
SpreadsheetsService service = new SpreadsheetsService("chavp-mybook-1");
service.setUserCredentials("iuityuj@rtrtey5e6yrty", "sdfdsfsdfsdf");
WorksheetQuery query = new WorksheetQuery("0AsqxIqqTdYVidExTN0R0THh6XzlBa01pOURWVGRSMGc", "private", "full");
WorksheetFeed feed = service.Query(query);
List<Row> listData = new List<Row>();
foreach (WorksheetEntry worksheet in feed.Entries)
{
AtomLink cellFeedLink = worksheet.Links.FindService(GDataSpreadsheetsNameTable.CellRel, AtomLink.ATOM_TYPE);
CellQuery cellQuery = new CellQuery(cellFeedLink.HRef.ToString());
CellFeed cellFeed = service.Query(cellQuery);
foreach (CellEntry curCell in cellFeed.Entries)
{
Cell cell = new Cell { Row = curCell.Cell.Row, Index = curCell.Cell.Column, Data = curCell.Cell.Value };
var row = listData.Find(r => r.Index == curCell.Cell.Row);
if (row == null)
{
row = new Row { Index = curCell.Cell.Row };
listData.Add(row);
}
row.CellList.Add(cell);
}
}
return View();
}
