private void AddDashboardHeader()
{
var cells = new List <CellData>();
cells.Add(new CellData()
{
UserEnteredValue = new ExtendedValue()
{
StringValue = "Dashboard"
},
UserEnteredFormat = new CellFormat()
{
BackgroundColor = GetSheetsColor(),
TextFormat = new TextFormat()
{
FontSize = 18,
Bold = true,
},
VerticalAlignment = "MIDDLE",
HorizontalAlignment = "CENTER"
}
});
_googleSheetService.AddRow(cells);
cells = new List <CellData>();
cells.Add(new CellData()
{
UserEnteredValue = new ExtendedValue()
{
StringValue = "Subcategory"
},
UserEnteredFormat = new CellFormat()
{
Borders = GoogleSheetService.GetBottomMediumBorder(),
TextFormat = GoogleSheetService.GetDefaultTableHeaderFormatting(),
VerticalAlignment = "BOTTOM",
WrapStrategy = "WRAP",
}
});
cells.Add(new CellData()
{
UserEnteredValue = new ExtendedValue()
{
StringValue = "Planned spending"
},
UserEnteredFormat = new CellFormat()
{
Borders = GoogleSheetService.GetBottomMediumBorder(),
TextFormat = GoogleSheetService.GetDefaultTableHeaderFormatting(),
VerticalAlignment = "BOTTOM",
HorizontalAlignment = "RIGHT",
WrapStrategy = "WRAP",
}
});
cells.Add(new CellData()
{
UserEnteredValue = new ExtendedValue()
{
StringValue = "Actual spending"
},
UserEnteredFormat = new CellFormat()
{
Borders = GoogleSheetService.GetBottomMediumBorder(),
TextFormat = GoogleSheetService.GetDefaultTableHeaderFormatting(),
VerticalAlignment = "BOTTOM",
HorizontalAlignment = "RIGHT",
WrapStrategy = "WRAP",
}
});
cells.Add(new CellData()
{
UserEnteredValue = new ExtendedValue()
{
StringValue = "Difference"
},
UserEnteredFormat = new CellFormat()
{
Borders = GoogleSheetService.GetBottomMediumBorder(),
TextFormat = GoogleSheetService.GetDefaultTableHeaderFormatting(),
VerticalAlignment = "BOTTOM",
HorizontalAlignment = "RIGHT",
WrapStrategy = "WRAP",
}
});
_googleSheetService.AddRow(cells);
_googleSheetService.MergeRange(new GridRange()
{
StartRowIndex = 0,
EndRowIndex = 1,
StartColumnIndex = 0,
EndColumnIndex = 4
});
}
