jQWidgets jqxTreeGrid columns Property

Last Updated : 27 Oct, 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 jqxTreeGrid is used for representing data in a tree-like structure. This widget is useful for displaying multi-column of hierarchical data, data paging, sorting and filtering, data editing, column resizing, fixed columns, conditional formatting, aggregates, and rows selection. These widgets also read and display the data from any type of data source such as XML, JSON, Array, CSV, or TSV.

The columns property is used for setting the columns for the specified jqxTreeGrid.

There is a list of properties that can be set inside the columns property:

text: This is a string property that is used for setting the texts for the column header.
dataField: This is a string property that sets the column’s bound field.
displayField: This is a string property that sets the column’s display field.
sortable: This is a boolean property that determines whether the column its sortable or not.
filterable: This is a boolean property that determines whether the column is filterable or not.
hidden: This is a boolean property that determines whether the column is visible or hidden.
columnGroup: This is a string property that determines the name of the column’s parent group.
autoCellHeight: This is a boolean property that determines whether the cell’s data wrapping is enabled.
renderer: This is a callback function for custom rendering of the column’s header.

Syntax:

$("#jqxTreeGrid").jqxTreeGrid({
    columns: [{
        text: 'Employee_Name',
        align: 'center',
        dataField: 'Employee_Name',
        width: 140
    }, {
        text: 'Company',
        align: 'center',
        dataField: 'Company',
        width: 150
    }, {
        text: 'Designation',
        align: 'center',
        dataField: 'Designation',
        width: 150
    }]
});

Linked Files: Download https://www.jqwidgets.com/download/ 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>
<script type=”text/javascript” src=”jqwidgets/jqxtreegrid.js”></script>

Example: The below example illustrates the jQWidgets jqxTreeGrid columns property.

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> 
    <script type="text/javascript" 
        src="jqwidgets/jqxtreegrid.js"> </script> 
</head> 
  
<body> 
    <center> 
        <h1 style="color: green;"> 
            GeeksforGeeks 
        </h1> 
        <h3> 
            jQWidgets jqxTreeGrid columns Property 
        </h3> 
        <div id="jqxTreeGrid" style="margin: 25px;"> 
        </div> 
        <script type="text/javascript"> 
            $(document).ready(function () { 
                var A = [{ 
                    "ID": 1, 
                    "Employee_Name": "Amit", 
                    "Company": "GeeksforGeeks", 
                    "Designation": "Content Writer", 
                    "expanded": true, 
                    A1: [{ 
                        "ID": 2, 
                        "Employee_Name": "Sumit", 
                        "Company": "Amazon", 
                        "Designation": "Software Engineer", 
                    }, { 
                        "ID": 3, 
                        "Employee_Name": "Vivek", 
                        "Company": "Apple", 
                        "Designation": "Product Manager", 
                        "expanded": true, 
                        A1: [{ 
                            "ID": 4, 
                            "Employee_Name": "Soni", 
                            "Company": "Flipkart", 
                            "Designation": "HR", 
                        }] 
                    }] 
                }]; 
  
                var Data_Source = { 
                    dataFields: [{ 
                        name: 'ID' 
                    }, { 
                        name: 'Employee_Name' 
                    }, { 
                        name: 'Company' 
                    }, { 
                        name: 'Designation' 
                    }, { 
                        name: 'A1', 
                        type: 'array' 
                    }, { 
                        name: 'expanded' 
                    }], 
                    hierarchy: { 
                        root: 'A1' 
                    }, 
                    id: 'ID', 
                    localData: A 
                }; 
  
                var Data = new 
                    $.jqx.dataAdapter(Data_Source); 
  
                $("#jqxTreeGrid").jqxTreeGrid({ 
                    source: Data, 
                    ready: function () { 
                        $("#jqxTreeGrid").jqxTreeGrid( 
                            'expandRow', '1'); 
                        $("#jqxTreeGrid").jqxTreeGrid( 
                            'expandRow', '3'); 
                    }, 
                    columns: [{ 
                        text: 'Employee_Name', 
                        align: 'center', 
                        dataField: 'Employee_Name', 
                        width: 140 
                    }, { 
                        text: 'Company', 
                        align: 'center', 
                        dataField: 'Company', 
                        width: 150 
                    }, { 
                        text: 'Designation', 
                        align: 'center', 
                        dataField: 'Designation', 
                        width: 150 
                    }] 
                }); 
            }); 
        </script> 
    </center> 
</body> 
  
</html>