Read the values of the GridWeb cells on Client Side

Possible Usage Scenarios

You can read the values of GridWeb cells on client side script using the gridwebinstance.getCellsArray() method. Once, you will call it, it will return the array of all the cells in active worksheet. You can then use the following methods to retrieve the value and other information of the cells.

• gridwebinstance.getCellName()
• gridwebinstance.getCellValueByCell()
• gridwebinstance.getCellRow()
• gridwebinstance.getCellColumn()

Read the values of the GridWeb cells on Client Side

The following sample code retrieves all the cells and then prints their name, value, row and column. You can see its console output at the bottom of this article. The following screenshot shows the console output of the sample code on Google Chrome.

Screenshot

Sample Code

For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
<script type="text/javascript">
    function ReadGridWebCells() {
        // Access GridWeb instance and cells array
        var gridwebins = gridwebinstance.get("<%=GridWeb1.ClientID%>");
        var cells = gridwebins.getCellsArray();

        // Log cell name, values, row & column indexes in console
        for (var j = 0; j < cells.length; j++)
        {
            var cellInfo = j + ":" + gridwebins.getCellName(cells[j]) + ",";
            cellInfo += "value is:" + gridwebins.getCellValueByCell(cells[j]) + " ,";
            cellInfo += "row:" + gridwebins.getCellRow(cells[j]) + ",";
            cellInfo += "col:" + gridwebins.getCellColumn(cells[j]);
            console.log(cellInfo);
        }
    }
</script>

Please call the JavaScript function ReadGridWebCells() as shown in the above sample code like this.

For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
<button type="button" onclick="ReadGridWebCells()">Click me</button>                        

Console Output

This is the console output of the above sample code.

 0:A1,value is:0 ,row:0,col:0

1:B1,value is:4 ,row:0,col:1

2:C1,value is:1 ,row:0,col:2

3:D1,value is:1 ,row:0,col:3

4:E1,value is:2 ,row:0,col:4

5:F1,value is:6 ,row:0,col:5

6:G1,value is:9 ,row:0,col:6

7:H1,value is: ,row:0,col:7

8:A2,value is:5 ,row:1,col:0

9:B2,value is:9 ,row:1,col:1

10:C2,value is:1 ,row:1,col:2

11:D2,value is:5 ,row:1,col:3

12:E2,value is:10 ,row:1,col:4

13:F2,value is:9 ,row:1,col:5

14:G2,value is:5 ,row:1,col:6

15:H2,value is: ,row:1,col:7

16:A3,value is:4 ,row:2,col:0

17:B3,value is:9 ,row:2,col:1

18:C3,value is:2 ,row:2,col:2

19:D3,value is:9 ,row:2,col:3

20:E3,value is:4 ,row:2,col:4

21:F3,value is:5 ,row:2,col:5

22:G3,value is:6 ,row:2,col:6

23:H3,value is: ,row:2,col:7

24:A4,value is:3 ,row:3,col:0

25:B4,value is:9 ,row:3,col:1

26:C4,value is:6 ,row:3,col:2

27:D4,value is:4 ,row:3,col:3

28:E4,value is:9 ,row:3,col:4

29:F4,value is:5 ,row:3,col:5

30:G4,value is:2 ,row:3,col:6

31:H4,value is: ,row:3,col:7

32:A5,value is: ,row:4,col:0

33:B5,value is: ,row:4,col:1

34:C5,value is: ,row:4,col:2

35:D5,value is: ,row:4,col:3

36:E5,value is: ,row:4,col:4

37:F5,value is: ,row:4,col:5

38:G5,value is: ,row:4,col:6

39:H5,value is: ,row:4,col:7

40:A6,value is: ,row:5,col:0