// input Entry protection/validation data
private void initData()
{
// Forces validation.
//GridWeb1.ForceValidation = true;
string path = Server.MapPath("~");
path = path.Substring(0, path.LastIndexOf("\\"));
string fileName = path + "\\File\\Input.xls";
// Imports from a excel file.
GridWeb1.ImportExcelFile(fileName);
GridWorksheetCollection sheets = GridWeb1.WorkSheets;
// Sets cell validation.
GridValidationCollection gridValidationCollection = sheets[0].Validations;
// Regular expression.
GridValidation C5 = gridValidationCollection.Add();
C5.AddACell("C5");
//C5.Operator = OperatorType.BETWEEN;
C5.ValidationType = GridValidationType.CustomExpression;
C5.RegEx = @"\d{6}";
// Number.
GridValidation C6 = gridValidationCollection.Add();
C6.AddACell("C6");
C6.ValidationType = GridValidationType.Decimal;
// Integer.
GridValidation C7 = gridValidationCollection.Add();
C7.AddACell("C7");
C7.ValidationType = GridValidationType.WholeNumber;
// Date.
GridValidation C8 = gridValidationCollection.Add();
C8.AddACell("C8");
C8.ValidationType = GridValidationType.Date;
// DateTime
GridValidation C9 = gridValidationCollection.Add();
C9.AddACell("C9");
C9.ValidationType = GridValidationType.DateTime;
// List.
GridValidation C10 = gridValidationCollection.Add();
C10.AddACell("C10");
C10.ValidationType = GridValidationType.List;
StringCollection value = new StringCollection();
value.Add("Fortran");
value.Add("Pascal");
value.Add("C++");
value.Add("Visual Basic");
value.Add("Java");
value.Add("C#");
C10.ValueList = value;
value.Clear();
// DropDownList.
GridValidation C11 = gridValidationCollection.Add();
C11.AddACell("C11");
C11.ValidationType = GridValidationType.DropDownList;
value.Add("Bachelor");
value.Add("Master");
value.Add("Doctor");
C11.ValueList = value;
// FreeList
GridValidation C12 = gridValidationCollection.Add();
C12.AddACell("C12");
C12.ValidationType = GridValidationType.FreeList;
value.Add("US");
value.Add("Britain");
value.Add("France");
C12.ValueList = value;
// Custom function
GridValidation C13 = gridValidationCollection.Add();
C13.AddACell("C13");
C13.ValidationType = GridValidationType.CustomFunction;
C13.ClientValidationFunction = "myvalidation1";
// CheckBox
GridValidation C14 = gridValidationCollection.Add();
C14.AddACell("C14");
C14.ValidationType = GridValidationType.CheckBox;
}
// 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);
}
