Display plain object data in javascript grid

Array of plain row objects can be directly passed as the value of data key in dataModel object. colModel is optional in v3.0.0
Grid From JSON
rank
company
revenues
profits
 
 
 
 
 
1
Exxon Mobil
339938
36130
2
Wal-Mart Stores
315654
11231
3
Royal Dutch Shell
306731
25311
4
BP
267600
22341
5
General Motors
192604
-10567
6
Chevron
189481
14099
7
DaimlerChrysler
186106.3
3536.3
8
Toyota Motor
185805
12119.6
9
Ford Motor
177210
2024
10
ConocoPhillips
166683
13529
11
General Electric
157153
16353
12
Total
152360.7
15250
13
ING Group
138235.3
8958.9
14
Citigroup
131045
24589
15
AXA
129839.2
5186.5
16
Allianz
121406
5442.4
17
Volkswagen
118376.6
1391.7
18
Fortis
112351.4
4896.3
19
Crédit Agricole
110764.6
7434.3
20
American Intl. Group
108905
10477
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Loading...


38
 
1
2
3
    $(function () {
4
        var data = [
5
            { rank: 1, company: 'Exxon Mobil', revenues: 339938.0, profits: 36130.0 },
6
            { rank: 2, company: 'Wal-Mart Stores', revenues: 315654.0, profits: 11231.0 },
7
            { rank: 3, company: 'Royal Dutch Shell', revenues: 306731.0, profits: 25311.0 },
8
            { rank: 4, company: 'BP', revenues: 267600.0, profits: 22341.0 },
9
            { rank: 5, company: 'General Motors', revenues: 192604.0, profits: -10567.0 },
10
            { rank: 6, company: 'Chevron', revenues: 189481.0, profits: 14099.0 },
11
            { rank: 7, company: 'DaimlerChrysler', revenues: 186106.3, profits: 3536.3 },
12
            { rank: 8, company: 'Toyota Motor', revenues: 185805.0, profits: 12119.6 },
13
            { rank: 9, company: 'Ford Motor', revenues: 177210.0, profits: 2024.0 },
14
            { rank: 10, company: 'ConocoPhillips', revenues: 166683.0, profits: 13529.0 },
15
            { rank: 11, company: 'General Electric', revenues: 157153.0, profits: 16353.0 },
16
            { rank: 12, company: 'Total', revenues: 152360.7, profits: 15250.0 },
17
            { rank: 13, company: 'ING Group', revenues: 138235.3, profits: 8958.9 },
18
            { rank: 14, company: 'Citigroup', revenues: 131045.0, profits: 24589.0 },
19
            { rank: 15, company: 'AXA', revenues: 129839.2, profits: 5186.5 },
20
            { rank: 16, company: 'Allianz', revenues: 121406.0, profits: 5442.4 },
21
            { rank: 17, company: 'Volkswagen', revenues: 118376.6, profits: 1391.7 },
22
            { rank: 18, company: 'Fortis', revenues: 112351.4, profits: 4896.3 },
23
            { rank: 19, company: 'Crédit Agricole', revenues: 110764.6, profits: 7434.3 },
24
            { rank: 20, company: 'American Intl. Group', revenues: 108905.0, profits: 10477.0 }
25
        ];
26
27
        var obj = {
28
            width: "80%",
29
            height: 400,
30
            resizable: true,
31
            title: "Grid From JSON",
32
            showBottom: false,
33
            scrollModel: { autoFit: true },
34
            dataModel: { data: data }
35
        };
36
        $("#grid_json").pqGrid(obj);
37
    });    
38
    
ParamQuery Pro Eval