public JsonResult GetTableData(string tableID, string sheetName)
{
GoogleSheets table = new GoogleSheets();
GoogleDrive drive = new GoogleDrive();
string startCell = "";
string finishCell = "";
string name = "";
if (sheetName == "nullTable")
{
name = table.GetTableSheets(tableID)[0];
}
else
{
name = sheetName;
}
var res = new {
values = table.GetTable(tableID, name, startCell, finishCell),
sheets = table.GetTableSheets(tableID),
editable = drive.Editable(tableID)
};
return(Json(res, JsonRequestBehavior.AllowGet));
}