Available in the Full Version

Javascript Excel - Overview

The Infragistics Ignite UI for jQuery JavaScript Excel library provides the same extensive Excel document object model found in our rich client and server Excel engines right there in the browser (or any JS runtime, like Node).

This sample is designed for a larger screen size.

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

Not only can you manipulate Excel docs like a pro, you can leverage the built-in powerful Excel formulas for all your number-crunching needs. This sample shows how to create a simple table to export to Excel.

Code View

Show In JsFiddle

Copy to Clipboard

                    function createTableWorkbook() {
    var workbook = new $.ig.excel.Workbook($.ig.excel.WorkbookFormat.excel2007);
    var sheet = workbook.worksheets().add('Sheet1');
    sheet.columns(0).setWidth(72, $.ig.excel.WorksheetColumnWidthUnit.pixel);
    sheet.columns(1).setWidth(160, $.ig.excel.WorksheetColumnWidthUnit.pixel);
    sheet.columns(2).setWidth(110, $.ig.excel.WorksheetColumnWidthUnit.pixel);
    sheet.columns(3).setWidth(275, $.ig.excel.WorksheetColumnWidthUnit.pixel);

    // Create a to-do list table with columns for tasks and their priorities.
    sheet.getCell('A1').value('ID');
    sheet.getCell('B1').value('Applicant');
    sheet.getCell('C1').value('Status');
    sheet.getCell('D1').value('Comment');
    var table = sheet.tables().add('A1:D8', true);

    // Specify the style to use in the table (this can also be specified as an optional 3rd argument to the 'add' call above).
    table.style(workbook.standardTableStyles('TableStyleMedium2'))

    // Populate the table with data
    sheet.getCell('A2').value(3223);
    sheet.getCell('B2').value('Jack Banner');
    sheet.getCell('C2').value('Approved');
    sheet.getCell('D2').value('');

    sheet.getCell('A3').value(3224);
    sheet.getCell('B3').value('Armin Barrywater');
    sheet.getCell('C3').value('In Review');
    sheet.getCell('D3').value('Underwriter is out until next week.');

    sheet.getCell('A4').value(3225);
    sheet.getCell('B4').value('Shiela Donahue');
    sheet.getCell('C4').value('In Review');
    sheet.getCell('D4').value('');

    sheet.getCell('A5').value(3226);
    sheet.getCell('B5').value('Perry Kane');
    sheet.getCell('C5').value('On Hold');
    sheet.getCell('D5').value('Waiting on paperwork from customer.');

    sheet.getCell('A6').value(3235);
    sheet.getCell('B6').value('Xavier Fannello');
    sheet.getCell('C6').value('New');
    sheet.getCell('D6').value('');

    sheet.getCell('A7').value(3244);
    sheet.getCell('B7').value('Georgi Angelchov');
    sheet.getCell('C7').value('New');
    sheet.getCell('D7').value('');

    sheet.getCell('A8').value(3257);
    sheet.getCell('B8').value('Imelda Sanchez');
    sheet.getCell('C8').value('New');
    sheet.getCell('D8').value('');

    // Sort the table by the Applicant column
    table.columns('Applicant').sortCondition(new $.ig.excel.OrderedSortCondition());

    // Filter out the Approved applicants
    table.columns('Status').applyCustomFilter(new $.ig.excel.CustomFilterCondition($.ig.excel.ExcelComparisonOperator.notEqual, 'Approved'));

    // Save the workbook
    saveWorkbook(workbook, "Table.xlsx");
}

function saveWorkbook(workbook, name) {
    workbook.save({ type: 'blob' }, function (data) {
        saveAs(data, name);
    }, function (error) {
        alert('Error exporting: : ' + error);
    });
}

                    <br />
<button id="exportButton" onclick="createTableWorkbook()">Create File</button>
<br />
<img alt="Result in Excel" src="/images/samples/client-side-excel-library/excel-table.png"></img>

                    .right {
    float: right;
}

