JSFiddle - React, Tailwind, and code Playground
HTML
<script src="https://igniteui.com/js/modernizr.min.js"></script>
<script src="https://code.jquery.com/jquery-1.9.1.min.js"></script>
<script src="https://code.jquery.com/ui/1.10.3/jquery-ui.min.js"></script>
<script src="https://igniteui.com/js/external/FileSaver.js"></script>
<script src="https://igniteui.com/js/external/Blob.js"></script>
<script src="https://cdn-na.infragistics.com/igniteui/latest/js/infragistics.core.js"></script>
<script src="https://cdn-na.infragistics.com/igniteui/latest/js/infragistics.lob.js"></script>
<script src="https://cdn-na.infragistics.com/igniteui/latest/js/infragistics.dv.js"></script>
<script src="https://cdn-na.infragistics.com/igniteui/latest/js/infragistics.excel-bundled.js"></script>
<script src="https://cdn-na.infragistics.com/igniteui/latest/js/infragistics.spreadsheet-bundled.js"></script>
<script src="https://cdn-na.infragistics.com/igniteui/latest/js/modules/infragistics.gridexcelexporter.js"></script>
<script src="https://igniteui.com/js-data/nw-customers-with-orders"></script>
<link href="https://cdn-na.infragistics.com/igniteui/latest/css/themes/infragistics/infragistics.theme.css" rel="stylesheet"></link>
<link href="https://cdn-na.infragistics.com/igniteui/latest/css/structure/infragistics.css" rel="stylesheet"></link>
<table id="hierarchicalGrid"></table><br />
<input type="button" id="exportButton" class="button-style" value="Export to Excel (.xlsx)"></input>
CSS
.selectionOptions
{
margin-bottom: 10px;
}
JavaScript
$(function() {
var dataArr = new Array();
var sparklineDestination = new Array();
var dataAddress;
var sparklineAddress;
$("#hierarchicalGrid").igHierarchicalGrid({
expandColWidth: 0,
width: "100%",
autoCommit: true,
autoGenerateColumns: false,
dataSource: nwCustomersWithOrders,
responseDataKey: "results",
dataSourceType: "json",
autofitLastColumn: false,
primaryKey: "ID",
columns: [
{ key: "UnboundOrders", unbound: true, dataType: "number", width: "0%", hidden: true },
{ key: "Orders", width: "20%", headerText: "Freight Expenses", template: "<div data-id='${ID}' class='order-sparkline'></div>" },
{ key: "ID", width: "20%", headerText: "Company ID", hidden: true },
{ key: "CompanyName", width: "20%", headerText: "Company Name" },
{ key: "ContactName", width: "20%", headerText: "Contact Name" },
{ key: "ContactTitle", width: "20%", headerText: "Contact Title" }
],
rowExpanding: function (evt, ui) {
return false;
},
rowsRendered: function (evt, ui) {
//get data collection
var dataSource = ui.owner.dataSource;
$(".order-sparkline").each(function(i) {
$(this).igSparkline({
dataSource: dataSource.findRecordByKey(
$(this).data("id")).Orders,
displayType: "column",
height: "24px",
width: "100%",
valueMemberPath: 'Freight',
brush: "#376092"
})
.css("background-color", "transparent");
});
},
childrenDataProperty: "Orders",
autoGenerateLayouts: false,
columnLayouts: [
{
key: "Orders",
...