public static Request GenerateRepeatCellRequest(GCoordinate start, GRowList rows)
{
return(new Request()
{
UpdateCells = new UpdateCellsRequest()
{
Rows = rows.GetRowDataList(),
Fields = rows.GetFields().GetFieldsString(),
Start = start.GetGridCoordinate(),
}
});
}
public static Request GenerateUpdateCellsRequest(GRowList rows, GCoordinate gCoordinate)
{
return(new Request()
{
UpdateCells = new UpdateCellsRequest()
{
Start = gCoordinate.GetGridCoordinate(),
Fields = rows.GetFields().GetFieldsString(),
Rows = rows.GetRowDataList()
//"userEnteredValue.stringValue"
// + ",userEnteredFormat.textFormat.bold",
//Rows = requestBatchUpdate_AddData
}
});
}
public GRowList GetGRowList()
{
var result = new GRowList();
var weekRange = GetFormattedDateRange();
result.AddRange(SubjectGoalList.Select((b, c) =>
new GRow()
{
new GCell().AddValue(c == 0 ? weekRange : ""),
new GCell().AddValue(b.Subject).AddFormat(GCellFormat.TextFormatBold, true),
new GCell().AddValue(b.Goal)
}));
return(result);
}
