private void InitData()
{
// Gets the web application's path.
string path = (this.Master as Site).GetDataDir();
string fileName = path + "\\Worksheets\\Sort.xls";
// Imports from an excel file.
GridWeb1.ImportExcelFile(fileName);
// Creates sorting header style.
GridTableItemStyle itemStyle = new GridTableItemStyle();
itemStyle.BorderStyle = BorderStyle.Outset;
itemStyle.BorderWidth = 2;
itemStyle.BorderColor = Color.White;
itemStyle.BackColor = Color.Silver;
itemStyle.HorizontalAlign = HorizontalAlign.Center;
itemStyle.VerticalAlign = VerticalAlign.Middle;
// Creates Hyperlinks Sheet1. Sorts from top to bottom orientation.
GridHyperlink cellcmd;
GridCells cells0 = GridWeb1.WorkSheets[0].Cells;
cells0["A1"].CopyStyle(itemStyle);
GridHyperlinkCollection ghc = GridWeb1.WorkSheets[0].Hyperlinks;
int i = ghc.Add("A1", "");
cellcmd = ghc[i];
cellcmd.Command = "A1";
cellcmd.ScreenTip = "Sorts Descending";
cellcmd.TextToDisplay = "OrderId";
cells0["B1"].CopyStyle(itemStyle);
cellcmd = ghc[ghc.Add("B1", "")];
cellcmd.Command = "B1";
cellcmd.ScreenTip = "Sorts Ascending";
cellcmd.TextToDisplay = "Sales Amout";
cells0["C1"].CopyStyle(itemStyle);
cellcmd = ghc[ghc.Add("C1", "")];
cellcmd.Command = "C1";
cellcmd.ScreenTip = "Sorts Descending";
cellcmd.TextToDisplay = "Percent of Saler's Total";
cells0["D1"].CopyStyle(itemStyle);
cellcmd = ghc[ghc.Add("D1", "")];
cellcmd.Command = "D1";
cellcmd.ScreenTip = "Sorts Ascending";
cellcmd.TextToDisplay = "Percent of Country Total";
// Creates Hyperlinks Sheet2. Sorts from left to right orientation.
GridCells cells1 = GridWeb1.WorkSheets[1].Cells;
GridHyperlinkCollection ghcb = GridWeb1.WorkSheets[1].Hyperlinks;
cells1["A1"].CopyStyle(itemStyle);
cellcmd = ghcb[ghcb.Add("A1", "")];
cellcmd.Command = "1A1";
cellcmd.ScreenTip = "Sorts Ascending";
cellcmd.TextToDisplay = "Product";
cells1["A2"].CopyStyle(itemStyle);
cellcmd = ghcb[ghcb.Add("A2", "")];
cellcmd.Command = "1A2";
cellcmd.ScreenTip = "Sorts Ascending";
cellcmd.TextToDisplay = "Category";
cells1["A3"].CopyStyle(itemStyle);
cellcmd = ghcb[ghcb.Add("A3", "")];
cellcmd.Command = "1A3";
cellcmd.ScreenTip = "Sorts Ascending";
cellcmd.TextToDisplay = "Package";
cells1["A4"].CopyStyle(itemStyle);
cellcmd = ghcb[ghcb.Add("A4", "")];
cellcmd.Command = "1A4";
cellcmd.ScreenTip = "Sorts Ascending";
cellcmd.TextToDisplay = "Quantity";
}
private void InitData()
{
// Gets the web application's path.
string path = Server.MapPath("~");
// Upper level.
path = path.Substring(0, path.LastIndexOf("\\"));
string fileName = path + "\\File\\Hyperlink.xls";
// Clears datasheets first.
GridWeb1.WorkSheets.Clear();
// Imports from a excel file.
GridWeb1.ImportExcelFile(fileName);
GridHyperlinkCollection ghc = GridWeb1.WorkSheets[0].Hyperlinks;
//Adds a text hyperlink that gos to Aspose site and opens in new window
int i = ghc.Add("B1", "http://www.aspose.com");
GridHyperlink linkOfText1 = ghc[i];
linkOfText1.Target = "_blank";
linkOfText1.TextToDisplay = "Aspose site";
linkOfText1.ScreenTip = "Go to Aspose site and open in new window";
////Adds a text hyperlink that gos to Aspose site and opens in current window
GridHyperlink linkOfText2 = ghc[ghc.Add("B2", "http://localhost:40056/grid/common/Pagination.aspx")];
linkOfText2.TextToDisplay = "Paginatind sheet Demo";
linkOfText2.Target = "_self";
linkOfText2.ScreenTip = "Go to Aspose site and open in current window";
//Adds a text hyperlink that gos to Aspose site and opens in top window
GridHyperlink linkOfText3 = ghc[ghc.Add("B3", "http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx")];
linkOfText3.TextToDisplay = "Aspose.Cells.GridWeb Product";
linkOfText3.Target = "_top";
linkOfText3.ScreenTip = "Go to Aspose site and open in top window";
//Adds a text hyperlink that gos to Aspose site and opens in parent window
GridHyperlink linkOfText4 = ghc[ghc.Add("B4", "http://www.aspose.com/Community/Forums/258/ShowForum.aspx")];
linkOfText4.TextToDisplay = "Aspose.Cells.GridWeb Forums";
linkOfText4.Target = "_parent";
linkOfText4.ScreenTip = "Go to Aspose site and open in parent window";
//Adds a image hyperlink that gos to Aspose site and opens in current window
GridHyperlink linkOfImage1 = ghc[ghc.Add("B6", "http://www.aspose.com")];
linkOfImage1.ImageURL = "../../Images/Aspose.Banner.gif";
linkOfImage1.Target = "_blank";
linkOfImage1.ScreenTip = "Go to Aspose site and open in new window";
//Adds a image hyperlink that gos to Aspose.Cells.GridWeb site and opens in new window
GridHyperlink linkOfImage2 = ghc[ghc.Add("B7", "http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx")];
linkOfImage2.ImageURL = "../../Images/Aspose.Grid.gif";
linkOfImage1.Target = "_blank";
linkOfImage2.ScreenTip = "Go to Aspose site and open in new window";
//Adds a CellImage
GridHyperlink image = ghc[ghc.Add("B8", "")];
image.ImageURL = "../../Images/Aspose.Grid.gif";
//image.ActionType = HyperlinkActionType.CellCommand;
image.ScreenTip = "A simple CellImage.";
GridWeb1.WorkSheets[0].Cells["A8"].PutValue("Creates a CellImage:");
GridWeb1.WorkSheets[0].Cells.SetRowHeight(7, 100);
//Picture pi = GridWeb1.WebWorksheets[0].Pictures.AddPicture("B8");
//pi.Image = "";
GridCells cells = GridWeb1.WorkSheets[1].Cells;
GridValidationCollection gvc = GridWeb1.WorkSheets[1].Validations;
GridValidation validation = gvc.Add("B13");
validation.ValidationType = GridValidationType.DropDownList;
StringCollection value = new StringCollection();
value.Add("1996");
value.Add("1997");
value.Add("1998");
validation.ValueList = value;
cells["B13"].PutValue("1996");
//Adds a cell command hyperlink
GridHyperlink linkOfCellCommand1 = ghc[ghc.Add("C13", "")];
linkOfCellCommand1.Command = "Year";
linkOfCellCommand1.ScreenTip = "Summarizes Sales by Year";
linkOfCellCommand1.ImageURL = "../../Images/button1.bmp";
GridValidation validationB14 = gvc.Add("B14");
validationB14.ValidationType = GridValidationType.DropDownList;
validationB14.Formula1 = "1,2,3,4";
cells["B14"].PutValue("1");
//Adds a cell command hyperlink
GridHyperlink linkOfCellCommand2 = ghc[ghc.Add("C14", "")];
linkOfCellCommand2.Command = "Quarter";
linkOfCellCommand2.ScreenTip = "Summarizes Sales by Quater";
linkOfCellCommand2.ImageURL = "../../Images/button2.bmp";
}
