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 }); }