aspose-com-gists/01_Aspose.Cells.GridDesktop

## 01_Aspose.Cells.GridDesktop
This Gist contains code snippets for examples of Aspose.Cells.GridDesktop.

## Examples-GridDesktop-CSharp-PivotTablesInGridDesktop-Form_RenderPivotTableInGridDesktop.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

//Path of the sample Excel file containing Pivot Table
string filePath = Utils.Get_SourceDirectory() + "sampleRenderPivotTableInGridDesktop.xlsx";

//Import sample Excel file containing Pivot Table
this.gridDesktop1.ImportExcelFile(filePath);

## Examples-GridDesktop-CSharp-WorkingWithGridDesktop-Form_FindGridDesktopVersionAtRunTime.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

//Get the version number of GridDesktop
string version = Aspose.Cells.GridDesktop.GridDesktop.GetVersion();

//Show the version number in message box
MessageBox.Show("GridDesktop Version: " + version, "GridDesktop Version");

## Examples-GridDesktop-CSharp-WorkingWithRowsandColumns-Form_CustomRowAndCustomColumnCaptionOfGridDesktopWorksheet.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

public class MyICustomColumnCaption : ICustomColumnCaption
{
	//Returns the Custom Column Caption
	public string GetCaption(int column)
	{
		return "Mine " + (column + 10);
	}
}
public class MyICustomRowCaption : ICustomRowCaption
{
	//Returns the Custom Row Caption
	public string GetCaption(int row)
	{
		return "R" + (row + 10).ToString();
	}
}

//-------------------------------------------
//-------------------------------------------

//Access the First GridDesktop Worksheet
Worksheet ws = this.gridDesktop1.Worksheets[0];