#exportButton {
    float: left;
}

                    <!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title></title>

    <style>
        .right {
            float: right;
        }

        #exportButton {
            float: left;
        }
    </style>
    <!--Required scripts-->
    <script src="http://code.jquery.com/jquery-1.11.3.min.js"></script>
    <!-- External files for exporting -->
    <script src="/js/external/FileSaver.js"></script>
    <script src="/js/external/Blob.js"></script>

    <script type="text/javascript" src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/infragistics.core.js"></script>

    <script type="text/javascript" src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/modules/infragistics.ext_core.js"></script>
    <script type="text/javascript" src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/modules/infragistics.ext_collections.js"></script>
    <script type="text/javascript" src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/modules/infragistics.ext_text.js"></script>
    <script type="text/javascript" src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/modules/infragistics.ext_io.js"></script>
    <script type="text/javascript" src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/modules/infragistics.ext_ui.js"></script>
    <script type="text/javascript" src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/modules/infragistics.documents.core_core.js"></script>
    <script type="text/javascript" src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/modules/infragistics.ext_collectionsextended.js"></script>
    <script type="text/javascript" src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/modules/infragistics.excel_core.js"></script>
    <script type="text/javascript" src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/modules/infragistics.ext_threading.js"></script>
    <script type="text/javascript" src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/modules/infragistics.ext_web.js"></script>
    <script type="text/javascript" src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/modules/infragistics.xml.js"></script>
    <script type="text/javascript" src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/modules/infragistics.documents.core_openxml.js"></script>
    <script type="text/javascript" src="http://cdn-na.infragistics.com/igniteui/2023.2/latest/js/modules/infragistics.excel_serialization_openxml.js"></script>
</head>
<body>
    <br />
    <button id="exportButton" onclick="createTableWorkbook()">Create File</button>
    <br />
    <img alt="Result in Excel" src="/images/samples/client-side-excel-library/excel-table.png" />
    <script type="text/javascript">

        function createTableWorkbook() {
            var workbook = new $.ig.excel.Workbook($.ig.excel.WorkbookFormat.excel2007);
            var sheet = workbook.worksheets().add('Sheet1');
            sheet.columns(0).setWidth(72, $.ig.excel.WorksheetColumnWidthUnit.pixel);
            sheet.columns(1).setWidth(160, $.ig.excel.WorksheetColumnWidthUnit.pixel);
            sheet.columns(2).setWidth(110, $.ig.excel.WorksheetColumnWidthUnit.pixel);
            sheet.columns(3).setWidth(275, $.ig.excel.WorksheetColumnWidthUnit.pixel);

            // Create a to-do list table with columns for tasks and their priorities.
            sheet.getCell('A1').value('ID');
            sheet.getCell('B1').value('Applicant');
            sheet.getCell('C1').value('Status');
            sheet.getCell('D1').value('Comment');
            var table = sheet.tables().add('A1:D8', true);

            // Specify the style to use in the table (this can also be specified as an optional 3rd argument to the 'add' call above).
            table.style(workbook.standardTableStyles('TableStyleMedium2'))

            // Populate the table with data
            sheet.getCell('A2').value(3223);
            sheet.getCell('B2').value('Jack Banner');
            sheet.getCell('C2').value('Approved');
            sheet.getCell('D2').value('');

            sheet.getCell('A3').value(3224);
            sheet.getCell('B3').value('Armin Barrywater');
            sheet.getCell('C3').value('In Review');
            sheet.getCell('D3').value('Underwriter is out until next week.');

            sheet.getCell('A4').value(3225);
            sheet.getCell('B4').value('Shiela Donahue');
            sheet.getCell('C4').value('In Review');
            sheet.getCell('D4').value('');

            sheet.getCell('A5').value(3226);
            sheet.getCell('B5').value('Perry Kane');
            sheet.getCell('C5').value('On Hold');
            sheet.getCell('D5').value('Waiting on paperwork from customer.');

            sheet.getCell('A6').value(3235);
            sheet.getCell('B6').value('Xavier Fannello');
            sheet.getCell('C6').value('New');
            sheet.getCell('D6').value('');

            sheet.getCell('A7').value(3244);
            sheet.getCell('B7').value('Georgi Angelchov');
            sheet.getCell('C7').value('New');
            sheet.getCell('D7').value('');

            sheet.getCell('A8').value(3257);
            sheet.getCell('B8').value('Imelda Sanchez');
            sheet.getCell('C8').value('New');
            sheet.getCell('D8').value('');

            // Sort the table by the Applicant column
            table.columns('Applicant').sortCondition(new $.ig.excel.OrderedSortCondition());

            // Filter out the Approved applicants
            table.columns('Status').applyCustomFilter(new $.ig.excel.CustomFilterCondition($.ig.excel.ExcelComparisonOperator.notEqual, 'Approved'));

            // Save the workbook
            saveWorkbook(workbook, "Table.xlsx");
        }

        function saveWorkbook(workbook, name) {
            workbook.save({ type: 'blob' }, function (data) {
                saveAs(data, name);
            }, function (error) {
                alert('Error exporting: : ' + error);
            });
        }
    </script>
</body>
</html>

Ignite UI for jQuery | Samples

Search Results

Javascript Excel - Overview

Code View