Access and Modify Cell Value

Access Worksheet Cells discussed accessing cells. This topic extends that discussion to show how to access and modify cell values using the Aspose.Cells.GridWeb API.

Accessing & Modifying a Cell’s Value

String Values

Before accessing and modifying the value of a cell, you need to know how to access cells. For details about the different approaches for accessing cells, refer to Access Worksheet Cells.

Each cell has a property named StringValue. Once a cell is accessed, developers can use the StringValue property to access the cells string value. To modify cell values, a special method PutValue is provided, which can be used to update the cell’s string value.

// 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
GridWorksheet sheet = GridWeb1.WorkSheets[GridWeb1.ActiveSheetIndex];

// Accessing "B1" cell of the worksheet
GridCell cell = sheet.Cells["B1"];

// Accessing the string value of "B1" cell
Label1.Text = cell.StringValue;

// Modifying the string value of "B1" cell
cell.PutValue("Hello Aspose.Grid");

All Types of Values

PutValue method of a cell’s object has 8 overloads available which can be used to modify any type of value (Boolean, int, double, DateTime and string) in a cell.

// 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
GridWorksheet sheet = GridWeb1.WorkSheets[GridWeb1.ActiveSheetIndex];

// Accessing "B3" cell of the worksheet
GridCell cell = sheet.Cells["B3"];

// Putting a value in "B3" cell
cell.PutValue(30);

There is also an overloaded version of the PutValue method that can take any kind of value in string format and convert it to a proper data type automatically. To make it happen, pass the Boolean value true to another parameter of the PutValue method as shown below in the example.

// 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
GridWorksheet sheet = GridWeb1.WorkSheets[GridWeb1.ActiveSheetIndex];

// Accessing "B5" cell of the worksheet
GridCell cell = sheet.Cells["B5"];

// Putting a numeric value as string in "B5" cell that will be converted to a suitable data type automatically
cell.PutValue("19.4", true);