protected void btnCreate_Click(object sender, System.EventArgs e)
{
// Fill web worksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
// Removes the created subtotal first.
//sheet.RemoveSubtotal();
// Creates the subtotal.
int groupByIndex;
if (ddlSort.SelectedItem.Value == "CategoryName")
{
groupByIndex = 1;
}
else
{
groupByIndex = 2;
}
// Creates GrandTotal and Subtotal style.
Aspose.Cells.GridWeb.TableItemStyle grandStyle = new Aspose.Cells.GridWeb.TableItemStyle();
grandStyle.BackColor = Color.Gray;
grandStyle.ForeColor = Color.Black;
Aspose.Cells.GridWeb.TableItemStyle subtotalStyle = new Aspose.Cells.GridWeb.TableItemStyle();
subtotalStyle.BackColor = Color.SkyBlue;
subtotalStyle.ForeColor = Color.Black;
// ExStart:CreateSubTotal
sheet.CreateSubtotal(0, sheet.Cells.MaxRow, groupByIndex, (SubtotalFunction)System.Enum.Parse(typeof(SubtotalFunction), ddlFunction.SelectedItem.Value), new int[] { 1, 2, 3, 4, 5 }
, ddlFunction.SelectedItem.Text, grandStyle, subtotalStyle, NumberType.General, null);
// ExEnd:CreateSubTotal
}
protected void btnApplyBorderStyles_Click(object sender, EventArgs e)
{
// ExStart:ApplyBorderStyles
// Accessing the reference of the worksheet that is currently active and resize first row and column
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
sheet.Cells.Clear();
sheet.Cells.SetColumnWidth(0, new Unit(200, UnitType.Point));
sheet.Cells.SetRowHeight(0, new Unit(50, UnitType.Point));
// Accessing a specific cell of the worksheet
WebCell cell = sheet.Cells["A1"];
Aspose.Cells.GridWeb.TableItemStyle style = cell.GetStyle();
// Setting the border style to Solid
style.BorderStyle = BorderStyle.Solid;
// Setting the border width to 2 pixels
style.BorderWidth = new Unit(2, UnitType.Pixel);
// Setting the border color to Blue
style.BorderColor = Color.Blue;
// Set the cell style
cell.SetStyle(style);
// ExEnd:ApplyBorderStyles
}
protected void btnApplyNumberFormats_Click(object sender, EventArgs e)
{
// ExStart:ApplyNumberFormats
// Accessing the reference of the worksheet that is currently active
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
sheet.Cells.Clear();
sheet.Cells.SetColumnWidth(0, new Unit(200, UnitType.Point));
sheet.Cells.SetRowHeight(0, new Unit(50, UnitType.Point));
// Putting values to cells
sheet.Cells["A1"].PutValue("Currency1 Number Format");
sheet.Cells["A2"].PutValue("Custom Number Format");
sheet.Cells["B1"].PutValue(7800);
sheet.Cells["B2"].PutValue(2500);
// Setting the number format of "B1" cell to Currency1
Aspose.Cells.GridWeb.TableItemStyle style = sheet.Cells["B1"].GetStyle();
style.NumberType = NumberType.Currency1;
sheet.Cells["B1"].SetStyle(style);
// Setting the custom number format of "B2" cell
style = sheet.Cells["B2"].GetStyle();
style.Custom = "#,##0.0000";
sheet.Cells["B2"].SetStyle(style);
// ExEnd:ApplyNumberFormats
}
protected void btnApplyFontStyles_Click(object sender, EventArgs e)
{
// ExStart:ApplyFontStyles
// Accessing the reference of the worksheet that is currently active and resize first row and column
WebWorksheet sheet = GridWeb1.WebWorksheets[GridWeb1.ActiveSheetIndex];
sheet.Cells.Clear();
sheet.Cells.SetColumnWidth(0, new Unit(200, UnitType.Point));
sheet.Cells.SetRowHeight(0, new Unit(50, UnitType.Point));
// Accessing a specific cell of the worksheet
WebCell cell = sheet.Cells["A1"];
// Inserting a value in cell A1
cell.PutValue("Aspose.Cells.GridWeb");
Aspose.Cells.GridWeb.TableItemStyle style = cell.GetStyle();
// Setting the font size to 12 points
style.Font.Size = new FontUnit("12pt");
// Setting font style to Bold
style.Font.Bold = true;
// Setting foreground color of font to Blue
style.ForeColor = Color.Blue;
// Setting background color of font to Aqua
style.BackColor = Color.Aqua;
// Setting the horizontal alignment of font to Center
style.HorizontalAlign = HorizontalAlign.Center;
// Set the cell style
cell.SetStyle(style);
// ExEnd:ApplyFontStyles
}
protected void btnCreate_Click(object sender, System.EventArgs e)
{
// Fill web worksheet object
WebWorksheet sheet = GridWeb1.WebWorksheets[0];
// Removes the created subtotal first.
//sheet.RemoveSubtotal();
// Creates the subtotal.
int groupByIndex;
if (ddlSort.SelectedItem.Value == "CategoryName")
groupByIndex = 1;
else
groupByIndex = 2;
// Creates GrandTotal and Subtotal style.
Aspose.Cells.GridWeb.TableItemStyle grandStyle = new Aspose.Cells.GridWeb.TableItemStyle();
grandStyle.BackColor = Color.Gray;
grandStyle.ForeColor = Color.Black;
Aspose.Cells.GridWeb.TableItemStyle subtotalStyle = new Aspose.Cells.GridWeb.TableItemStyle();
subtotalStyle.BackColor = Color.SkyBlue;
subtotalStyle.ForeColor = Color.Black;
// ExStart:CreateSubTotal
sheet.CreateSubtotal(0, sheet.Cells.MaxRow, groupByIndex, (SubtotalFunction)System.Enum.Parse(typeof(SubtotalFunction), ddlFunction.SelectedItem.Value), new int[] { 1, 2, 3, 4, 5 }
, ddlFunction.SelectedItem.Text, grandStyle, subtotalStyle, NumberType.General, null);
// ExEnd:CreateSubTotal
}