//Assign the Worksheet Custom Column and Row Caption Instance
ws.CustomColumnCaption = new MyICustomColumnCaption();
ws.CustomRowCaption = new MyICustomRowCaption();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-Articles-CopyAndPasteRows-1.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
/*
 * Indicates whether to copy/paste based on clipboard, so that it can copy/paste with MS-EXCEL.
 * It will only copy/paste cell value and will not copy any other setting of the cell like format, border style and so on.
 * The default value is false.
*/
gridDesktop1.EnableClipboardCopyPaste = true;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-Articles-DataBindingFeature-AddingNamespaceToTheTop.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Adding namespace to the top of code
using System.Data.OleDb;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-Articles-DataBindingFeature-AddingRows.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Adding new row to the worksheet
gridDesktop1.GetActiveWorksheet().AddRow();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-Articles-DataBindingFeature-ApplyCustomStyle.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Iterating through each column of the worksheet
for (int i = 0; i < sheet.ColumnsCount; i++)
{
    // Getting the style object of each column
    Style style = sheet.Columns[i].GetStyle();

    // Setting the color of each column to Yellow
    style.Color = Color.Yellow;

    // Setting the Horizontal Alignment of each column to Centered
    style.HAlignment = HorizontalAlignmentType.Centred;

    // Setting the style of column to the updated one
    sheet.Columns[i].SetStyle(style);
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-Articles-DataBindingFeature-BindWorksheet.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Binding the Worksheet to Products table by calling its DataBind method
sheet.DataBind(ds.Tables["Products"], "");

## Examples.GridDesktop-CSharp-GridDesktop.Examples-Articles-DataBindingFeature-CustomizingStyle.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Customizing the widths of columns of the worksheet
sheet.Columns[0].Width = 70;
sheet.Columns[1].Width = 120;
sheet.Columns[2].Width = 80;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-Articles-DataBindingFeature-DeclareGlobalVariable.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Declaring global variable
OleDbDataAdapter adapter;
OleDbCommandBuilder cb;
DataSet ds;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-Articles-DataBindingFeature-DeletingRows.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Getting the index of the focused row
int focusedRowIndex = gridDesktop1.GetActiveWorksheet().GetFocusedCell().Row;

// Removing the focused row fro the worksheet
gridDesktop1.GetActiveWorksheet().RemoveRow(focusedRowIndex);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-Articles-DataBindingFeature-FillDataSet.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
private void DataBindingFeatures_Load(object sender, EventArgs e)
{
    // The path to the documents directory.
    string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

    // Creating Select query to fetch data from database
    string query = "SELECT * FROM Products ORDER BY ProductID";

    // Creating connection string to connect with database
    string conStr = @"Provider=microsoft.jet.oledb.4.0;Data Source=" + dataDir + "dbDatabase.mdb";

    // Creating OleDbDataAdapter object that will be responsible to open/close connections with database, fetch data and fill DataSet with data
    adapter = new OleDbDataAdapter(query, conStr);

    // Setting MissingSchemaAction to AddWithKey for getting necesssary primary key information of the tables
    adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

    /*
     * Creating OleDbCommandBuilder object to create insert/delete SQL commmands
     * automatically that are used by OleDbDatAdapter object for updating
     * changes to the database
    */
    cb = new OleDbCommandBuilder(adapter);

    // Creating DataSet object
    ds = new DataSet();

    // Filling DataSet with data fetched by OleDbDataAdapter object
    adapter.Fill(ds, "Products");
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-Articles-DataBindingFeature-SavingChangesToDatabase.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Updating the database according to worksheet data source
adapter.Update((DataTable)sheet.DataSource);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-Articles-DataBindingFeature-SettingColumnHeader.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Iterating through all columns of the Products table in DataSet
for (int i = 0; i < ds.Tables["Products"].Columns.Count; i++)
{
    // Setting the column header of each column to the column caption of Products table
    sheet.Columns[i].Header = ds.Tables["Products"].Columns[i].Caption;
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-AccessAndModifyCells-UsingSetCellValue.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Accessing the cell using its name
GridCell cell = sheet.Cells["A1"];

// Setting the value of "A1" cell
cell.SetCellValue(DateTime.Now);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-AccessAndModifyCells-UsingValue.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Accessing the cell using its name
GridCell cell = sheet.Cells["A1"];

// Accessing & modifying the value of "A1" cell
cell.Value = DateTime.Now;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-AccessingCells-AccessByIndices.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Accessing a cell using its row and column indices
GridCell cell = sheet.Cells[1, 1];

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-AccessingCells-AccessByName.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Accessing a cell using its name
GridCell cell = sheet.Cells["A1"];

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-AccessingCells-AccessFocusedCell.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Accessing a cell that is currently in focus
GridCell cell = sheet.GetFocusedCell();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-AddCellProtection-1.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Make sure sheet has been protected
sheet.Protected = true;

// Choose a cell range
CellRange range = sheet.CreateRange("A1", "B1");

// Set protected range area on Worksheet
sheet.SetProtected(range, true);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-AddingCellFormulas-1.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Adding numeric values to "B2" & "B3" cells
sheet.Cells["B2"].SetCellValue(3);
sheet.Cells["B3"].SetCellValue(4);

// Adding a formula to "B4" cell multiplying the values of "B2" & "B3" cells
sheet.Cells["B4"].SetCellValue("=B2 * B3");

// Running all formulas in the Grid
gridDesktop1.RunAllFormulas();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-ApplyStyleOnCells-ApplyStyle.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Accessing "A1" cell in the worksheet
GridCell cell = sheet.Cells["A1"];

// Adding a value to "A1" cell
cell.Value = "Hello";

// Getting the Style object for the cell
Style style = cell.GetStyle();

// Setting Style properties like border, alignment etc.
style.SetBorderLine(BorderType.Right, BorderLineType.Thick);
style.SetBorderColor(BorderType.Right, Color.Blue);
style.HAlignment = HorizontalAlignmentType.Centred;
style.Color = Color.Yellow;
style.CellLocked = true;
style.VAlignment = VerticalAlignmentType.Top;

// Setting the style of the cell with the customized Style object
cell.SetStyle(style);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-ApplyStyleOnCells-SetNumberFormat.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Aspose.Cells.GridDesktop.Worksheet sheet = gridDesktop1.Worksheets[0];

// Creating a standard Font object that will be applied on cells
System.Drawing.Font font = new System.Drawing.Font("MS Serif", 9f, FontStyle.Bold);

// Accessing and adding values to cells
Aspose.Cells.GridDesktop.GridCell cell = sheet.Cells["B2"];
cell.Value = "General";
cell.SetFont(font);
cell = sheet.Cells["C2"];
cell.Value = 1000;
cell = sheet.Cells["D2"];
cell.Value = "Text";
cell = sheet.Cells["B4"];
cell.Value = "Number";
cell.SetFont(font);

//Accessing the Style object of "C4" cell and setting its number format to index No.2
cell = sheet.Cells["C4"];
cell.Value = 20.00;
Aspose.Cells.GridDesktop.Style style = cell.GetStyle();

// For applying "0.00" format
style.NumberFormat = 2;
cell.SetStyle(style);

// Accessing the Style object of "D4" cell and setting its number format to index No.3
cell = sheet.Cells["D4"];
cell.Value = -2000.00;
style = cell.GetStyle();

// For "#,##0" format
style.NumberFormat = 3;
cell.SetStyle(style);

// Accessing a cell and setting its value & font
cell = sheet.Cells["B6"];
cell.Value = "Currency";
cell.SetFont(font);

// Accessing the Style object of "C6" cell and setting its number format to index No.6
cell = sheet.Cells["C6"];
cell.Value = -120.00;
style = cell.GetStyle();

// For Applying "\"$\"#,##0_);[Red](\"$\"#,##0)" expression
style.NumberFormat = 6;
cell.SetStyle(style);

// Accessing the Style object of "D6" cell and setting its number format to index No.41
cell = sheet.Cells["D6"];
cell.Value = 2400;
style = cell.GetStyle();

// For applying "_(\"$\"* #,##0_);_(\"$\"* (#,##0);_(\"$\"* \"-\"_);_(@_)" expression
style.NumberFormat = 41;
cell.SetStyle(style);

// Accessing a cell and setting its value & font
cell = sheet.Cells["B8"];
cell.Value = "Percent";
cell.SetFont(font);

// Accessing the Style object of "C8" cell and setting its number format to index No.9
cell = sheet.Cells["C8"];
cell.Value = 0.32;
style = cell.GetStyle();
style.NumberFormat = 9;
cell.SetStyle(style);

// Accessing the Style object of "D8" cell and setting its number format to index No.10
cell = sheet.Cells["D8"];
cell.Value = 0.64;
style = cell.GetStyle();

// For applying "0.00%" format
style.NumberFormat = 10;
cell.SetStyle(style);

// Accessing a cell and setting its value & font
cell = sheet.Cells["B10"];
cell.Value = "Scientific";
cell.SetFont(font);

// Accessing the Style object of "C10" cell and setting its number format to index No.11
cell = sheet.Cells["C10"];
cell.Value = 0.51;
style = cell.GetStyle();

// For applying "0.00E+00" format
style.NumberFormat = 11;
cell.SetStyle(style);

// Accessing the Style object of "D10" cell and setting its number format to index No.48
cell = sheet.Cells["D10"];
cell.Value = 32000;
style = cell.GetStyle();
style.NumberFormat = 48;
cell.SetStyle(style);

// Accessing a cell and setting its value & font
cell = sheet.Cells["B12"];
cell.Value = "DateTime";
cell.SetFont(font);

// Accessing the Style object of "C12" cell and setting a custom number format for it
cell = sheet.Cells["C12"];
cell.Value = DateTime.Now;
style = cell.GetStyle();
style.Custom = "yyyy-MM-dd";
cell.SetStyle(style);

// Accessing the Style object of "D12" cell and setting its number format to Index No.15
cell = sheet.Cells["D12"];
sheet.Columns[cell.Column].Width = 100;
cell.Value = DateTime.Now;
style = cell.GetStyle();

// For "d-mmm-yy"
style.NumberFormat = 15;
cell.SetStyle(style);

// Accessing the Style object of "C13" cell and setting a custom number format for it
cell = sheet.Cells["C13"];
cell.Value = DateTime.Now;
style = cell.GetStyle();
style.Custom = "hh:mm:ss";
cell.SetStyle(style);

// Accessing the Style object of "D13" cell and setting its number format to index No.18
cell = sheet.Cells["D13"];
cell.Value = DateTime.Now;
style = cell.GetStyle();

// For applying "h:mm AM/PM" format
style.NumberFormat = 18;
cell.SetStyle(style);

// Accessing the Style object of "C14" cell and setting a custom number format for it
cell = sheet.Cells["C14"];
sheet.Columns[cell.Column].Width = 160;
cell.Value = DateTime.Now;
style = cell.GetStyle();
style.Custom = "yyyy-MM-dd hh:mm:ss";
cell.SetStyle(style);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-ApplyStyleOnCells-SummingUp.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Aspose.Cells.GridDesktop.Worksheet sheet = gridDesktop1.Worksheets[0];

// Accessing "B2" cell and setting its value
Aspose.Cells.GridDesktop.GridCell cell = sheet.Cells["B2"];
cell.Value = "None";

// Accessing "D4" cell and setting its value & column width
cell = sheet.Cells["D4"];
cell.Value = "out line Borders";
sheet.Columns[cell.Column].Width = 120;

// Accessing the Style object of "D4" cell and drawing thin red borders around it
Aspose.Cells.GridDesktop.Style style = cell.GetStyle();
style.SetBorderLine(BorderType.Left, BorderLineType.Thin);
style.SetBorderColor(BorderType.Left, System.Drawing.Color.Red);
style.SetBorderLine(BorderType.Right, BorderLineType.Thin);
style.SetBorderColor(BorderType.Right, System.Drawing.Color.Red);
style.SetBorderLine(BorderType.Top, BorderLineType.Thin);
style.SetBorderColor(BorderType.Top, System.Drawing.Color.Red);
style.SetBorderLine(BorderType.Bottom, BorderLineType.Thin);
style.SetBorderColor(BorderType.Bottom, System.Drawing.Color.Red);
cell.SetStyle(style);

// Accessing "B6" cell and setting its value, row height & column width
cell = sheet.Cells["B6"];
cell.Value = "Border with\ndifferent colors";
sheet.Rows[cell.Row].Height = 40;
sheet.Columns[cell.Column].Width = 110;

// Accessing the Style object of "B6" cell and drawing thin borders of different colors around it
style = cell.GetStyle();
style.SetBorderLine(BorderType.Left, BorderLineType.Thin);
style.SetBorderColor(BorderType.Left, System.Drawing.Color.Red);
style.SetBorderLine(BorderType.Right, BorderLineType.Thin);
style.SetBorderColor(BorderType.Right, System.Drawing.Color.Green);
style.SetBorderLine(BorderType.Top, BorderLineType.Thin);
style.SetBorderColor(BorderType.Top, System.Drawing.Color.Yellow);
style.SetBorderLine(BorderType.Bottom, BorderLineType.Thin);
style.SetBorderColor(BorderType.Bottom, System.Drawing.Color.Blue);
cell.SetStyle(style);

// Accessing "D7" cell and setting its value, row height & column width
cell = sheet.Cells["D7"];
cell.Value = "Border with\ndifferent styles";
sheet.Rows[cell.Row].Height = 40;
sheet.Columns[cell.Column].Width = 110;

// Accessing the Style object of "D7" cell and drawing different borders of different colors around it
style = cell.GetStyle();
style.SetBorderLine(BorderType.Left, BorderLineType.Thin);
style.SetBorderColor(BorderType.Left, System.Drawing.Color.Red);
style.SetBorderLine(BorderType.Right, BorderLineType.Medium);
style.SetBorderColor(BorderType.Right, System.Drawing.Color.Red);
style.SetBorderLine(BorderType.Top, BorderLineType.Dashed);
style.SetBorderColor(BorderType.Top, System.Drawing.Color.Yellow);
style.SetBorderLine(BorderType.Bottom, BorderLineType.Dotted);
style.SetBorderColor(BorderType.Bottom, System.Drawing.Color.Black);
cell.SetStyle(style);

// Accessing "B8" cell and drawing a single red border to its bottom side
cell = sheet.Cells["B8"];
cell.Value = "Only one border";
style = cell.GetStyle();
style.SetBorderLine(BorderType.Bottom, BorderLineType.MediumDashDotted);
style.SetBorderColor(BorderType.Bottom, System.Drawing.Color.Red);
cell.SetStyle(style);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-ChangeFontColorOfCell-1.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Accessing a cell using its name
GridCell cell = sheet.Cells["A1"];

// Creating a customized Font object
Font font = new Font("Arial", 10, FontStyle.Bold);

// Setting the font of the cell to the customized Font object
cell.SetFont(font);

// Setting the font color of the cell to Blue
cell.SetFontColor(Color.Blue);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-FilteringData-AutoFilter.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Enable GridDesktop's auto-filter.
gridDesktop1.Worksheets[0].RowFilter.EnableAutoFilter = true;

// Set the header row.
gridDesktop1.Worksheets[0].RowFilter.HeaderRow = 0;

// Set the starting row.
gridDesktop1.Worksheets[0].RowFilter.StartRow = 1;

// Set the ending row.
gridDesktop1.Worksheets[0].RowFilter.EndRow = 101;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-FilteringData-CustomFilter.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Set the starting row.
gridDesktop1.Worksheets[0].RowFilter.StartRow = 1;

// Set the ending row.
gridDesktop1.Worksheets[0].RowFilter.EndRow = 101;

// Get the RowFilter object for the first worksheet.
RowFilterSettings rowFilter = gridDesktop1.Worksheets[0].RowFilter;

// Filter Rows.
rowFilter.FilterRows(0, "Customer 1");

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-FormattingCellRange-1.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Setting sample values
GridCell cell = sheet.Cells["b7"];
cell.SetCellValue("1");
cell = sheet.Cells["c7"];
cell.SetCellValue("2");
cell = sheet.Cells["d7"];
cell.SetCellValue("3");
cell = sheet.Cells["e7"];
cell.SetCellValue("4");

// Creating a CellRange object starting from "B7" to "E7"
CellRange range = new CellRange(6, 1, 6, 4);

// Accessing and setting Style attributes
Style style = new Style(this.gridDesktop1);
style.Color = Color.Yellow;

// Applying Style object on the range of cells
sheet.SetStyle(range, style);

// Creating a customized Font object
Font font = new Font("Courier New", 12f);

// Setting the font of range of cells to the customized Font object
sheet.SetFont(range, font);

// Setting the font color of range of cells to Red
sheet.SetFontColor(range, Color.Red);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-MergingAndUnMergingCells-MergeCells.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Creating a CellRange object starting from "B4" to "C6"
CellRange range = new CellRange("B4", "C6");

// Merging a range of cells
sheet.Merge(range);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-MergingAndUnMergingCells-UnMergeCells.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Accessing the merged cell that is currently in focus
GridCell cell = sheet.GetFocusedCell();

// Unmerging a cell using its location
sheet.Unmerge(cell.Location);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-UndoRedoFeature-Redo.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Create the UndoManager object
UndoManager um = gridDesktop1.UndoManager;

// Perform Redo operation
um.Redo();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-UndoRedoFeature-Undo.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Enable the Undo operation
gridDesktop1.EnableUndo = true;

// Create the UndoManager object
UndoManager um = gridDesktop1.UndoManager;

// Perform Undo operation
um.Undo();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-UsingFormatPainter-EndUse.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Ending format painter to stop painting
gridDesktop1.EndFormatPainter();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-UsingFormatPainter-UseAlways.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Starting format painter to keep painting forever
gridDesktop1.StartFormatPainter(true);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-UsingFormatPainter-UseOnce.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Starting format painter to paint once
gridDesktop1.StartFormatPainter(false);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-UsingNamedRanges-1.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Clear the Worsheets first
_grid.Clear();

// The path to the documents directory.
string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Specifying the path of Excel file using ImportExcelFile method of the control
_grid.ImportExcelFile(dataDir + "book1.xlsx");

// Apply a formula to a cell that refers to a named range "Rang1"
_grid.Worksheets[0].Cells["G6"].SetCellValue("=SUM(Range1)");

// Add a new named range "MyRange" with based area A2:B5
int index = _grid.Names.Add("MyRange", "Sheet1!A2:B5");

// Apply a formula to G7 cell
_grid.Worksheets[0].Cells["G7"].SetCellValue("=SUM(MyRange)");

// Calculate the results of the formulas
_grid.RunAllFormulas();

// Save the Excel file
_grid.ExportExcelFile(dataDir + @"ouputBook1_out.xlsx");

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithGrid-GridDesktopEvents-ClickEvent.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
private void gridDesktop1_CellClick(object sender, Aspose.Cells.GridDesktop.CellEventArgs e)
{
    MessageBox.Show("Cell is clicked");
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithGrid-GridDesktopEvents.Designer-DesignerGeneratedCode.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
//
// gridDesktop1
//
this.gridDesktop1.ActiveSheetIndex = 0;
this.gridDesktop1.ActiveSheetNameFont = null;
this.gridDesktop1.CommentDisplayingFont = new System.Drawing.Font("Arial", 9F);
this.gridDesktop1.Dock = System.Windows.Forms.DockStyle.Fill;
this.gridDesktop1.IsHorizontalScrollBarVisible = true;
this.gridDesktop1.IsVerticalScrollBarVisible = true;
this.gridDesktop1.Location = new System.Drawing.Point(0, 0);
this.gridDesktop1.Name = "gridDesktop1";
this.gridDesktop1.SheetNameFont = new System.Drawing.Font("Verdana", 8F);
this.gridDesktop1.SheetTabWidth = 400;
this.gridDesktop1.Size = new System.Drawing.Size(657, 452);
this.gridDesktop1.TabIndex = 0;
this.gridDesktop1.CellClick += new Aspose.Cells.GridDesktop.CellEventHandler(this.gridDesktop1_CellClick);
//
// GridDesktopEvents
//

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithGrid-ManagingContextMenu-AddContextMenuItem.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Get the active worksheet
Worksheet sheet = grdDataEntry.GetActiveWorksheet();

// Set the total columns diaplyed in the grid
sheet.ColumnsCount = 15;

// Set the total rows displayed in the grid
sheet.RowsCount = 15;

// Define a new menu item and specify its event handler
MenuItem mi = new MenuItem("newMenuItem", new System.EventHandler(miClicked));

// Set the label
mi.Text = "New Item";

// Add the menu item to the GridDesktop's context menu
grdDataEntry.ContextMenu.MenuItems.Add(mi);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithGrid-ManagingContextMenu-EventHandler.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Event Handler for the new menu item
private void miClicked(object sender, EventArgs e)
{
    MenuItem mi = (MenuItem)sender;
    MessageBox.Show("miCliked: " + mi.Text);
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithGrid-ManagingContextMenu-HideContextMenuItem.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Get the ContextMenuManager
ContextMenuManager cmm = this.grdDataEntry.ContextMenuManager;

// Hide the Copy option in the context menu
cmm.MenuItemAvailable_Copy = false;

// Hide the InsertRow option in the context menu
cmm.MenuItemAvailable_InsertRow = false;

// Hide the Format Cell dialog box
cmm.MenuItemAvailable_FormatCells = false;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithGrid-OpeningExcelFile-OpeningCSVFile.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Specifying the path of Excel file using ImportExcelFile method of the control
gridDesktop1.ImportExcelFile(dataDir + "SampleCSV1.csv");

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithGrid-OpeningExcelFile-OpeningExcelFile.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Specifying the path of Excel file using ImportExcelFile method of the control
gridDesktop1.ImportExcelFile(dataDir + "Sample.xlsx");

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithGrid-OpeningExcelFile-OpeningFromStream.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Opening an Excel file as a stream
FileStream fs = File.OpenRead(dataDir + "Sample.xlsx");

// Loading the Excel file contents into the control from a stream
gridDesktop1.ImportExcelFile(fs);

// Closing stream
fs.Close();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithGrid-SavingExcelFile-SavingAFile.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Saving Grid contents to an Excel file
gridDesktop1.ExportExcelFile(dataDir + "book1_out.xls");

// Saving Grid contents to MS Excel 2007 Xlsx file format
gridDesktop1.ExportExcelFile(Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType) + "book1_out.xlsx", FileFormatType.Excel2007Xlsx);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithGrid-SavingExcelFile-SavingUsingStream.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Opening an Excel file as a stream
FileStream fs = File.Open(dataDir + "book1_out.xls", FileMode.Open, FileAccess.ReadWrite);

// Saving Grid contents of the control to a stream
gridDesktop1.ExportExcelFile(fs);

// Closing stream
fs.Close();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-AddingCellControlsInColumns-AddingButton.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Adding button to a specific column of the Worksheet
sheet.Columns[2].AddButton(80, 20, "Hello");

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-AddingCellControlsInColumns-AddingCheckbox.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Adding checkbox to a specific column of the Worksheet
sheet.Columns[2].AddCheckBox();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-AddingCellControlsInColumns-AddingCombobox.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Creating an array of items or values that will be added to combobox
string[] items = new string[3];
items[0] = "Aspose";
items[1] = "Aspose.Grid";
items[2] = "Aspose.Grid.Desktop";

// Adding combobox (containing items) to a specific column of the Worksheet
sheet.Columns[2].AddComboBox(items);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-AddInsertColumn-AddColumn.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Adding column to the worksheet
sheet.AddColumn();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-AddInsertColumn-InsertColumn.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Inserting column to the worksheet to the first position.
gridDesktop1.Worksheets[0].InsertColumn(0);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-AddInsertRow-AddRow.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Adding row to the worksheet
sheet.AddRow();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-AddInsertRow-InsertRow.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Inserting row to the worksheet to the first position.
gridDesktop1.Worksheets[0].InsertRow(0);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-ApplyingStyleOnRowColumn-AddingColumnStyle.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Accessing the first column of the worksheet
Aspose.Cells.GridDesktop.Data.GridColumn column = sheet.Columns[0];

// Adding sample value to sheet cell
GridCell cell = sheet.Cells["a1"];
cell.SetCellValue("Aspose");

// Getting the Style object for the column
Style style = column.GetStyle();

// Setting Style properties i.e. border, alignment color etc.
style.SetBorderLine(BorderType.Right, BorderLineType.Thick);
style.SetBorderColor(BorderType.Right, Color.Blue);
style.HAlignment = HorizontalAlignmentType.Centred;

// Setting the style of the column with the customized Style object
column.SetStyle(style);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-ApplyingStyleOnRowColumn-AddingRowStyle.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Accessing the first row of the worksheet
Aspose.Cells.GridDesktop.Data.GridRow row = sheet.Rows[0];

// Getting the Style object for the row
//Style style = row.GetStyle();

// Setting Style properties i.e. border, color, alignment, background color etc.
//style.SetBorderLine(BorderType.Right, BorderLineType.Thick);
//style.SetBorderColor(BorderType.Right, Color.Blue);
//style.HAlignment = HorizontalAlignmentType.Centred;
//style.Color = Color.Yellow;

// Setting the style of the row with the customized Style object
//row.SetStyle(style);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-FreezeUnfreezeRowsColumns-FreezeColumns.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Setting the number of frozen columns to 2
sheet.FrozenCols = 2;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-FreezeUnfreezeRowsColumns-FreezeRows.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Setting the number of frozen rows to 2
sheet.FrozenRows = 2;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-FreezeUnfreezeRowsColumns-UnFreezeColumns.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Setting the number of frozen columns to 0 for unfreezing columns
sheet.FrozenCols = 0;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-FreezeUnfreezeRowsColumns-UnFreezeRows.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Setting the number of frozen rows to 0 for unfreezing rows
sheet.FrozenRows = 0;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-ManagingControlsInColumns-AccessCheckbox.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Accessing cell control in the column and typecasting it to CheckBox
Aspose.Cells.GridDesktop.CheckBox cb = (Aspose.Cells.GridDesktop.CheckBox)sheet.Columns[2].CellControl;

if (cb != null)
{
    // Modifying the Checked property of CheckBox
    cb.Checked = true;
}
else
{
    MessageBox.Show("Please add control before accessing it.");
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-ManagingControlsInColumns-RemoveCheckbox.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Removing cell control from the column
sheet.Columns[2].RemoveCellControl();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-RemovingColumn-1.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Removing the first column of the worksheet
sheet.RemoveColumn(0);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-RemovingRow-1.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Removing the first row of the worksheet
sheet.RemoveRow(0);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-SettingColumnWidthAndRowHeight-SetColumnWidth.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Adding sample value to sheet cell
GridCell cell = sheet.Cells["a1"];
cell.SetCellValue("Welcome to Aspose!");

// Accessing the first column of the worksheet
Aspose.Cells.GridDesktop.Data.GridColumn column = sheet.Columns[0];

// Setting the width of the column
column.Width = 150;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-SettingColumnWidthAndRowHeight-SetRowHeight.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Adding sample value to sheet cells
GridCell cell = sheet.Cells["b2"];
cell.SetCellValue("1");
cell = sheet.Cells["c2"];
cell.SetCellValue("2");
cell = sheet.Cells["d2"];
cell.SetCellValue("3");
cell = sheet.Cells["e2"];
cell.SetCellValue("4");

// Accessing the first row of the worksheet
Aspose.Cells.GridDesktop.Data.GridRow row = sheet.Rows[1];

// Setting the height of the row
row.Height = 100;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-WorkingWithColumnValidations-AccessValidation.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Accessing the Validation object applied on a specific column
//Validation validation = sheet.Columns[2].Validation;

// Editing the attributes of Validation
//validation.IsRequired = true;
//validation.RegEx = "";
//validation.CustomValidation = null;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-WorkingWithColumnValidations-AddValidation.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Adding Is Required Validation to a column
sheet.Columns[2].AddValidation(true, "");

// Adding simple Regular Expression Validation to a column
sheet.Columns[4].AddValidation(true, @"\d+");

// Adding complex Regular Expression Validation to a column
sheet.Columns[6].AddValidation(true, @"\d{4}-\d{2}-\d{2}");

// Adding Custom Validation to a column
sheet.Columns[8].AddValidation(new CustomValidation());

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-WorkingWithColumnValidations-ImplementingICustomInterface.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Implementing ICustomValidation interface
public class CustomValidation : Aspose.Cells.GridDesktop.ICustomValidation
{
    // Implementing Validate method already defined in the interface
    public bool Validate(Worksheet worksheet, int row, int col, object value)
    {
        // Checking the cell's address
        if (row == 7 && col == 0)
        {
            //Checking the data type of cell's value
            double d = 0;
            try
            {
                d = (double)value;
            }
            catch
            {
                return false;
            }

            // Checking if the cell's value is greater than 100
            if (d > 100)
                return true;
        }
        return false;
    }
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithRowsandColumns-WorkingWithColumnValidations-RemoveValidation.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
//Worksheet sheet = gridDesktop1.Worksheets[0];

// Removing the Validation applied on a specific column
//sheet.Columns[2].RemoveValidation();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-AccessingWorksheets-AccessingWithActiveWorksheet.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accesing an active worksheet using its index
Worksheet sheet = gridDesktop1.Worksheets[gridDesktop1.ActiveSheetIndex];

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-AccessingWorksheets-AccessingWithGetActiveWorksheet.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accesing an active worksheet directly
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-AccessingWorksheets-AccessingWithIndex.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accesing a worksheet using its index
Worksheet sheet = gridDesktop1.Worksheets[0];

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-AccessingWorksheets-AccessingWithName.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accesing a worksheet using its name
Worksheet sheet = gridDesktop1.Worksheets["Sheet2"];

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-AddingCellControls-AddingButton.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Accessing the location of the cell that is currently in focus
CellLocation cl = sheet.GetFocusedCellLocation();

// Adding button to the Controls collection of the Worksheet
Aspose.Cells.GridDesktop.Button button = sheet.Controls.AddButton(cl.Row, cl.Column, 80, 20, "Button");

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-AddingCellControls-AddingCheckbox.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Accessing the location of the cell that is currently in focus
CellLocation cl = sheet.GetFocusedCellLocation();

// Adding checkbox to the Controls collection of the Worksheet
sheet.Controls.AddCheckBox(cl.Row, cl.Column, true);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-AddingCellControls-AddingCombobox.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Accessing the location of the cell that is currently in focus
CellLocation cl = sheet.GetFocusedCellLocation();

// Creating an array of items or values that will be added to combobox
string[] items = new string[3];
items[0] = "Aspose";
items[1] = "Aspose.Grid";
items[2] = "Aspose.Grid.Desktop";

// Adding combobox to the Controls collection of the Worksheet
sheet.Controls.AddComboBox(cl.Row, cl.Column, items);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-AddingCellControls-HandlingButton.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Implenting CellButtonClick event handler
private void gridDesktop1_CellButtonClick(object sender, CellControlEventArgs e)
{
    // Displaying the message when button is clicked
    MessageBox.Show("Button is clicked.");
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-AddingCellControls-HandlingCheckbox.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Implenting CellCheckedChanged event handler
private void gridDesktop1_CellCheckedChanged(object sender, CellControlEventArgs e)
{
    // Getting the reference of the CheckBox control whose event is triggered
    Aspose.Cells.GridDesktop.CheckBox check = (Aspose.Cells.GridDesktop.CheckBox)gridDesktop1.GetActiveWorksheet().Controls[e.Row, e.Column];

    // Displaying the message when the Checked state of CheckBox is changed
    MessageBox.Show("Current state of CheckBox is " + check.Checked);
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-AddingCellControls-HandlingCombobox.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Implenting CellSelectedIndexChanged event handler
private void gridDesktop1_CellSelectedIndexChanged(object sender, CellComboBoxEventArgs e)
{
    // Getting the reference of the ComboBox control whose event is triggered
    Aspose.Cells.GridDesktop.ComboBox combo =
         (Aspose.Cells.GridDesktop.ComboBox)gridDesktop1.GetActiveWorksheet().Controls[e.Row, e.Column];

    // Displaying the message when the Selected Index of ComboBox is changed
    MessageBox.Show(combo.Items[combo.SelectedIndex].ToString());
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-AddingCellControls-SetBackground.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Set the image.
Image image = Image.FromFile(dataDir + @"AsposeLogo.jpg");
button.Image = image;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-AddInsertWorksheet-AddingWorksheet.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Adding a worksheet to the Grid
int i = gridDesktop1.Worksheets.Add();
Worksheet sheet = gridDesktop1.Worksheets[i];

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-AddInsertWorksheet-AddingWorksheetWithName.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Adding a worksheet to the Grid with a specific name
Worksheet sheet1 = gridDesktop1.Worksheets.Add("AddWorksheetWithName");

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-AddInsertWorksheet-InsertingWorksheet.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Inserting a worksheet to Grid at first position of the worksheets collection
gridDesktop1.Worksheets.Insert(0);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-AddInsertWorksheet-InsertingWorksheetWithName.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Inserting a worksheet to Grid at first position with a specific sheet name
Worksheet sheet1 = gridDesktop1.Worksheets.Insert(0, "InsertWorksheetWithName");

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-DisplayHideScrolBars-HideScrollbars.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Hiding the vertical scroll bar
gridDesktop1.IsVerticalScrollBarVisible = false;

// Hiding the horizontal scroll bar
gridDesktop1.IsHorizontalScrollBarVisible = false;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-DisplayHideScrolBars-ShowScrollbars.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Displaying the vertical scroll bar
gridDesktop1.IsVerticalScrollBarVisible = true;

// Displaying the horizontal scroll bar
gridDesktop1.IsHorizontalScrollBarVisible = true;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ExportDataToDataTable-ExportToNewDataTable.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the reference of the worksheet that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

//Getting the total number of rows and columns inside the worksheet
int totalRows = sheet.RowsCount;
int totalCols = sheet.ColumnsCount;

// Exporting the data of the active worksheet to a new DataTable object
DataTable table = sheet.ExportDataTable(0, 0, totalRows, totalCols, false, true);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ExportDataToDataTable-ExportToSpecificDataTable.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Creating a new DataTable object
DataTable dataTable = new DataTable();

// Adding specific columns to the DataTable object
dataTable.Columns.Add("ProductName", System.Type.GetType("System.String"));
dataTable.Columns.Add("CategoryName", System.Type.GetType("System.String"));
dataTable.Columns.Add("QuantityPerUnit", System.Type.GetType("System.String"));
dataTable.Columns.Add("UnitsInStock", System.Type.GetType("System.Int32"));

// Exporting the data of the first worksheet of the Grid to the specific DataTable object
dataTable = gridDesktop1.Worksheets[0].ExportDataTable(dataTable, 0, 0, 69, 4, true);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ImportDataFromDataTable-1.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

OleDbDataAdapter adapter;
DataTable dt = new DataTable();

// Creating connection string to connect with database
string conStr = @"Provider=microsoft.jet.oledb.4.0;Data Source=" + dataDir + "dbDatabase.mdb";

// Creating Select query to fetch data from database
string query = "SELECT * FROM Products ORDER BY ProductID";
adapter = new OleDbDataAdapter(query, conStr);

// Filling DataTable using an already created OleDbDataAdapter object
adapter.Fill(dt);

// Accessing the reference of a worksheet
Worksheet sheet = gridDesktop1.Worksheets[0];

// Importing data from DataTable to the worksheet. 0,0 specifies to start importing data from the cell with first row (0 index) and first column (0 index)
sheet.ImportDataTable(dt, false, 0, 0);

// Iterating through the number of columns contained in the DataTable
for (int i = 0; i < dt.Columns.Count; i++)
{
    // Setting the column headers of the worksheet according to column names of the DataTable
    sheet.Columns[i].Header = dt.Columns[i].Caption;
}

// Setting the widths of the columns of the worksheet
sheet.Columns[0].Width = 240;
sheet.Columns[1].Width = 160;
sheet.Columns[2].Width = 160;
sheet.Columns[3].Width = 100;

// Displaying the contents of the worksheet by making it active
gridDesktop1.ActiveSheetIndex = 0;

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ManagingCellControls-AccessCheckbox.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Getting the location of the cell that is currently in focus
CellLocation cl = sheet.GetFocusedCellLocation();

// Accessing cell control and typecasting it to CheckBox
Aspose.Cells.GridDesktop.CheckBox cb = (Aspose.Cells.GridDesktop.CheckBox)sheet.Controls[cl.Row, cl.Column];

if (cb != null)
{
    // Modifying the Checked property of CheckBox
    cb.Checked = true;
}
else
{
    MessageBox.Show("Please add control before accessing it.");
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ManagingCellControls-RemoveCheckbox.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing the worksheet of the Grid that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Getting the location of the cell that is currently in focus
CellLocation cl = sheet.GetFocusedCellLocation();

// Removing the cell control by specifying the location of cell containing it
sheet.Controls.Remove(cl.Row, cl.Column);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ManagingComments-AccessingComments.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Accessing a comment added to "c3" cell (specified using its row & column number)
Aspose.Cells.GridDesktop.Data.GridComment comment1 = sheet.Comments[3, 1];

if (comment1 != null)
{
    // Modifying the text of comment
    comment1.Text = "The 1st comment.";
    MessageBox.Show("Comment has been modified");
}
else
{
    MessageBox.Show("Please add comment before accessing it.");
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ManagingComments-AddingComments.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Adding comment to "b2" cell
sheet.Comments.Add("b2", "Please write your name.");

// Adding another comment to "b4" cell using its row & column number
sheet.Comments.Add(3, 1, "Please write your email.");

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ManagingComments-RemovingComments.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

if (sheet.Comments[3, 1] != null)
{
    // Removing comment from "c3" cell
    sheet.Comments.Remove(3, 1);
    MessageBox.Show("Comment has been removed");
}
else
{
    MessageBox.Show("Please add comment before removing it.");
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ManagingHyperlinks-AccessHyperlink.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Accessing a hyperlink added to "c3,b2" cells (specified using its row & column number)
Aspose.Cells.GridDesktop.Data.GridHyperlink hyperlink1 = sheet.Hyperlinks[2, 2];
Aspose.Cells.GridDesktop.Data.GridHyperlink hyperlink2 = sheet.Hyperlinks[1, 1];

if (hyperlink1 != null && hyperlink2 != null)
{
    // Modifying the Url of the hyperlink
    hyperlink1.Url = "www.aspose.com";
    hyperlink2.Url = "www.aspose.com";
    MessageBox.Show("Hyperlinks are accessed and URL's are: \n" + hyperlink1.Url + "\n" + hyperlink2.Url);
}
else
{
    MessageBox.Show("No hyperlinks are found in sheet. Add hyperlinks first.");
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ManagingHyperlinks-AddHyperlink.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Accessing cell of the worksheet
GridCell cell = sheet.Cells["b2"];
GridCell cell2 = sheet.Cells["c3"];

// Modifying the width of the column of the cell
sheet.Columns[cell.Column].Width = 160;
sheet.Columns[cell2.Column].Width = 160;

// Adding a value to the cell
cell.Value = "Aspose Home";
cell2.Value = "Aspose Home";

// Adding a hyperlink to the worksheet containing cell name and the hyperlink URL with which the cell will be linked
sheet.Hyperlinks.Add("b2", "www.aspose.com");
sheet.Hyperlinks.Add("c3", "www.aspose.com");

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ManagingHyperlinks-RemoveHyperlink.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

if (sheet.Hyperlinks.Count > 0)
{
    // Removing hyperlink from "c3" cell
    sheet.Hyperlinks.Remove(2, 2);
    MessageBox.Show("Hyperlink in C3 cell has been removed.");
}
else
{
    MessageBox.Show("No hyperlinks are found in sheet to remove. Add hyperlinks first.");
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ManagingPictures-AccessAndModifyPicture.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Accessing a picture added to "c3" cell (specified using its row & column number)
Aspose.Cells.GridDesktop.Data.GridPicture picture1 = sheet.Pictures[1];

// Modifying the image
picture1.Image = Image.FromFile(dataDir + "Aspose.Grid.jpg");

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ManagingPictures-AddingPictures.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Adding picture to "b2" cell from file
sheet.Pictures.Add("b2", dataDir + "AsposeGrid.jpg");

// Creating a stream contain picture
FileStream fs = new FileStream(dataDir + "AsposeLogo.jpg", FileMode.Open);

try
{
    // Adding picture to "b3" cell from stream
    sheet.Pictures.Add(2, 1, fs);
}
catch (Exception ex)
{
    MessageBox.Show(ex.Message);
}
finally
{
    // Closing stream
    fs.Close();
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ManagingPictures-RemovePicture.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Removing picture from "c3" cell
sheet.Pictures.Remove(2, 2);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-MovingWorksheets-1.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Move the 2nd worksheet to 4th position.
gridDesktop1.Worksheets.MoveTo(1, 3);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ReadingDataValidations-1.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Import sample excel file in GridDesktop
gridDesktop1.ImportExcelFile(dataDir + "ValidationTesting.xlsx");

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-RemoveWorksheet-RemoveUsingIndex.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Removing a worksheet using its index
gridDesktop1.Worksheets.Remove(0);

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-RemoveWorksheet-RemoveUsingName.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Removing a worksheet using its index
gridDesktop1.Worksheets.RemoveAt("Sheet3");

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-RenameWorksheet-1.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accesing an active worksheet directly
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Renaming a worksheet
sheet.Name = "Renamed Sheet";

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-SortData-AscendingSort.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing a worksheet that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Creating SortRange object
SortRange sr = new SortRange(sheet, range.StartRow,
             range.StartColumn, range.EndRow - range.StartRow + 1,
             range.EndColumn - range.StartColumn + 1,
             SortOrientation.SortTopToBottom, true);

// Sorting data in the specified column in ascending order
sr.Sort(range.StartColumn, Aspose.Cells.GridDesktop.SortOrder.Ascending);

// Redrawing cells of the Grid
gridDesktop1.Invalidate();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-SortData-CheckingCellRange.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Creating global variable of CellRange
CellRange range;

private void gridDesktop1_SelectedCellRangeChanged(object sender, Aspose.Cells.GridDesktop.CellRangeEventArgs e)
{
    // Checking if the range of cells is not empty
    if ((e.CellRange.EndColumn - e.CellRange.StartColumn > 0) ||
                          (e.CellRange.EndRow - e.CellRange.StartRow > 0))
    {
        // Assigning the updated CellRange to global variable
        range = e.CellRange;
    }
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-SortData-DescendingSort.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing a worksheet that is currently active
Worksheet sheet = gridDesktop1.GetActiveWorksheet();

// Creating SortRange object
SortRange sr = new SortRange(sheet, range.StartRow, range.StartColumn,
             range.EndRow - range.StartRow + 1,
             range.EndColumn - range.StartColumn + 1,
             SortOrientation.SortTopToBottom, true);

// Sorting data in the specified column in descending order
sr.Sort(range.StartColumn, Aspose.Cells.GridDesktop.SortOrder.Descending);

// Redrawing cells of the Grid
gridDesktop1.Invalidate();

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ValidationInWorksheets-AccessingValidation.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

if (sheet.Validations.Count > 0)
{
    // Accessing the Validation object applied on "a8" cell
    Aspose.Cells.GridDesktop.Data.GridValidation validation = sheet.Validations[7, 0];

    // Editing the attributes of Validation
    validation.IsRequired = true;
    validation.RegEx = "";
    validation.CustomValidation = null;
    MessageBox.Show("Validation has been edited after accessing it.");
}
else
{
    MessageBox.Show("No validations found to access.");
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ValidationInWorksheets-AddingValidation.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];

// Adding values to specific cells of the worksheet
sheet.Cells["a2"].Value = "Required";
sheet.Cells["a4"].Value = "100";
sheet.Cells["a6"].Value = "2006-07-21";
sheet.Cells["a8"].Value = "101.2";

// Adding Is Required Validation to a cell
sheet.Validations.Add("a2", true, "");

// Adding simple Regular Expression Validation to a cell
sheet.Validations.Add("a4", true, @"\d+");

// Adding complex Regular Expression Validation to a cell
sheet.Validations.Add("a6", true, @"\d{4}-\d{2}-\d{2}");

// Adding Custom Validation to a cell
sheet.Validations.Add("a8", new CustomValidation());

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ValidationInWorksheets-ImplementingICustomInterface.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Implementing ICustomValidation interface
public class CustomValidation : Aspose.Cells.GridDesktop.ICustomValidation
{
    // Implementing Validate method already defined in the interface
    public bool Validate(Worksheet worksheet, int row, int col, object value)
    {
        // Checking the cell's address
        if (row == 7 && col == 0)
        {
            //Checking the data type of cell's value
            double d = 0;
            try
            {
                d = (double)value;
            }
            catch
            {
                return false;
            }

            // Checking if the cell's value is greater than 100
            if (d > 100)
                return true;
        }
        return false;
    }
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ValidationInWorksheets-RemoveValidation.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Accessing first worksheet of the Grid
Worksheet sheet = gridDesktop1.Worksheets[0];
if (sheet.Validations.Count > 0)
{
    // Removing the Validation object applied on "a6" cell
    sheet.Validations.RemoveAt(1);
    MessageBox.Show("Validation has been removed.");
}
else
{
    MessageBox.Show("No validations found to remove.");
}

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ZoomingInOut-LoadEvent.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Importing the template Excel file to GridDesktop
gridDesktop1.ImportExcelFile(dataDir + "EmployeeSales.xlsx");

// Set the default value of the TrackBar control
trackBar1.Value = 100;

// Set the custom label's text to the trackbar's value for display
label1.Text = trackBar1.Value.ToString() + "%";

## Examples.GridDesktop-CSharp-GridDesktop.Examples-WorkingWithWorksheet-ZoomingInOut-ZoomInOut.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Set the Zoom factor of the active worksheet to the Trackbar's value
gridDesktop1.Worksheets[gridDesktop1.GetActiveWorksheet().Index].Zoom = trackBar1.Value;

// Show the percentage value of the specified Zoom
label1.Text = trackBar1.Value.ToString() + "%";

## Examples.GridDesktop-CSharp-UsingGridDesktopInWpf-MainWindow.xaml-UsingGridDesktopInWpf.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

using (var stream = new MemoryStream(System.IO.File.ReadAllBytes(dataDir + "SampleBook.xlsx")))
{
    this.grid.ImportExcelFile(stream);
    this.grid.ExportExcelFile(dataDir + "SampleOutput_out.xlsx");
}

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-Articles-CopyAndPasteRows-1.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Indicates whether to copy/paste based on clipboard, so that it can copy/paste with MS-EXCEL.
         ' It will only copy/paste cell value and will not copy any other setting of the cell like format, border style and so on.
         ' The default value is false.
gridDesktop1.EnableClipboardCopyPaste = True

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-Articles-DataBindingFeature-AddingNamespaceToTheTop.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Adding namespace to the top of code
Imports System.Data.OleDb

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-Articles-DataBindingFeature-AddingRows.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Adding new row to the worksheet
gridDesktop1.GetActiveWorksheet().AddRow()

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-Articles-DataBindingFeature-ApplyCustomStyle.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Iterating through each column of the worksheet
For i As Integer = 0 To sheet.ColumnsCount - 1
	' Getting the style object of each column
	Dim style As Style = sheet.Columns(i).GetStyle()

	' Setting the color of each column to Yellow
	style.Color = Color.Yellow

	' Setting the Horizontal Alignment of each column to Centered
	style.HAlignment = HorizontalAlignmentType.Centred

	' Setting the style of column to the updated one
	sheet.Columns(i).SetStyle(style)
Next

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-Articles-DataBindingFeature-BindWorksheet.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Binding the Worksheet to Products table by calling its DataBind method
sheet.DataBind(ds.Tables("Products"), "")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-Articles-DataBindingFeature-CustomizingStyle.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Customizing the widths of columns of the worksheet
sheet.Columns(0).Width = 70
sheet.Columns(1).Width = 120
sheet.Columns(2).Width = 80

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-Articles-DataBindingFeature-DeclareGlobalVariable.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Declaring global variable
Private adapter As OleDbDataAdapter
Private cb As OleDbCommandBuilder
Private ds As DataSet

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-Articles-DataBindingFeature-DeletingRows.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Getting the index of the focused row
Dim focusedRowIndex As Integer = gridDesktop1.GetActiveWorksheet().GetFocusedCell().Row

' Removing the focused row fro the worksheet
gridDesktop1.GetActiveWorksheet().RemoveRow(focusedRowIndex)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-Articles-DataBindingFeature-FillDataSet.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
Private Sub DataBindingFeatures_Load(sender As Object, e As EventArgs)
	' The path to the documents directory.
	Dim dataDir As String = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)

	' Creating Select query to fetch data from database
	Dim query As String = "SELECT * FROM Products ORDER BY ProductID"

	' Creating connection string to connect with database
	Dim conStr As String = "Provider=microsoft.jet.oledb.4.0;Data Source=" & dataDir & "dbDatabase.mdb"

	' Creating OleDbDataAdapter object that will be responsible to open/close connections with database, fetch data and fill DataSet with data
	adapter = New OleDbDataAdapter(query, conStr)

	' Setting MissingSchemaAction to AddWithKey for getting necesssary primary key information of the tables
	adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey

	' Creating OleDbCommandBuilder object to create insert/delete SQL commmands
          ' automatically that are used by OleDbDatAdapter object for updating
          ' changes to the database
	cb = New OleDbCommandBuilder(adapter)

	' Creating DataSet object
	ds = New DataSet()

	' Filling DataSet with data fetched by OleDbDataAdapter object
	adapter.Fill(ds, "Products")
End Sub

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-Articles-DataBindingFeature-SavingChangesToDatabase.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Updating the database according to worksheet data source
adapter.Update(DirectCast(sheet.DataSource, DataTable))

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-Articles-DataBindingFeature-SettingColumnHeader.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Iterating through all columns of the Products table in DataSet
For i As Integer = 0 To ds.Tables("Products").Columns.Count - 1
	' Setting the column header of each column to the column caption of Products table
	sheet.Columns(i).Header = ds.Tables("Products").Columns(i).Caption
Next

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-AccessAndModifyCells-UsingSetCellValue.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Accessing the cell using its name
Dim cell As GridCell = sheet.Cells("A1")

' Setting the value of "A1" cell
cell.SetCellValue(DateTime.Now)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-AccessAndModifyCells-UsingValue.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Accessing the cell using its name
Dim cell As GridCell = sheet.Cells("A1")

' Accessing & modifying the value of "A1" cell
cell.Value = DateTime.Now

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-AccessingCells-AccessByIndices.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Accessing a cell using its row and column indices
Dim cell As GridCell = sheet.Cells(1, 1)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-AccessingCells-AccessByName.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Accessing a cell using its name
Dim cell As GridCell = sheet.Cells("A1")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-AccessingCells-AccessFocusedCell.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Accessing a cell that is currently in focus
Dim cell As GridCell = sheet.GetFocusedCell()

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-AddCellProtection-1.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Make sure sheet has been protected
sheet.[Protected] = True

' Choose a cell range
Dim range As CellRange = sheet.CreateRange("A1", "B1")

' Set protected range area on Worksheet
sheet.SetProtected(range, True)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-AddingCellFormulas-1.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Adding numeric values to "B2" & "B3" cells
sheet.Cells("B2").SetCellValue(3)
sheet.Cells("B3").SetCellValue(4)

' Adding a formula to "B4" cell multiplying the values of "B2" & "B3" cells
sheet.Cells("B4").SetCellValue("=B2 * B3")

' Running all formulas in the Grid
gridDesktop1.RunAllFormulas()

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-ApplyStyleOnCells-ApplyStyle.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Accessing "A1" cell in the worksheet
Dim cell As GridCell = sheet.Cells("A1")

' Adding a value to "A1" cell
cell.Value = "Hello"

' Getting the Style object for the cell
Dim style As Style = cell.GetStyle()

' Setting Style properties like border, alignment etc.
style.SetBorderLine(BorderType.Right, BorderLineType.Thick)
style.SetBorderColor(BorderType.Right, Color.Blue)
style.HAlignment = HorizontalAlignmentType.Centred
style.Color = Color.Yellow
style.CellLocked = True
style.VAlignment = VerticalAlignmentType.Top

' Setting the style of the cell with the customized Style object
cell.SetStyle(style)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-ApplyStyleOnCells-SetNumberFormat.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Aspose.Cells.GridDesktop.Worksheet = gridDesktop1.Worksheets(0)

' Creating a standard Font object that will be applied on cells
Dim font As New System.Drawing.Font("MS Serif", 9F, FontStyle.Bold)

' Accessing and adding values to cells
Dim cell As Aspose.Cells.GridDesktop.GridCell = sheet.Cells("B2")
cell.Value = "General"
cell.SetFont(font)
cell = sheet.Cells("C2")
cell.Value = 1000
cell = sheet.Cells("D2")
cell.Value = "Text"
cell = sheet.Cells("B4")
cell.Value = "Number"
cell.SetFont(font)

'Accessing the Style object of "C4" cell and setting its number format to index No.2
cell = sheet.Cells("C4")
cell.Value = 20.0
Dim style As Aspose.Cells.GridDesktop.Style = cell.GetStyle()

' For applying "0.00" format
style.NumberFormat = 2
cell.SetStyle(style)

' Accessing the Style object of "D4" cell and setting its number format to index No.3
cell = sheet.Cells("D4")
cell.Value = -2000.0
style = cell.GetStyle()

' For "#,##0" format
style.NumberFormat = 3
cell.SetStyle(style)

' Accessing a cell and setting its value & font
cell = sheet.Cells("B6")
cell.Value = "Currency"
cell.SetFont(font)

' Accessing the Style object of "C6" cell and setting its number format to index No.6
cell = sheet.Cells("C6")
cell.Value = -120.0
style = cell.GetStyle()

' For Applying "\"$\"#,##0_);[Red](\"$\"#,##0)" expression
style.NumberFormat = 6
cell.SetStyle(style)

' Accessing the Style object of "D6" cell and setting its number format to index No.41
cell = sheet.Cells("D6")
cell.Value = 2400
style = cell.GetStyle()

' For applying "_(\"$\"* #,##0_);_(\"$\"* (#,##0);_(\"$\"* \"-\"_);_(@_)" expression
style.NumberFormat = 41
cell.SetStyle(style)

' Accessing a cell and setting its value & font
cell = sheet.Cells("B8")
cell.Value = "Percent"
cell.SetFont(font)

' Accessing the Style object of "C8" cell and setting its number format to index No.9
cell = sheet.Cells("C8")
cell.Value = 0.32
style = cell.GetStyle()
style.NumberFormat = 9
cell.SetStyle(style)

' Accessing the Style object of "D8" cell and setting its number format to index No.10
cell = sheet.Cells("D8")
cell.Value = 0.64
style = cell.GetStyle()

' For applying "0.00%" format
style.NumberFormat = 10
cell.SetStyle(style)

' Accessing a cell and setting its value & font
cell = sheet.Cells("B10")
cell.Value = "Scientific"
cell.SetFont(font)

' Accessing the Style object of "C10" cell and setting its number format to index No.11
cell = sheet.Cells("C10")
cell.Value = 0.51
style = cell.GetStyle()

' For applying "0.00E+00" format
style.NumberFormat = 11
cell.SetStyle(style)

' Accessing the Style object of "D10" cell and setting its number format to index No.48
cell = sheet.Cells("D10")
cell.Value = 32000
style = cell.GetStyle()
style.NumberFormat = 48
cell.SetStyle(style)

' Accessing a cell and setting its value & font
cell = sheet.Cells("B12")
cell.Value = "DateTime"
cell.SetFont(font)

' Accessing the Style object of "C12" cell and setting a custom number format for it
cell = sheet.Cells("C12")
cell.Value = DateTime.Now
style = cell.GetStyle()
style.[Custom] = "yyyy-MM-dd"
cell.SetStyle(style)

         ' Accessing the Style object of "D12" cell and setting its number format to Index No.15
cell = sheet.Cells("D12")
sheet.Columns(cell.Column).Width = 100
cell.Value = DateTime.Now
         style = cell.GetStyle()

         ' For "d-mmm-yy" format
         style.NumberFormat = 15
         cell.SetStyle(style)

' Accessing the Style object of "C13" cell and setting a custom number format for it
cell = sheet.Cells("C13")
cell.Value = DateTime.Now
style = cell.GetStyle()
style.[Custom] = "hh:mm:ss"
cell.SetStyle(style)

' Accessing the Style object of "D13" cell and setting its number format to index No.18
cell = sheet.Cells("D13")
cell.Value = DateTime.Now
style = cell.GetStyle()

' For applying "h:mm AM/PM" format
style.NumberFormat = 18
cell.SetStyle(style)

' Accessing the Style object of "C14" cell and setting a custom number format for it
cell = sheet.Cells("C14")
sheet.Columns(cell.Column).Width = 160
cell.Value = DateTime.Now
style = cell.GetStyle()
style.[Custom] = "yyyy-MM-dd hh:mm:ss"
cell.SetStyle(style)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-ApplyStyleOnCells-SummingUp.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Aspose.Cells.GridDesktop.Worksheet = gridDesktop1.Worksheets(0)

         ' Accessing "B2" cell and setting its value
Dim cell As Aspose.Cells.GridDesktop.GridCell = sheet.Cells("B2")
cell.Value = "None"

' Accessing "D4" cell and setting its value & column width
cell = sheet.Cells("D4")
cell.Value = "out line Borders"
sheet.Columns(cell.Column).Width = 120

' Accessing the Style object of "D4" cell and drawing thin red borders around it
Dim style As Aspose.Cells.GridDesktop.Style = cell.GetStyle()
style.SetBorderLine(BorderType.Left, BorderLineType.Thin)
style.SetBorderColor(BorderType.Left, System.Drawing.Color.Red)
style.SetBorderLine(BorderType.Right, BorderLineType.Thin)
style.SetBorderColor(BorderType.Right, System.Drawing.Color.Red)
style.SetBorderLine(BorderType.Top, BorderLineType.Thin)
style.SetBorderColor(BorderType.Top, System.Drawing.Color.Red)
style.SetBorderLine(BorderType.Bottom, BorderLineType.Thin)
style.SetBorderColor(BorderType.Bottom, System.Drawing.Color.Red)
cell.SetStyle(style)

' Accessing "B6" cell and setting its value, row height & column width
cell = sheet.Cells("B6")
cell.Value = "Border with" & vbLf & "different colors"
sheet.Rows(cell.Row).Height = 40
sheet.Columns(cell.Column).Width = 110

' Accessing the Style object of "B6" cell and drawing thin borders of different colors around it
style = cell.GetStyle()
style.SetBorderLine(BorderType.Left, BorderLineType.Thin)
style.SetBorderColor(BorderType.Left, System.Drawing.Color.Red)
style.SetBorderLine(BorderType.Right, BorderLineType.Thin)
style.SetBorderColor(BorderType.Right, System.Drawing.Color.Green)
style.SetBorderLine(BorderType.Top, BorderLineType.Thin)
style.SetBorderColor(BorderType.Top, System.Drawing.Color.Yellow)
style.SetBorderLine(BorderType.Bottom, BorderLineType.Thin)
style.SetBorderColor(BorderType.Bottom, System.Drawing.Color.Blue)
cell.SetStyle(style)

' Accessing "D7" cell and setting its value, row height & column width
cell = sheet.Cells("D7")
cell.Value = "Border with" & vbLf & "different styles"
sheet.Rows(cell.Row).Height = 40
sheet.Columns(cell.Column).Width = 110

' Accessing the Style object of "D7" cell and drawing different borders of different colors around it
style = cell.GetStyle()
style.SetBorderLine(BorderType.Left, BorderLineType.Thin)
style.SetBorderColor(BorderType.Left, System.Drawing.Color.Red)
style.SetBorderLine(BorderType.Right, BorderLineType.Medium)
style.SetBorderColor(BorderType.Right, System.Drawing.Color.Red)
style.SetBorderLine(BorderType.Top, BorderLineType.Dashed)
style.SetBorderColor(BorderType.Top, System.Drawing.Color.Yellow)
style.SetBorderLine(BorderType.Bottom, BorderLineType.Dotted)
style.SetBorderColor(BorderType.Bottom, System.Drawing.Color.Black)
cell.SetStyle(style)

' Accessing "B8" cell and drawing a single red border to its bottom side
cell = sheet.Cells("B8")
cell.Value = "Only one border"
style = cell.GetStyle()
style.SetBorderLine(BorderType.Bottom, BorderLineType.MediumDashDotted)
style.SetBorderColor(BorderType.Bottom, System.Drawing.Color.Red)
cell.SetStyle(style)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-ChangeFontColorOfCell-1.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Accessing a cell using its name
Dim cell As GridCell = sheet.Cells("A1")

' Creating a customized Font object
Dim font As New Font("Arial", 10, FontStyle.Bold)

' Setting the font of the cell to the customized Font object
cell.SetFont(font)

' Setting the font color of the cell to Blue
cell.SetFontColor(Color.Blue)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-FilteringData-AutoFilter.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Enable GridDesktop's auto-filter.
gridDesktop1.Worksheets(0).RowFilter.EnableAutoFilter = True

' Set the header row.
gridDesktop1.Worksheets(0).RowFilter.HeaderRow = 0

' Set the starting row.
gridDesktop1.Worksheets(0).RowFilter.StartRow = 1

' Set the ending row.
gridDesktop1.Worksheets(0).RowFilter.EndRow = 101

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-FilteringData-CustomFilter.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Set the starting row.
gridDesktop1.Worksheets(0).RowFilter.StartRow = 1

' Set the ending row.
gridDesktop1.Worksheets(0).RowFilter.EndRow = 101

' Get the RowFilter object for the first worksheet.
Dim rowFilter As RowFilterSettings = gridDesktop1.Worksheets(0).RowFilter

' Filter Rows.
rowFilter.FilterRows(0, "Customer 1")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-FormattingCellRange-1.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Setting sample values
Dim cell As GridCell = sheet.Cells("b7")
cell.SetCellValue("1")
cell = sheet.Cells("c7")
cell.SetCellValue("2")
cell = sheet.Cells("d7")
cell.SetCellValue("3")
cell = sheet.Cells("e7")
cell.SetCellValue("4")

' Creating a CellRange object starting from "B7" to "E7"
Dim range As New CellRange(6, 1, 6, 4)

' Accessing and setting Style attributes
Dim style As New Style(Me.gridDesktop1)
style.Color = Color.Yellow

' Applying Style object on the range of cells
sheet.SetStyle(range, style)

' Creating a customized Font object
Dim font As New Font("Courier New", 12F)

' Setting the font of range of cells to the customized Font object
sheet.SetFont(range, font)

' Setting the font color of range of cells to Red
sheet.SetFontColor(range, Color.Red)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-MergingAndUnMergingCells-MergeCells.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Creating a CellRange object starting from "B4" to "C6"
Dim range As New CellRange("B4", "C6")

' Merging a range of cells
sheet.Merge(range)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-MergingAndUnMergingCells-UnMergeCells.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Accessing the merged cell that is currently in focus
Dim cell As GridCell = sheet.GetFocusedCell()

' Unmerging a cell using its location
sheet.Unmerge(cell.Location)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-UndoRedoFeature-Redo.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Create the UndoManager object
Dim um As UndoManager = gridDesktop1.UndoManager

' Perform Redo operation
um.Redo()

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-UndoRedoFeature-Undo.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Enable the Undo operation
gridDesktop1.EnableUndo = True

' Create the UndoManager object
Dim um As UndoManager = gridDesktop1.UndoManager

' Perform Undo operation
um.Undo()

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-UsingFormatPainter-EndUse.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Ending format painter to stop painting
gridDesktop1.EndFormatPainter()

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-UsingFormatPainter-UseAlways.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Starting format painter to keep painting forever
gridDesktop1.StartFormatPainter(True)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-UsingFormatPainter-UseOnce.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Starting format painter to paint once
gridDesktop1.StartFormatPainter(False)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithCells-UsingNamedRanges-1.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Clear the Worsheets first
_grid.Clear()

' The path to the documents directory.
Dim dataDir As String = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)

' Specifying the path of Excel file using ImportExcelFile method of the control
_grid.ImportExcelFile(dataDir & "book1.xlsx")

' Apply a formula to a cell that refers to a named range "Rang1"
_grid.Worksheets(0).Cells("G6").SetCellValue("=SUM(Range1)")

' Add a new named range "MyRange" with based area A2:B5
Dim index As Integer = _grid.Names.Add("MyRange", "Sheet1!A2:B5")

' Apply a formula to G7 cell
_grid.Worksheets(0).Cells("G7").SetCellValue("=SUM(MyRange)")

' Calculate the results of the formulas
_grid.RunAllFormulas()

' Save the Excel file
_grid.ExportExcelFile(dataDir & "ouputBook1_out.xlsx")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithGrid-GridDesktopEvents-ClickEvent.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
Private Sub gridDesktop1_CellClick(sender As Object, e As Aspose.Cells.GridDesktop.CellEventArgs)
	MessageBox.Show("Cell is clicked")
End Sub

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithGrid-GridDesktopEvents.Designer-DesignerGeneratedCode.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
'
' gridDesktop1
'
Me.gridDesktop1.ActiveSheetIndex = 0
Me.gridDesktop1.ActiveSheetNameFont = Nothing
Me.gridDesktop1.CommentDisplayingFont = New System.Drawing.Font("Arial", 9F)
Me.gridDesktop1.Dock = System.Windows.Forms.DockStyle.Fill
Me.gridDesktop1.IsHorizontalScrollBarVisible = True
Me.gridDesktop1.IsVerticalScrollBarVisible = True
Me.gridDesktop1.Location = New System.Drawing.Point(0, 0)
Me.gridDesktop1.Name = "gridDesktop1"
Me.gridDesktop1.SheetNameFont = New System.Drawing.Font("Verdana", 8F)
Me.gridDesktop1.SheetTabWidth = 400
Me.gridDesktop1.Size = New System.Drawing.Size(657, 452)
Me.gridDesktop1.TabIndex = 0
AddHandler Me.gridDesktop1.CellClick, New Aspose.Cells.GridDesktop.CellEventHandler(AddressOf Me.gridDesktop1_CellClick)
'
' GridDesktopEvents
'

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithGrid-ManagingContextMenu-AddContextMenuItem.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Get the active worksheet
Dim sheet As Worksheet = grdDataEntry.GetActiveWorksheet()

' Set the total columns diaplyed in the grid
sheet.ColumnsCount = 15

' Set the total rows displayed in the grid
sheet.RowsCount = 15

' Define a new menu item and specify its event handler
Dim mi As New MenuItem("newMenuItem", New System.EventHandler(AddressOf miClicked))

' Set the label
mi.Text = "New Item"

' Add the menu item to the GridDesktop's context menu
grdDataEntry.ContextMenu.MenuItems.Add(mi)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithGrid-ManagingContextMenu-EventHandler.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Event Handler for the new menu item
Private Sub miClicked(sender As Object, e As EventArgs)
	Dim mi As MenuItem = DirectCast(sender, MenuItem)
	MessageBox.Show("miCliked: " & mi.Text)
End Sub

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithGrid-ManagingContextMenu-HideContextMenuItem.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Get the ContextMenuManager
Dim cmm As ContextMenuManager = Me.grdDataEntry.ContextMenuManager

' Hide the Copy option in the context menu
cmm.MenuItemAvailable_Copy = False

' Hide the InsertRow option in the context menu
cmm.MenuItemAvailable_InsertRow = False

' Hide the Format Cell dialog box
cmm.MenuItemAvailable_FormatCells = False

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithGrid-OpeningExcelFile-OpeningCSVFile.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' The path to the documents directory.
Dim dataDir As String = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)

' Specifying the path of Excel file using ImportExcelFile method of the control
gridDesktop1.ImportExcelFile(dataDir & "SampleCSV1.csv")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithGrid-OpeningExcelFile-OpeningExcelFile.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' The path to the documents directory.
Dim dataDir As String = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)

' Specifying the path of Excel file using ImportExcelFile method of the control
gridDesktop1.ImportExcelFile(dataDir & "Sample.xlsx")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithGrid-OpeningExcelFile-OpeningFromStream.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' The path to the documents directory.
Dim dataDir As String = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)

' Opening an Excel file as a stream
Dim fs As FileStream = File.OpenRead(dataDir & "Sample.xlsx")

' Loading the Excel file contents into the control from a stream
gridDesktop1.ImportExcelFile(fs)

' Closing stream
fs.Close()

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithGrid-SavingExcelFile-SavingAFile.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' The path to the documents directory.
Dim dataDir As String = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)

' Saving Grid contents to an Excel file
gridDesktop1.ExportExcelFile(dataDir & "book1_out.xls")

' Saving Grid contents to MS Excel 2007 Xlsx file format
gridDesktop1.ExportExcelFile(Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType) & "book1_out.xlsx", FileFormatType.Excel2007Xlsx)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithGrid-SavingExcelFile-SavingUsingStream.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' The path to the documents directory.
Dim dataDir As String = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)

' Opening an Excel file as a stream
Dim fs As FileStream = File.Open(dataDir & "book1_out.xls", FileMode.Open, FileAccess.ReadWrite)

' Saving Grid contents of the control to a stream
gridDesktop1.ExportExcelFile(fs)

' Closing stream
fs.Close()

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-AddingCellControlsInColumns-AddingButton.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Adding button to a specific column of the Worksheet
sheet.Columns(2).AddButton(80, 20, "Hello")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-AddingCellControlsInColumns-AddingCheckbox.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Adding checkbox to a specific column of the Worksheet
sheet.Columns(2).AddCheckBox()

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-AddingCellControlsInColumns-AddingCombobox.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Creating an array of items or values that will be added to combobox
Dim items As String() = New String(2) {}
items(0) = "Aspose"
items(1) = "Aspose.Grid"
items(2) = "Aspose.Grid.Desktop"

' Adding combobox (containing items) to a specific column of the Worksheet
sheet.Columns(2).AddComboBox(items)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-AddInsertColumn-AddColumn.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Adding column to the worksheet
sheet.AddColumn()

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-AddInsertColumn-InsertColumn.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Inserting column to the worksheet to the first position.
gridDesktop1.Worksheets(0).InsertColumn(0)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-AddInsertRow-AddRow.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Adding row to the worksheet
sheet.AddRow()

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-AddInsertRow-InsertRow.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Inserting row to the worksheet to the first position.
gridDesktop1.Worksheets(0).InsertRow(0)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-ApplyingStyleOnRowColumn-AddingColumnStyle.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Accessing the first column of the worksheet
Dim column As Aspose.Cells.GridDesktop.Data.GridColumn = sheet.Columns(0)

' Adding sample value to sheet cell
Dim cell As GridCell = sheet.Cells("a1")
cell.SetCellValue("Aspose")

' Getting the Style object for the column
Dim style As Style = column.GetStyle()

' Setting Style properties i.e. border, alignment color etc.
style.SetBorderLine(BorderType.Right, BorderLineType.Thick)
style.SetBorderColor(BorderType.Right, Color.Blue)
style.HAlignment = HorizontalAlignmentType.Centred

' Setting the style of the column with the customized Style object
column.SetStyle(style)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-ApplyingStyleOnRowColumn-AddingRowStyle.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Accessing the first row of the worksheet
Dim row As Aspose.Cells.GridDesktop.Data.GridRow = sheet.Rows(0)

' Getting the Style object for the row
         'Dim style As Style = row.GetStyle()

' Setting Style properties i.e. border, color, alignment, background color etc.
         'style.SetBorderLine(BorderType.Right, BorderLineType.Thick)
         'style.SetBorderColor(BorderType.Right, Color.Blue)
         'style.HAlignment = HorizontalAlignmentType.Centred
         'style.Color = Color.Yellow

' Setting the style of the row with the customized Style object
         'row.SetStyle(style)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-FreezeUnfreezeRowsColumns-FreezeColumns.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Setting the number of frozen columns to 2
sheet.FrozenCols = 2

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-FreezeUnfreezeRowsColumns-FreezeRows.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Setting the number of frozen rows to 2
sheet.FrozenRows = 2

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-FreezeUnfreezeRowsColumns-UnFreezeColumns.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Setting the number of frozen columns to 0 for unfreezing columns
sheet.FrozenCols = 0

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-FreezeUnfreezeRowsColumns-UnFreezeRows.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Setting the number of frozen rows to 0 for unfreezing rows
sheet.FrozenRows = 0

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-ManagingControlsInColumns-AccessCheckbox.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Accessing cell control in the column and typecasting it to CheckBox
Dim cb As Aspose.Cells.GridDesktop.CheckBox = DirectCast(sheet.Columns(2).CellControl, Aspose.Cells.GridDesktop.CheckBox)

If cb IsNot Nothing Then
	' Modifying the Checked property of CheckBox
	cb.Checked = True
Else
	MessageBox.Show("Please add control before accessing it.")
End If

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-ManagingControlsInColumns-RemoveCheckbox.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Removing cell control from the column
sheet.Columns(2).RemoveCellControl()

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-RemovingColumn-1.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Removing the first column of the worksheet
sheet.RemoveColumn(0)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-RemovingRow-1.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Removing the first row of the worksheet
sheet.RemoveRow(0)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-SettingColumnWidthAndRowHeight-SetColumnWidth.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Adding sample value to sheet cell
Dim cell As GridCell = sheet.Cells("a1")
cell.SetCellValue("Welcome to Aspose!")

' Accessing the first column of the worksheet
Dim column As Aspose.Cells.GridDesktop.Data.GridColumn = sheet.Columns(0)

' Setting the width of the column
column.Width = 150

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-SettingColumnWidthAndRowHeight-SetRowHeight.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Adding sample value to sheet cells
Dim cell As GridCell = sheet.Cells("b2")
cell.SetCellValue("1")
cell = sheet.Cells("c2")
cell.SetCellValue("2")
cell = sheet.Cells("d2")
cell.SetCellValue("3")
cell = sheet.Cells("e2")
cell.SetCellValue("4")

' Accessing the first row of the worksheet
Dim row As Aspose.Cells.GridDesktop.Data.GridRow = sheet.Rows(1)

' Setting the height of the row
row.Height = 100

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-WorkingWithColumnValidations-AccessValidation.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Accessing the Validation object applied on a specific column
'Validation validation = sheet.Columns[2].Validation;

' Editing the attributes of Validation
'validation.IsRequired = true;
'validation.RegEx = "";
'validation.CustomValidation = null;

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-WorkingWithColumnValidations-AddValidation.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Adding Is Required Validation to a column
sheet.Columns(2).AddValidation(True, "")

' Adding simple Regular Expression Validation to a column
sheet.Columns(4).AddValidation(True, "\d+")

' Adding complex Regular Expression Validation to a column
sheet.Columns(6).AddValidation(True, "\d{4}-\d{2}-\d{2}")

' Adding Custom Validation to a column
sheet.Columns(8).AddValidation(New CustomValidation())

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-WorkingWithColumnValidations-ImplementingICustomInterface.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Implementing ICustomValidation interface
Public Class CustomValidation
	Implements Aspose.Cells.GridDesktop.ICustomValidation
	' Implementing Validate method already defined in the interface
	Public Function Validate(worksheet As Worksheet, row As Integer, col As Integer, value As Object) As Boolean Implements ICustomValidation.Validate
		' Checking the cell's address
		If row = 7 AndAlso col = 0 Then
			'Checking the data type of cell's value
			Dim d As Double = 0
			Try
				d = CDbl(value)
			Catch
				Return False
			End Try

			' Checking if the cell's value is greater than 100
			If d > 100 Then
				Return True
			End If
		End If
		Return False
	End Function
End Class

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithRowsandColumns-WorkingWithColumnValidations-RemoveValidation.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
'Worksheet sheet = gridDesktop1.Worksheets[0];

' Removing the Validation applied on a specific column
'sheet.Columns[2].RemoveValidation();

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-AccessingWorksheets-AccessingWithActiveWorksheet.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accesing an active worksheet using its index
Dim sheet As Worksheet = gridDesktop1.Worksheets(gridDesktop1.ActiveSheetIndex)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-AccessingWorksheets-AccessingWithGetActiveWorksheet.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accesing an active worksheet directly
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-AccessingWorksheets-AccessingWithIndex.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accesing a worksheet using its index
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-AccessingWorksheets-AccessingWithName.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accesing a worksheet using its name
Dim sheet As Worksheet = gridDesktop1.Worksheets("Sheet2")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-AddingCellControls-AddingButton.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Accessing the location of the cell that is currently in focus
Dim cl As CellLocation = sheet.GetFocusedCellLocation()

' Adding button to the Controls collection of the Worksheet
Dim button As Aspose.Cells.GridDesktop.Button = sheet.Controls.AddButton(cl.Row, cl.Column, 80, 20, "Button")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-AddingCellControls-AddingCheckbox.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Accessing the location of the cell that is currently in focus
Dim cl As CellLocation = sheet.GetFocusedCellLocation()

' Adding checkbox to the Controls collection of the Worksheet
sheet.Controls.AddCheckBox(cl.Row, cl.Column, True)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-AddingCellControls-AddingCombobox.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Accessing the location of the cell that is currently in focus
Dim cl As CellLocation = sheet.GetFocusedCellLocation()

'Creating an array of items or values that will be added to combobox
Dim items As String() = New String(2) {}
items(0) = "Aspose"
items(1) = "Aspose.Grid"
items(2) = "Aspose.Grid.Desktop"

' Adding combobox to the Controls collection of the Worksheet
sheet.Controls.AddComboBox(cl.Row, cl.Column, items)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-AddingCellControls-HandlingButton.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Implenting CellButtonClick event handler
Private Sub gridDesktop1_CellButtonClick(sender As Object, e As CellControlEventArgs)
	' Displaying the message when button is clicked
	MessageBox.Show("Button is clicked.")
End Sub

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-AddingCellControls-HandlingCheckbox.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Implenting CellCheckedChanged event handler
Private Sub gridDesktop1_CellCheckedChanged(sender As Object, e As CellControlEventArgs)
	' Getting the reference of the CheckBox control whose event is triggered
	Dim check As Aspose.Cells.GridDesktop.CheckBox = DirectCast(gridDesktop1.GetActiveWorksheet().Controls(e.Row, e.Column), Aspose.Cells.GridDesktop.CheckBox)

	' Displaying the message when the Checked state of CheckBox is changed
	MessageBox.Show("Current state of CheckBox is " & check.Checked)
End Sub

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-AddingCellControls-HandlingCombobox.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Implenting CellSelectedIndexChanged event handler
Private Sub gridDesktop1_CellSelectedIndexChanged(sender As Object, e As CellComboBoxEventArgs)
	' Getting the reference of the ComboBox control whose event is triggered
	Dim combo As Aspose.Cells.GridDesktop.ComboBox = DirectCast(gridDesktop1.GetActiveWorksheet().Controls(e.Row, e.Column), Aspose.Cells.GridDesktop.ComboBox)

	' Displaying the message when the Selected Index of ComboBox is changed
	MessageBox.Show(combo.Items(combo.SelectedIndex).ToString())
End Sub

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-AddingCellControls-SetBackground.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' The path to the documents directory.
Dim dataDir As String = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)

' Set the image.
Dim image__1 As Image = Image.FromFile(dataDir & "AsposeLogo.jpg")
button.Image = image__1

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-AddInsertWorksheet-AddingWorksheet.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Adding a worksheet to the Grid
Dim i As Integer = gridDesktop1.Worksheets.Add()
Dim sheet As Worksheet = gridDesktop1.Worksheets(i)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-AddInsertWorksheet-AddingWorksheetWithName.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Adding a worksheet to the Grid with a specific name
Dim sheet1 As Worksheet = gridDesktop1.Worksheets.Add("AddWorksheetWithName")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-AddInsertWorksheet-InsertingWorksheet.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Inserting a worksheet to Grid at first position of the worksheets collection
gridDesktop1.Worksheets.Insert(0)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-AddInsertWorksheet-InsertingWorksheetWithName.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Inserting a worksheet to Grid at first position with a specific sheet name
Dim sheet1 As Worksheet = gridDesktop1.Worksheets.Insert(0, "InsertWorksheetWithName")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-DisplayHideScrolBars-HideScrollbars.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Hiding the vertical scroll bar
gridDesktop1.IsVerticalScrollBarVisible = False

' Hiding the horizontal scroll bar
gridDesktop1.IsHorizontalScrollBarVisible = False

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-DisplayHideScrolBars-ShowScrollbars.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Displaying the vertical scroll bar
gridDesktop1.IsVerticalScrollBarVisible = True

' Displaying the horizontal scroll bar
gridDesktop1.IsHorizontalScrollBarVisible = True

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ExportDataToDataTable-ExportToNewDataTable.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the reference of the worksheet that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

'Getting the total number of rows and columns inside the worksheet
Dim totalRows As Integer = sheet.RowsCount
Dim totalCols As Integer = sheet.ColumnsCount

' Exporting the data of the active worksheet to a new DataTable object
Dim table As DataTable = sheet.ExportDataTable(0, 0, totalRows, totalCols, False, True)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ExportDataToDataTable-ExportToSpecificDataTable.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Creating a new DataTable object
Dim dataTable As New DataTable()

' Adding specific columns to the DataTable object
dataTable.Columns.Add("ProductName", System.Type.[GetType]("System.String"))
dataTable.Columns.Add("CategoryName", System.Type.[GetType]("System.String"))
dataTable.Columns.Add("QuantityPerUnit", System.Type.[GetType]("System.String"))
dataTable.Columns.Add("UnitsInStock", System.Type.[GetType]("System.Int32"))

' Exporting the data of the first worksheet of the Grid to the specific DataTable object
dataTable = gridDesktop1.Worksheets(0).ExportDataTable(dataTable, 0, 0, 69, 4, True)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ImportDataFromDataTable-1.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' The path to the documents directory.
Dim dataDir As String = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)

Dim adapter As OleDbDataAdapter
Dim dt As New DataTable()

' Creating connection string to connect with database
Dim conStr As String = "Provider=microsoft.jet.oledb.4.0;Data Source=" & dataDir & "dbDatabase.mdb"

' Creating Select query to fetch data from database
Dim query As String = "SELECT * FROM Products ORDER BY ProductID"
adapter = New OleDbDataAdapter(query, conStr)

' Filling DataTable using an already created OleDbDataAdapter object
adapter.Fill(dt)

' Accessing the reference of a worksheet
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Importing data from DataTable to the worksheet. 0,0 specifies to start importing data from the cell with first row (0 index) and first column (0 index)
sheet.ImportDataTable(dt, False, 0, 0)

' Iterating through the number of columns contained in the DataTable
For i As Integer = 0 To dt.Columns.Count - 1
	' Setting the column headers of the worksheet according to column names of the DataTable
	sheet.Columns(i).Header = dt.Columns(i).Caption
Next

' Setting the widths of the columns of the worksheet
sheet.Columns(0).Width = 240
sheet.Columns(1).Width = 160
sheet.Columns(2).Width = 160
sheet.Columns(3).Width = 100

' Displaying the contents of the worksheet by making it active
gridDesktop1.ActiveSheetIndex = 0

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ManagingCellControls-AccessCheckbox.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Getting the location of the cell that is currently in focus
Dim cl As CellLocation = sheet.GetFocusedCellLocation()

' Accessing cell control and typecasting it to CheckBox
Dim cb As Aspose.Cells.GridDesktop.CheckBox = DirectCast(sheet.Controls(cl.Row, cl.Column), Aspose.Cells.GridDesktop.CheckBox)

If cb IsNot Nothing Then
	' Modifying the Checked property of CheckBox
	cb.Checked = True
Else
	MessageBox.Show("Please add control before accessing it.")
End If

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ManagingCellControls-RemoveCheckbox.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing the worksheet of the Grid that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Getting the location of the cell that is currently in focus
Dim cl As CellLocation = sheet.GetFocusedCellLocation()

' Removing the cell control by specifying the location of cell containing it
sheet.Controls.Remove(cl.Row, cl.Column)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ManagingComments-AccessingComments.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Accessing a comment added to "c3" cell (specified using its row & column number)
Dim comment1 As Aspose.Cells.GridDesktop.Data.GridComment = sheet.Comments(3, 1)

If comment1 IsNot Nothing Then
	' Modifying the text of comment
	comment1.Text = "The 1st comment."
	MessageBox.Show("Comment has been modified")
Else
	MessageBox.Show("Please add comment before accessing it.")
End If

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ManagingComments-AddingComments.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Adding comment to "b2" cell
sheet.Comments.Add("b2", "Please write your name.")

' Adding another comment to "b4" cell using its row & column number
sheet.Comments.Add(3, 1, "Please write your email.")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ManagingComments-RemovingComments.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

If sheet.Comments(3, 1) IsNot Nothing Then
	' Removing comment from "c3" cell
	sheet.Comments.Remove(3, 1)
	MessageBox.Show("Comment has been removed")
Else
	MessageBox.Show("Please add comment before removing it.")
End If

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ManagingHyperlinks-AccessHyperlink.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Accessing a hyperlink added to "c3,b2" cells (specified using its row & column number)
Dim hyperlink1 As Aspose.Cells.GridDesktop.Data.GridHyperlink = sheet.Hyperlinks(2, 2)
Dim hyperlink2 As Aspose.Cells.GridDesktop.Data.GridHyperlink = sheet.Hyperlinks(1, 1)

If hyperlink1 IsNot Nothing AndAlso hyperlink2 IsNot Nothing Then
	' Modifying the Url of the hyperlink
	hyperlink1.Url = "www.aspose.com"
	hyperlink2.Url = "www.aspose.com"
	MessageBox.Show("Hyperlinks are accessed and URL's are: " & vbLf & hyperlink1.Url & vbLf & hyperlink2.Url)
Else
	MessageBox.Show("No hyperlinks are found in sheet. Add hyperlinks first.")
End If

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ManagingHyperlinks-AddHyperlink.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Accessing cell of the worksheet
Dim cell As GridCell = sheet.Cells("b2")
Dim cell2 As GridCell = sheet.Cells("c3")

' Modifying the width of the column of the cell
sheet.Columns(cell.Column).Width = 160
sheet.Columns(cell2.Column).Width = 160

' Adding a value to the cell
cell.Value = "Aspose Home"
cell2.Value = "Aspose Home"

' Adding a hyperlink to the worksheet containing cell name and the hyperlink URL with which the cell will be linked
sheet.Hyperlinks.Add("b2", "www.aspose.com")
sheet.Hyperlinks.Add("c3", "www.aspose.com")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ManagingHyperlinks-RemoveHyperlink.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

If sheet.Hyperlinks.Count > 0 Then
	' Removing hyperlink from "c3" cell
	sheet.Hyperlinks.Remove(2, 2)
	MessageBox.Show("Hyperlink in C3 cell has been removed.")
Else
	MessageBox.Show("No hyperlinks are found in sheet to remove. Add hyperlinks first.")
End If

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ManagingPictures-AccessAndModifyPicture.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' The path to the documents directory.
Dim dataDir As String = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)

' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Accessing a picture added to "c3" cell (specified using its row & column number)
Dim picture1 As Aspose.Cells.GridDesktop.Data.GridPicture = sheet.Pictures(1)

' Modifying the image
picture1.Image = Image.FromFile(dataDir & "Aspose.Grid.jpg")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ManagingPictures-AddingPictures.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' The path to the documents directory.
Dim dataDir As String = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)

' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Adding picture to "b2" cell from file
sheet.Pictures.Add("b2", dataDir & "AsposeGrid.jpg")

' Creating a stream contain picture
Dim fs As New FileStream(dataDir & "AsposeLogo.jpg", FileMode.Open)

Try
	' Adding picture to "b3" cell from stream
	sheet.Pictures.Add(2, 1, fs)
Catch ex As Exception
	MessageBox.Show(ex.Message)
Finally
	' Closing stream
	fs.Close()
End Try

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ManagingPictures-RemovePicture.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Removing picture from "c3" cell
sheet.Pictures.Remove(2, 2)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-MovingWorksheets-1.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Move the 2nd worksheet to 4th position.
gridDesktop1.Worksheets.MoveTo(1, 3)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ReadingDataValidations-1.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' The path to the documents directory.
Dim dataDir As String = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)

' Import sample excel file in GridDesktop
gridDesktop1.ImportExcelFile(dataDir & "ValidationTesting.xlsx")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-RemoveWorksheet-RemoveUsingIndex.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Removing a worksheet using its index
            gridDesktop1.Worksheets.Remove(0)

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-RemoveWorksheet-RemoveUsingName.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Removing a worksheet using its index
gridDesktop1.Worksheets.RemoveAt("Sheet3")

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-RenameWorksheet-1.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accesing an active worksheet directly
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

            ' Renaming a worksheet
            sheet.Name = "Renamed Sheet"

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-SortData-AscendingSort.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing a worksheet that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Creating SortRange object
Dim sr As New SortRange(sheet, range.StartRow, range.StartColumn, range.EndRow - range.StartRow + 1, range.EndColumn - range.StartColumn + 1, SortOrientation.SortTopToBottom, _
 True)

' Sorting data in the specified column in ascending order
sr.Sort(range.StartColumn, Aspose.Cells.GridDesktop.SortOrder.Ascending)

' Redrawing cells of the Grid
gridDesktop1.Invalidate()

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-SortData-CheckingCellRange.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Creating global variable of CellRange
		Private range As CellRange

		Private Sub gridDesktop1_SelectedCellRangeChanged(sender As Object, e As Aspose.Cells.GridDesktop.CellRangeEventArgs)
			' Checking if the range of cells is not empty
			If (e.CellRange.EndColumn - e.CellRange.StartColumn > 0) OrElse (e.CellRange.EndRow - e.CellRange.StartRow > 0) Then
				' Assigning the updated CellRange to global variable
				range = e.CellRange
			End If
End Sub

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-SortData-DescendingSort.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing a worksheet that is currently active
Dim sheet As Worksheet = gridDesktop1.GetActiveWorksheet()

' Creating SortRange object
Dim sr As New SortRange(sheet, range.StartRow, range.StartColumn, range.EndRow - range.StartRow + 1, range.EndColumn - range.StartColumn + 1, SortOrientation.SortTopToBottom, _
 True)

' Sorting data in the specified column in descending order
sr.Sort(range.StartColumn, Aspose.Cells.GridDesktop.SortOrder.Descending)

' Redrawing cells of the Grid
gridDesktop1.Invalidate()

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ValidationInWorksheets-AccessingValidation.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

If sheet.Validations.Count > 0 Then
	' Accessing the Validation object applied on "a8" cell
	Dim validation As Aspose.Cells.GridDesktop.Data.GridValidation = sheet.Validations(7, 0)

	' Editing the attributes of Validation
	validation.IsRequired = True
	validation.RegEx = ""
	validation.CustomValidation = Nothing
	MessageBox.Show("Validation has been edited after accessing it.")
Else
	MessageBox.Show("No validations found to access.")
End If

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ValidationInWorksheets-AddingValidation.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)

' Adding values to specific cells of the worksheet
sheet.Cells("a2").Value = "Required"
sheet.Cells("a4").Value = "100"
sheet.Cells("a6").Value = "2006-07-21"
sheet.Cells("a8").Value = "101.2"

' Adding Is Required Validation to a cell
sheet.Validations.Add("a2", True, "")

' Adding simple Regular Expression Validation to a cell
sheet.Validations.Add("a4", True, "\d+")

' Adding complex Regular Expression Validation to a cell
sheet.Validations.Add("a6", True, "\d{4}-\d{2}-\d{2}")

' Adding Custom Validation to a cell
sheet.Validations.Add("a8", New CustomValidation())

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ValidationInWorksheets-ImplementingICustomInterface.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Implementing ICustomValidation interface
Public Class CustomValidation
	Implements Aspose.Cells.GridDesktop.ICustomValidation
	' Implementing Validate method already defined in the interface
	Public Function Validate(worksheet As Worksheet, row As Integer, col As Integer, value As Object) As Boolean Implements ICustomValidation.Validate
		' Checking the cell's address
		If row = 7 AndAlso col = 0 Then
			'Checking the data type of cell's value
			Dim d As Double = 0
			Try
				d = CDbl(value)
			Catch
				Return False
			End Try

			' Checking if the cell's value is greater than 100
			If d > 100 Then
				Return True
			End If
		End If
		Return False
	End Function
End Class

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ValidationInWorksheets-RemoveValidation.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Accessing first worksheet of the Grid
Dim sheet As Worksheet = gridDesktop1.Worksheets(0)
If sheet.Validations.Count > 0 Then
	' Removing the Validation object applied on "a6" cell
	sheet.Validations.RemoveAt(1)
	MessageBox.Show("Validation has been removed.")
Else
	MessageBox.Show("No validations found to remove.")
End If

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ZoomingInOut-LoadEvent.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' The path to the documents directory.
Dim dataDir As String = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)

' Importing the template Excel file to GridDesktop
gridDesktop1.ImportExcelFile(dataDir & "EmployeeSales.xlsx")

' Set the default value of the TrackBar control
trackBar1.Value = 100

' Set the custom label's text to the trackbar's value for display
label1.Text = trackBar1.Value.ToString() & "%"

## Examples.GridDesktop-VisualBasic-GridDesktop.Examples-WorkingWithWorksheet-ZoomingInOut-ZoomInOut.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' Set the Zoom factor of the active worksheet to the Trackbar's value
gridDesktop1.Worksheets(gridDesktop1.GetActiveWorksheet().Index).Zoom = trackBar1.Value

' Show the percentage value of the specified Zoom
label1.Text = trackBar1.Value.ToString() & "%"

## Examples.GridDesktop-VisualBasic-UsingGridDesktopInWpf-MainWindow.xaml-UsingGridDesktopInWpf.vb
' For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
' The path to the documents directory.
Dim dataDir As String = Utils.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)

Using stream = New MemoryStream(File.ReadAllBytes(dataDir & Convert.ToString("SampleBook.xlsx")))
    Me.grid.ImportExcelFile(stream)
    Me.grid.ExportExcelFile(dataDir & Convert.ToString("SampleOutput_out.xlsx"))
End Using

## Examples_GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-FilteringData-AutoFilter.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Enable GridDesktop's auto-filter.
gridDesktop1.Worksheets[0].RowFilter.EnableAutoFilter = true;

// Set the header row.
gridDesktop1.Worksheets[0].RowFilter.HeaderRow = 0;

gridDesktop1.Worksheets[0].RefreshFilter();

## Examples_GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-FilteringData-CustomFilter.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

            // Set the header row.
            gridDesktop1.Worksheets[0].RowFilter.HeaderRow = 0;

            // Get the RowFilter object for the first worksheet.
            RowFilterSettings rowFilter = gridDesktop1.Worksheets[0].RowFilter;

            // Filter Rows.
            rowFilter.FilterRows(0, "Customer 1");

            gridDesktop1.Worksheets[0].RefreshFilter();

## Examples_GridDesktop-CSharp-GridDesktop.Examples-WorkingWithCells-FilteringData-NotEqualCustomFilter.cs
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Get the RowFilter object for the first worksheet.
RowFilterSettings rowFilter = gridDesktop1.Worksheets[0].RowFilter;

// Filter Rows.
rowFilter.CustomRows(0, GridFilterOperatorType.NotEqual, "Customer 1");

gridDesktop1.Worksheets[0].RefreshFilter();
	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

	//Path of the sample Excel file containing Pivot Table
	string filePath = Utils.Get_SourceDirectory() + "sampleRenderPivotTableInGridDesktop.xlsx";

	//Import sample Excel file containing Pivot Table
	this.gridDesktop1.ImportExcelFile(filePath);
	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

	//Get the version number of GridDesktop
	string version = Aspose.Cells.GridDesktop.GridDesktop.GetVersion();

	//Show the version number in message box
	MessageBox.Show("GridDesktop Version: " + version, "GridDesktop Version");
	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET

	public class MyICustomColumnCaption : ICustomColumnCaption
	{
	//Returns the Custom Column Caption
	public string GetCaption(int column)
	{
	return "Mine " + (column + 10);
	}
	}
	public class MyICustomRowCaption : ICustomRowCaption
	{
	//Returns the Custom Row Caption
	public string GetCaption(int row)
	{
	return "R" + (row + 10).ToString();
	}
	}

	//-------------------------------------------
	//-------------------------------------------

	//Access the First GridDesktop Worksheet
	Worksheet ws = this.gridDesktop1.Worksheets[0];

	//Assign the Worksheet Custom Column and Row Caption Instance
	ws.CustomColumnCaption = new MyICustomColumnCaption();
	ws.CustomRowCaption = new MyICustomRowCaption();
	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
	/*
	* Indicates whether to copy/paste based on clipboard, so that it can copy/paste with MS-EXCEL.
	* It will only copy/paste cell value and will not copy any other setting of the cell like format, border style and so on.
	* The default value is false.
	*/
	gridDesktop1.EnableClipboardCopyPaste = true;
	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
	// Adding namespace to the top of code
	using System.Data.OleDb;
	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
	// Adding new row to the worksheet
	gridDesktop1.GetActiveWorksheet().AddRow();
	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
	// Iterating through each column of the worksheet
	for (int i = 0; i < sheet.ColumnsCount; i++)
	{
	// Getting the style object of each column
	Style style = sheet.Columns[i].GetStyle();

	// Setting the color of each column to Yellow
	style.Color = Color.Yellow;

	// Setting the Horizontal Alignment of each column to Centered
	style.HAlignment = HorizontalAlignmentType.Centred;

	// Setting the style of column to the updated one
	sheet.Columns[i].SetStyle(style);
	}
	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
	// Accessing the worksheet of the Grid that is currently active
	Worksheet sheet = gridDesktop1.GetActiveWorksheet();

	// Binding the Worksheet to Products table by calling its DataBind method
	sheet.DataBind(ds.Tables["Products"], "");
	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
	// Customizing the widths of columns of the worksheet
	sheet.Columns[0].Width = 70;
	sheet.Columns[1].Width = 120;
	sheet.Columns[2].Width = 80;
	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
	// Declaring global variable
	OleDbDataAdapter adapter;
	OleDbCommandBuilder cb;
	DataSet ds;