Aspose.Cells.GridWeb.Examples.CSharp.Miscellaneous.Ajax.AjaxUpdating.LoadGrid C# (CSharp) Method

        private void LoadGrid()
        {
            // Define maximum rows and columns
            GridWeb1.MaxColumn = 3;
            GridWeb1.MaxRow = 5;

            // Create web worksheet object
            WebWorksheet sheet = GridWeb1.WebWorksheets[0];

            // Clear worksheet content
            sheet.Cells.Clear();

            // Adding a sample value and formatting to "B1" cell
            sheet.Cells["B1"].PutValue("BMI Calculator");
            sheet.Cells["B1"].GetStyle().BackColor = Color.Yellow;
            sheet.Cells["B1"].GetStyle().ForeColor = Color.Green;
            sheet.Cells["B1"].GetStyle().Font.Bold = true;
            sheet.Cells["B1"].GetStyle().HorizontalAlign = HorizontalAlign.Center;
            sheet.Cells["B1"].GetStyle().VerticalAlign = VerticalAlign.Middle;

            // Merge B1 and B2 columns  
            sheet.Cells.Merge(0, 1, 1, 2);

            // Set columns width
            sheet.Cells.SetColumnWidth(1, new Unit("100pt"));
            sheet.Cells.SetColumnWidth(2, new Unit("100pt"));

            // Adding a sample value and formatting to "B3" cell
            sheet.Cells["B3"].PutValue("Your Height(CM):");
            sheet.Cells["B3"].GetStyle().BackColor = Color.Blue;
            sheet.Cells["B3"].GetStyle().ForeColor = Color.Silver;

            // Adding a sample value and formatting to "B4" cell
            sheet.Cells["B4"].PutValue("Your Weight(KG):");
            sheet.Cells["B4"].GetStyle().BackColor = Color.Blue;
            sheet.Cells["B4"].GetStyle().ForeColor = Color.Silver;

            // Adding a sample value and formatting to "B5" cell
            sheet.Cells["B5"].PutValue("Your BMI is:");
            sheet.Cells["B5"].GetStyle().BackColor = Color.Green;
            sheet.Cells["B5"].GetStyle().ForeColor = Color.Silver;

            // Adding a sample value and formatting to "B6" cell
            sheet.Cells["B6"].PutValue("Evaluation:");
            sheet.Cells["B6"].GetStyle().BackColor = Color.Green;
            sheet.Cells["B6"].GetStyle().ForeColor = Color.Silver;

            //Adding a formula value and formatting to "C5" cell
            sheet.Cells["C5"].Formula = "=C4/(C3/100)^2";
            sheet.Cells["C5"].GetStyle().BackColor = Color.LightGreen;
            sheet.Cells["C5"].GetStyle().ForeColor = Color.Red;
            sheet.Cells["C5"].GetStyle().HorizontalAlign = HorizontalAlign.Right;
            Aspose.Cells.GridWeb.TableItemStyle style = new Aspose.Cells.GridWeb.TableItemStyle();
            style.Custom = "0.00";
            sheet.Cells["C5"].SetStyle(style);

            // Adding a formula value and formatting to "C6" cell 
            sheet.Cells["C6"].Formula = "=IF(C5<18.5, \"Too Thin\", IF(C5<21, \"Good\", IF(C5<=23, \"Very Good\", IF(C5<=25, \"Good\", \"Too Fat\"))))";
            sheet.Cells["C6"].GetStyle().BackColor = Color.LightGreen;
            sheet.Cells["C6"].GetStyle().ForeColor = Color.Red;
            sheet.Cells["C6"].GetStyle().HorizontalAlign = HorizontalAlign.Right;

            // Adding validation and formatting to "C3" cell
            sheet.Cells["C3"].CreateValidation(ValidationType.Number, true);
            sheet.Cells["C3"].GetStyle().HorizontalAlign = HorizontalAlign.Right;

            // Adding validation and formatting to "C4" cell
            sheet.Cells["C4"].CreateValidation(ValidationType.Number, true);
            sheet.Cells["C4"].GetStyle().HorizontalAlign = HorizontalAlign.Right;

            // Adding formatting to "C3" and "C4" cells
            sheet.SetAllCellsReadonly();
            sheet.Cells["C3"].IsReadonly = false;
            sheet.Cells["C4"].IsReadonly = false;

            // Set GridWeb properties
            GridWeb1.EnableAJAX = true;
            GridWeb1.EnableClientColumnOperations = false;
            GridWeb1.EnableClientFreeze = false;
            GridWeb1.EnableClientMergeOperations = false;
            GridWeb1.EnableClientRowOperations = false;
            GridWeb1.EnableStyleDialogbox = false;
        }