private void CreateRowCaptions() { // ExStart:CustomizeRowHeader // Accessing the worksheet that is currently active GridWorksheet workSheet = GridWeb1.WorkSheets[GridWeb1.ActiveSheetIndex]; // Create custom row header caption. workSheet.SetRowCaption(1, "Row1"); workSheet.SetRowCaption(2, "Row2"); // ExEnd:CustomizeRowHeader }
protected void Button1_Click(object sender, EventArgs e) { // Only showss 3 columns. GridWeb1.MaxColumn = 2; GridWorksheet workSheet = GridWeb1.WorkSheets[0]; GridCells cells = workSheet.Cells; // Creates Custom Header Caption. workSheet.SetColumnCaption(0, "Product"); workSheet.SetColumnCaption(1, "Category"); workSheet.SetColumnCaption(2, "Price"); workSheet.SetRowCaption(2, "row2"); // Put some values. cells["A1"].PutValue("Aniseed Syrup"); cells["A2"].PutValue("Boston Crab Meat"); cells["A3"].PutValue("Chang"); cells["B1"].PutValue("Condiments"); cells["B2"].PutValue("Seafood"); cells["B3"].PutValue("Beverages"); cells["C1"].PutValue(14.95); Aspose.Cells.GridWeb.GridTableItemStyle style = cells["C1"].Style; style.NumberType = (int)NumberType.Currency3; style.HorizontalAlign = HorizontalAlign.Right; cells["C1"].Style = style; cells["C2"].PutValue(24.99); cells["C2"].Style = style; cells["C3"].PutValue(49.95); cells["C3"].Style = style; // Adjusts column width. cells.SetColumnWidth(0, 20); cells.SetColumnWidth(1, 20); cells.SetColumnWidth(2, 20); }