Available in the Full Version

Spreadsheet - Overview

The igSpreadsheet control allows visualization of spreadsheet data, represented by the data model supported by the Infragistics Javascript Excel Library comprising of Workbooks, Worksheets, Cells, Formulas and more.
Wj
Statistics
  • Table2
  • Table3
Table data
Statistics
Global Oil Demand
Millions of barrels per day
Region
2013 / Q1
2013 /Q2
2013 / Q3
2013 / Q4
2014 / Q1
2014 / Q2
2014 / Q3
2014 / Q4
Africa
3.8
3.8
3.7
3.8
3.9
4
3.9
4
Americas
30.1
30.4
30.8
30.5
30.3
30.5
30.9
30.7
Asia
30.6
29.6
29.5
30.8
31
30.2
30.2
31.4
Europe
13.8
14.5
14.7
14.4
14
14.3
14.6
14.4
Former Soviet Union
4.3
4.5
4.8
4.8
4.4
4.7
4.9
4.9
Middle East
7.5
7.9
8.3
7.6
7.6
8.1
8.5
7.9
World
90.1
90.7
91.8
91.9
91.2
91.8
93.0
93.3
Average
91.7
Min
90.1
Max
93.3

This sample is designed for a larger screen size.

On mobile, try rotating your screen, view full size, or email to another device.

Code View

Copy to Clipboard 
if ($("#spreadsheet1").length !== 0) {
				$("#spreadsheet1").igSpreadsheet({
height: "600",
width: "100%",
activeWorksheetChanged: function (evt, ui) {
	if (ui.newActiveWorksheetName == "Statistics") {
		$("#spreadsheet1").igSpreadsheet("option", "activeCell", "E7");
	} else {
		$("#spreadsheet1").igSpreadsheet("option", "activeCell", "J15");
	}
}
				});

				var workbook = null;
				var xhr = new XMLHttpRequest();
				xhr.open('GET', '../../data-files/statistic.xlsx', true);
				xhr.responseType = 'arraybuffer';

				xhr.onload = function (e) {
// response is unsigned 8 bit integer
var responseArray = new Uint8Array(this.response);
$.ig.excel.Workbook.load(responseArray, function () {
	workbook = arguments[0];
	setInitialSettings();
}, function () {
	console.log("fail");
})
				};
				xhr.send();

				function setInitialSettings() {
$("#spreadsheet1").igSpreadsheet("option", "workbook", workbook);
var ws = workbook.worksheets("Table data");
$("#spreadsheet1").igSpreadsheet("option", "activeWorksheet", ws);
$("#spreadsheet1").igSpreadsheet("option", "activeCell", "J15");
$("#spreadsheet1").igSpreadsheet("option", "zoomLevel", "95");
				}
			}