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.

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

Show In JsFiddle

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");
				}
			}

                    <div id="spreadsheet1"></div>

                    .ui-igspreadsheet .ui-menu-item {
    white-space: nowrap;
}

                    <!DOCTYPE html>
<html>
<head>
	<title>igSpreadsheet Overview</title>

	<link href="http://cdn-na.infragistics.com/igniteui/2023.2/latest/css/themes/infragistics/infragistics.theme.css" rel="stylesheet" />
	<link href="http://cdn-na.infragistics.com/igniteui/2023.2/latest/css/structure/infragistics.css" rel="stylesheet" />

	<script src="http://ajax.aspnetcdn.com/ajax/modernizr/modernizr-2.8.3.js"></script>
	<script src="http://code.jquery.com/jquery-1.11.3.min.js"></script>
	<script src="http://code.jquery.com/ui/1.11.1/jquery-ui.min.js"></script>

	<!-- Ignite UI for jQuery Required Combined JavaScript Files -->
	<script src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/infragistics.core.js"></script>
	<script src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/infragistics.lob.js"></script>
	<script src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/infragistics.excel-bundled.js"></script>
	<script src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/infragistics.spreadsheet-bundled.js"></script>

    <style>
        .ui-igspreadsheet .ui-menu-item {
            white-space: nowrap;
        }
    </style>

</head>
<body>
	<div id="spreadsheet1"></div>
	<script type="text/javascript">
		$( function () {
			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");
				}
			}
		});
	</script>
</body>
</html>

             <!DOCTYPE html>
<html>
<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<!-- Ignite UI for jQuery Required Combined CSS Files -->
	<link href="/igniteui/css/themes/infragistics/infragistics.theme.css" rel="stylesheet" />
	<link href="/igniteui/css/structure/infragistics.css" rel="stylesheet" />
	<link href="/igniteui/css/structure/modules/infragistics.ui.spreadsheet.css" rel="stylesheet" />
	<!-- 1. Load libraries -->
	<script src="/js/modernizr.min.js"></script>
	<script src="/js/jquery.min.js"></script>
	<script src="/js/jquery-ui.min.js"></script>
	<!-- ReactJS library -->
	<script src="https://cdnjs.cloudflare.com/ajax/libs/react/15.3.2/react.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/react/15.3.2/react-dom.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/babel-core/5.6.16/browser.js"></script>
	<!-- Ignite UI for jQuery Required Combined JavaScript Files -->

	<script src="/igniteui/js/infragistics.core.js"></script>
	<script src="/igniteui/js/infragistics.lob.js"></script>
	<script src="/igniteui/js/infragistics.excel-bundled.js"></script>
	<script src="/igniteui/js/infragistics.spreadsheet-bundled.js"></script>

	<!-- Ignite UI for jQuery ReactJS Files -->
	<script src="https://unpkg.com/igniteui-react@1.2.0/igniteui-react.js"></script>
	<script src="https://unpkg.com/igniteui-react@1.2.0/ui/igSpreadsheet.js"></script>
</head>
<body>
	<div id="app">
		<script type="text/babel">
			var App= React.createClass({
				render: function() {
					var spreadsheet = {
						width: "75%",
						height: "600"
					};
						return (
							<IgSpreadsheet id="spreadsheet" width={spreadsheet.width} height={spreadsheet.height} />
						)
					}
				});
				ReactDOM.render(
				<App />,
				document.getElementById("app")
				);

				fetch('/data-files/statistic.xlsx', {
					method: 'GET'
				})
				.then((response) => response.arrayBuffer())
				.then((response) => {
					$.ig.excel.Workbook.load(new Uint8Array(response), function () {
						var workbook = arguments[0];
						$("#spreadsheet").igSpreadsheet("option", "workbook", workbook);
				}, function () {
					console.log("fail");
				})
			})
		</script>
</div>
</body>
</html>

Ignite UI for jQuery | Samples

Search Results

Spreadsheet - Overview

Code View