// Handles the "create invoice" button click event and create an invoice. protected void Button1_Click(object sender, System.EventArgs e) { GridWorksheetCollection sheets = GridWeb1.WorkSheets; // Clears all sheets. sheets.Clear(); // Creates a new worksheet named "Invoice". GridWorksheet sheet = sheets.Add("Invoice"); sheet.Cells[0, 0].Value = "Order ID"; // Sets the font size of the cell. sheet.Cells[0, 0].Style.Font.Size = new FontUnit("10pt"); sheet.Cells[0, 0].Style.Font.Bold = true; sheet.Cells[0, 0].Style.ForeColor = Color.Blue; sheet.Cells[0, 0].Style.BackColor = Color.Aqua; sheet.Cells[0, 0].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[0, 0].Style.BorderStyle = BorderStyle.Double; sheet.Cells[0, 0].Style.BorderColor = Color.Gold; sheet.Cells[0, 0].Style.BorderWidth = 3; sheet.Cells[0, 1].Value = "Customer ID"; // Another way to set the font size. sheet.Cells[0, 1].Style.Font.Size = new FontUnit(new Unit(10, UnitType.Point)); sheet.Cells[0, 1].Style.Font.Bold = true; sheet.Cells[0, 1].Style.ForeColor = Color.Blue; sheet.Cells[0, 1].Style.BackColor = Color.Aqua; sheet.Cells[0, 1].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[0, 1].Style.BorderStyle = BorderStyle.Double; sheet.Cells[0, 1].Style.BorderColor = Color.Gold; sheet.Cells[0, 1].Style.BorderWidth = 3; sheet.Cells[0, 2].Value = "Salesperson"; sheet.Cells[0, 2].Style.Font.Size = new FontUnit("10pt"); sheet.Cells[0, 2].Style.Font.Bold = true; sheet.Cells[0, 2].Style.ForeColor = Color.Blue; sheet.Cells[0, 2].Style.BackColor = Color.Aqua; sheet.Cells[0, 2].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[0, 2].Style.BorderStyle = BorderStyle.Double; sheet.Cells[0, 2].Style.BorderColor = Color.Gold; sheet.Cells[0, 2].Style.BorderWidth = 3; sheet.Cells[0, 3].Value = "Order Date"; sheet.Cells[0, 3].Style.Font.Size = new FontUnit("10pt"); sheet.Cells[0, 3].Style.Font.Bold = true; sheet.Cells[0, 3].Style.ForeColor = Color.Blue; sheet.Cells[0, 3].Style.BackColor = Color.Aqua; sheet.Cells[0, 3].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[0, 3].Style.BorderStyle = BorderStyle.Double; sheet.Cells[0, 3].Style.BorderColor = Color.Gold; sheet.Cells[0, 3].Style.BorderWidth = 3; sheet.Cells[0, 4].Value = "Ship Via"; sheet.Cells[0, 4].Style.Font.Size = new FontUnit("10pt"); sheet.Cells[0, 4].Style.Font.Bold = true; sheet.Cells[0, 4].Style.ForeColor = Color.Blue; sheet.Cells[0, 4].Style.BackColor = Color.Aqua; sheet.Cells[0, 4].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[0, 4].Style.BorderStyle = BorderStyle.Double; sheet.Cells[0, 4].Style.BorderColor = Color.Gold; sheet.Cells[0, 4].Style.BorderWidth = 3; sheet.Cells[1, 0].Value = "11077"; sheet.Cells[1, 0].Style.HorizontalAlign = HorizontalAlign.Right; sheet.Cells[1, 1].Value = "RATTC"; sheet.Cells[1, 1].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[1, 2].Value = "Nancy Davolio"; sheet.Cells[1, 2].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[1, 3].PutValue(Convert.ToDateTime("2004-5-10")); sheet.Cells[1, 3].Style.HorizontalAlign = HorizontalAlign.Right; style = sheet.Cells[1, 3].Style; sheet.Cells[1, 3].Style.NumberType = (int)NumberType.Date2; sheet.Cells[1, 4].Value = "United Package"; sheet.Cells[1, 4].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[2, 0].Value = "11076"; sheet.Cells[2, 0].Style.HorizontalAlign = HorizontalAlign.Right; sheet.Cells[2, 1].Value = "BONAP"; sheet.Cells[2, 1].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[2, 2].Value = "Margaret Peacock"; sheet.Cells[2, 2].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[2, 3].PutValue(Convert.ToDateTime("2004-5-02")); sheet.Cells[2, 3].Style.HorizontalAlign = HorizontalAlign.Right; style = sheet.Cells[2, 3].Style; sheet.Cells[2, 3].Style.NumberType = (int)NumberType.Date2; sheet.Cells[2, 4].Value = "United Package"; sheet.Cells[2, 4].Style.HorizontalAlign = HorizontalAlign.Center; // Sets the column width. sheet.Cells.SetColumnWidth(1, 20); sheet.Cells.SetColumnWidth(2, 20); sheet.Cells.SetColumnWidth(3, 20); sheet.Cells.SetColumnWidth(4, 20); //set the row height sheet.Cells.SetRowHeight(0, 20); }
private void InitData() { GridWeb1.WorkSheets.Clear(); GridWorksheet sheet = GridWeb1.WorkSheets.Add("Students"); GridCells cells = sheet.Cells; cells[0, 0].PutValue("Name"); GridTableItemStyle cellstyle = cells[0, 0].Style; cellstyle.Font.Size = new FontUnit("10pt"); cellstyle.Font.Bold = true; cellstyle.ForeColor = Color.Black; cellstyle.HorizontalAlign = HorizontalAlign.Center; cellstyle.BorderWidth = 1; cells[0, 0].Style = cellstyle; cells[1, 0].PutValue("Jack"); cells[1, 1].PutValue("M"); cells[1, 2].PutValue(19); cells[1, 3].PutValue("One"); cells[2, 0].PutValue("Tome"); cells[2, 1].PutValue("M"); cells[2, 2].PutValue(20); cells[2, 3].PutValue("Four"); cells[3, 0].PutValue("Jeney"); cells[3, 1].PutValue("W"); cells[3, 2].PutValue(18); cells[3, 3].PutValue("Two"); cells[4, 0].PutValue("Marry"); cells[4, 1].PutValue("W"); cells[4, 2].PutValue(17); cells[4, 3].PutValue("There"); cells[5, 0].PutValue("Amy"); cells[5, 1].PutValue("W"); cells[5, 2].PutValue(16); cells[5, 3].PutValue("Four"); cells[6, 0].PutValue("Ben"); cells[6, 1].PutValue("M"); cells[6, 2].PutValue(17); cells[6, 3].PutValue("Four"); GridCell cell = cells[0, 1]; Aspose.Cells.GridWeb.GridTableItemStyle style = cell.Style; style.Font.Size = new FontUnit("22pt"); style.Wrap = false; //style.BackColor = Color.Gray; style.RightBorderStyle.BorderColor = Color.Red; style.RightBorderStyle.BorderStyle = BorderStyle.Dotted; style.BottomBorderStyle.BorderColor = Color.Green; style.BottomBorderStyle.BorderStyle = BorderStyle.Groove; style.TopBorderStyle.BorderColor = Color.Yellow; style.TopBorderStyle.BorderStyle = BorderStyle.Inset; style.LeftBorderStyle.BorderColor = Color.Coral; style.LeftBorderStyle.BorderStyle = BorderStyle.Solid; cells[0, 1].Style = style; Aspose.Cells.GridWeb.GridTableItemStyle vtstyle1 = new Aspose.Cells.GridWeb.GridTableItemStyle(); vtstyle1.CopyFrom(style); vtstyle1.LeftBorderStyle.BorderWidth = new Unit(1, UnitType.Pixel); vtstyle1.TopBorderStyle.BorderWidth = new Unit(1, UnitType.Pixel); // cells[0, 0].SetStyle(vtstyle1); // cells[1, 2].SetStyle(style); Aspose.Cells.GridWeb.GridTableItemStyle vtstyle2 = new Aspose.Cells.GridWeb.GridTableItemStyle(); vtstyle2.CopyFrom(style); vtstyle2.LeftBorderStyle.BorderWidth = new Unit(10, UnitType.Pixel); // style.LeftBorderStyle.BorderWidth = new Unit(50, UnitType.Pixel); // cells[3, 0].SetStyle(vtstyle2); Aspose.Cells.GridWeb.GridTableItemStyle vtstyle3 = new Aspose.Cells.GridWeb.GridTableItemStyle(); vtstyle3.CopyFrom(style); vtstyle3.TopBorderStyle.BorderWidth = new Unit(1, UnitType.Pixel); vtstyle3.BottomBorderStyle.BorderWidth = new Unit(80, UnitType.Pixel); // cells[0, 1].SetStyle(vtstyle3); Aspose.Cells.GridWeb.GridTableItemStyle vtstyle4 = new Aspose.Cells.GridWeb.GridTableItemStyle(); vtstyle4.CopyFrom(vtstyle3); vtstyle4.TopBorderStyle.BorderWidth = new Unit(1, UnitType.Pixel); vtstyle4.BottomBorderStyle.BorderWidth = new Unit(50, UnitType.Pixel); // cells[0, 2].SetStyle(vtstyle4); Aspose.Cells.GridWeb.GridTableItemStyle vtstyle5 = new Aspose.Cells.GridWeb.GridTableItemStyle(); vtstyle5.CopyFrom(vtstyle3); vtstyle5.TopBorderStyle.BorderWidth = new Unit(1, UnitType.Pixel); vtstyle5.BottomBorderStyle.BorderWidth = new Unit(150, UnitType.Pixel); vtstyle5.RightBorderStyle.BorderWidth = new Unit(40, UnitType.Pixel); vtstyle5.LeftBorderStyle.BorderWidth = new Unit(20, UnitType.Pixel); // cells[1, 1].SetStyle(vtstyle5); Aspose.Cells.GridWeb.GridTableItemStyle vtstyle = new Aspose.Cells.GridWeb.GridTableItemStyle(); vtstyle.CopyFrom(style); vtstyle.RightBorderStyle.BorderWidth = new Unit(50, UnitType.Pixel); // cells[1, 4].SetStyle(vtstyle); // cells[1, 4] // WebCell cellheader = sheet. // cellheader.SetStyle(style); // GridWeb1.SetHeaderBarStyle(new HeaderBarStyle() ); cells.SetRowHeight(0, 20); cells.SetRowHeight(1, 20); cells.SetColumnWidth(0, 10); cells.SetColumnWidth(1, 10); cells.SetColumnWidth(2, 10); cells.SetColumnWidth(3, 10); }
// Handles the "create invoice" button click event and create an invoice. protected void Button1_Click(object sender, System.EventArgs e) { GridWorksheetCollection sheets = GridWeb1.WorkSheets; // Clears all sheets. sheets.Clear(); // Creates a new worksheet named "Invoice". GridWorksheet sheet = sheets.Add("Invoice"); sheet.Cells[0, 0].Value = "Order ID"; // Sets the font size of the cell. sheet.Cells[0, 0].Style.Font.Size = new FontUnit("10pt"); sheet.Cells[0, 0].Style.Font.Bold = true; sheet.Cells[0, 0].Style.ForeColor = Color.Blue; sheet.Cells[0, 0].Style.BackColor = Color.Aqua; sheet.Cells[0, 0].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[0, 0].Style.BorderStyle = BorderStyle.Double; sheet.Cells[0, 0].Style.BorderColor = Color.Gold; sheet.Cells[0, 0].Style.BorderWidth = 3; sheet.Cells[0, 1].Value = "Customer ID"; // Another way to set the font size. sheet.Cells[0, 1].Style.Font.Size = new FontUnit(new Unit(10, UnitType.Point)); sheet.Cells[0, 1].Style.Font.Bold = true; sheet.Cells[0, 1].Style.ForeColor = Color.Blue; sheet.Cells[0, 1].Style.BackColor = Color.Aqua; sheet.Cells[0, 1].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[0, 1].Style.BorderStyle = BorderStyle.Double; sheet.Cells[0, 1].Style.BorderColor = Color.Gold; sheet.Cells[0, 1].Style.BorderWidth = 3; sheet.Cells[0, 2].Value = "Salesperson"; sheet.Cells[0, 2].Style.Font.Size = new FontUnit("10pt"); sheet.Cells[0, 2].Style.Font.Bold = true; sheet.Cells[0, 2].Style.ForeColor = Color.Blue; sheet.Cells[0, 2].Style.BackColor = Color.Aqua; sheet.Cells[0, 2].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[0, 2].Style.BorderStyle = BorderStyle.Double; sheet.Cells[0, 2].Style.BorderColor = Color.Gold; sheet.Cells[0, 2].Style.BorderWidth = 3; sheet.Cells[0, 3].Value = "Order Date"; sheet.Cells[0, 3].Style.Font.Size = new FontUnit("10pt"); sheet.Cells[0, 3].Style.Font.Bold = true; sheet.Cells[0, 3].Style.ForeColor = Color.Blue; sheet.Cells[0, 3].Style.BackColor = Color.Aqua; sheet.Cells[0, 3].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[0, 3].Style.BorderStyle = BorderStyle.Double; sheet.Cells[0, 3].Style.BorderColor = Color.Gold; sheet.Cells[0, 3].Style.BorderWidth = 3; sheet.Cells[0, 4].Value = "Ship Via"; sheet.Cells[0, 4].Style.Font.Size = new FontUnit("10pt"); sheet.Cells[0, 4].Style.Font.Bold = true; sheet.Cells[0, 4].Style.ForeColor = Color.Blue; sheet.Cells[0, 4].Style.BackColor = Color.Aqua; sheet.Cells[0, 4].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[0, 4].Style.BorderStyle = BorderStyle.Double; sheet.Cells[0, 4].Style.BorderColor = Color.Gold; sheet.Cells[0, 4].Style.BorderWidth = 3; sheet.Cells[1, 0].Value = "11077"; sheet.Cells[1, 0].Style.HorizontalAlign = HorizontalAlign.Right; sheet.Cells[1, 1].Value = "RATTC"; sheet.Cells[1, 1].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[1, 2].Value = "Nancy Davolio"; sheet.Cells[1, 2].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[1, 3].PutValue(Convert.ToDateTime("2004-5-10")); sheet.Cells[1, 3].Style.HorizontalAlign = HorizontalAlign.Right; style = sheet.Cells[1, 3].Style; sheet.Cells[1, 3].Style.NumberType = (int)NumberType.Date2; sheet.Cells[1, 4].Value = "United Package"; sheet.Cells[1, 4].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[2, 0].Value = "11076"; sheet.Cells[2, 0].Style.HorizontalAlign = HorizontalAlign.Right; sheet.Cells[2, 1].Value = "BONAP"; sheet.Cells[2, 1].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[2, 2].Value = "Margaret Peacock"; sheet.Cells[2, 2].Style.HorizontalAlign = HorizontalAlign.Center; sheet.Cells[2, 3].PutValue(Convert.ToDateTime("2004-5-02")); sheet.Cells[2, 3].Style.HorizontalAlign = HorizontalAlign.Right; style = sheet.Cells[2, 3].Style; sheet.Cells[2, 3].Style.NumberType = (int)NumberType.Date2; sheet.Cells[2, 4].Value = "United Package"; sheet.Cells[2, 4].Style.HorizontalAlign = HorizontalAlign.Center; // Sets the column width. sheet.Cells.SetColumnWidth(1, 20); sheet.Cells.SetColumnWidth(2, 20); sheet.Cells.SetColumnWidth(3, 20); sheet.Cells.SetColumnWidth(4, 20); // Set the row height sheet.Cells.SetRowHeight(0, 20); }