jQWidgets jqxDataTable getCellValue() Method

Last Updated : 26 Sep, 2021

jQWidgets is a JavaScript framework for making web-based applications for PC and mobile devices. It is a very powerful, optimized, platform-independent, and widely supported framework. The jqxDataTable is used for reading and displaying the data from the HTML Table. This is also used to display data from various data sources like XML, JSON, Array, CSV, or TSV.

The getCellValue() method is used to return the value for a particular specified cell.

Syntax:

$("#dataTable").jqxDataTable('getCellValue', rowIndex, dataField);

Parameters: This method accepts two parameters that are illustrated below.

rowIndex: It specifies the row index for which cell value is going to be returned.
dataField: It specifies the data field for which cell value is going to be returned.

Return values: This method returns the value for the specified cell.

Linked Files: Download jQWidgets from the given link. In the HTML file, locate the script files in the downloaded folder.

<link rel=”stylesheet” href=”jqwidgets/styles/jqx.base.css” type=”text/css” />
<script type=”text/javascript” src=”scripts/jquery.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxcore.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdata.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxbuttons.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxscrollbar.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxlistbox.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdropdownlist.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdatatable.js”></script>

Example: The below example illustrates the jQWidgets getCellValue() method. In the below example, the designation of the third row is going to be returned as the cell value.

HTML

<!DOCTYPE html> 
<html lang="en"> 
  
<head> 
    <link rel="stylesheet" href= 
"jqwidgets/styles/jqx.base.css" type="text/css" /> 
    <script type="text/javascript" 
            src="scripts/jquery.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxcore.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdata.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxbuttons.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxscrollbar.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxlistbox.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdropdownlist.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdatatable.js"> 
    </script> 
</head> 
  
<body> 
    <center> 
        <h1 style="color: green;">  
          GeeksforGeeks  
        </h1> 
        <h3>  
          jQWidgets jqxDataTable getCellValue() Method  
        </h3> 
        <div id="Data_Table"></div> 
        <input type="button" style="margin: 31px;" 
               id="jqxbutton" 
               value="Invoke the getCellValue() Method" /> 
        <div id="log"></div> 
    </center> 
    <script> 
        $(document).ready(function () { 
            var Data = new Array(); 
            var Employee_Name = [ 
                "Ravi", "Sumit", "Amit",  
                "Aakash", "Vivek"]; 
            var Company = [ 
                "GeeksforGeeks", "Amazon",  
                "Google", "Facebook", 
                "GeeksforGeeks"]; 
            var Designation = [ 
                "Content Writer", "Software Engineer",  
                "Data Analyst", 
                "Data Scientist", "HR"]; 
  
            a = 0; 
            while (a < 5) { 
                var row = {}; 
                row["Employee_Name"] = Employee_Name[a]; 
                row["Company"] = Company[a]; 
                row["Designation"] = Designation[a] 
                Data[a] = row; 
                a++; 
            } 
  
            var Data_Source = { 
                localData: Data, 
                dataType: "array", 
                dataFields: [{ 
                    name: 'Employee_Name', 
                    type: 'string' 
                }, { 
                    name: 'Company', 
                    type: 'string' 
                }, { 
                    name: 'Designation', 
                    type: 'string' 
                }] 
            }; 
            var data_Adapter =  
                new $.jqx.dataAdapter(Data_Source); 
            $("#Data_Table").jqxDataTable({ 
                width: 560, 
                theme: 'energyblue', 
                source: data_Adapter, 
                columns: [{ 
                    text: 'Employee_Name', 
                    dataField: 'Employee_Name', 
                    width: 210 
                }, { 
                    text: 'Company', 
                    dataField: 'Company', 
                    width: 150 
                }, { 
                    text: 'Designation', 
                    dataField: 'Designation', 
                    width: 200 
                }] 
            }); 
            $("#jqxbutton").jqxButton({ 
                theme: 'energyblue', 
                width: 250 
            }); 
            $('#jqxbutton').click(function () { 
                var Selected_cellValue =  
                         $("#Data_Table"). 
                    jqxDataTable('getCellValue',  
                                 2, 'Designation'); 
                $("#log").html(JSON.stringify( 
                               Selected_cellValue)) 
            }); 
        }); 
    </script> 
</body> 
  
</html>