GcSpreadSheet1.Sheets[0].ColumnCount = 7;
GcSpreadSheet1.Sheets[0].RowCount = 34;
GcSpreadSheet1.Sheets[0].Cells[0, 0].Text = "Western";
GcSpreadSheet1.Sheets[0].Cells[0, 1].Text = "Western";
GcSpreadSheet1.Sheets[0].Cells[0, 2].Text = "Western";
GcSpreadSheet1.Sheets[0].Cells[1, 0].Text = "A";
GcSpreadSheet1.Sheets[0].Cells[1, 1].Text = "B";
GcSpreadSheet1.Sheets[0].Cells[1, 2].Text = "C";
GcSpreadSheet1.Sheets[0].Cells[2, 0].Text = "A";
GcSpreadSheet1.Sheets[0].Cells[2, 1].Text = "B";
GcSpreadSheet1.Sheets[0].Cells[2, 2].Text = "C";
GcSpreadSheet1.Sheets[0].RowRangeGroup.Group(0, 2);
GcSpreadSheet1.RangeGroupBackground = new System.Windows.Media.SolidColorBrush(Color.FromArgb(200, 180, 50, 25));
GcSpreadSheet1.RangeGroupBorderBrush = new SolidColorBrush(Colors.Green);
GcSpreadSheet1.RangeGroupLineStroke = new SolidColorBrush(Colors.Blue);