private void AddCategoryRow(CategoryDto category)
{
var cells = new List <CellData>();
cells.Add(new CellData()
{
UserEnteredValue = new ExtendedValue()
{
FormulaValue = $"=Spending!{GoogleSheetService.GetCellAddress(0, category.RowIndex)}"
},
UserEnteredFormat = new CellFormat()
{
TextFormat = GoogleSheetService.GetDefaultCellFormatting(),
Borders = GoogleSheetService.GetAllBorders(),
}
});
cells.Add(new CellData()
{
UserEnteredValue = new ExtendedValue()
{
FormulaValue = $"=Spending!{GoogleSheetService.GetCellAddress(2, category.RowIndex + 2)}"
},
UserEnteredFormat = new CellFormat()
{
NumberFormat = new NumberFormat()
{
Type = "CURRENCY"
},
TextFormat = GoogleSheetService.GetDefaultCellFormatting(),
Borders = GoogleSheetService.GetAllBorders(),
}
});
_googleSheetService.AddRow(cells);
}
private void AddChartsHeader()
{
var cells = new List <CellData>();
cells.Add(new CellData()
{
UserEnteredValue = new ExtendedValue()
{
StringValue = "Charts"
},
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 = "Category"
},
UserEnteredFormat = new CellFormat()
{
Borders = GoogleSheetService.GetAllBorders(),
TextFormat = GoogleSheetService.GetDefaultTableHeaderFormatting(),
}
});
cells.Add(new CellData()
{
UserEnteredValue = new ExtendedValue()
{
StringValue = "Spent"
},
UserEnteredFormat = new CellFormat()
{
Borders = GoogleSheetService.GetAllBorders(),
TextFormat = GoogleSheetService.GetDefaultTableHeaderFormatting(),
HorizontalAlignment = "RIGHT",
}
});
_googleSheetService.AddRow(cells);
_googleSheetService.MergeRange(new GridRange()
{
StartRowIndex = 0,
EndRowIndex = 1,
StartColumnIndex = 0,
EndColumnIndex = 7
});
}