Forums Ignite UI for jQuery
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Michael Seidel
8920
JavaScript Excel Library vs Spreadsheet
posted

in bullet points without too much details how to describe the differences / commonalities between  JavaScript Excel Library  and  Spreadsheet  control. 

  • 1100
    Verified Answer
    Offline posted

    Hello Michael,

    Thank you for contacting the Infragistics support!

    About the JavaScript Excel Library:

    • It is a client-side library

    • It can be used to load and save Microsoft Excel documents

    • It supports getting and setting data and format properties on rows, columns and cells

    • It can be used to export a grid or table to a workbook document on the client machine

    • It can be used to read an Excel document and display its data in the browser

    • The library can be used to solve formulas in the browser as they would be calculated in Excel, without sending anything to the server

    • It can create a new workbook instance

    • It can add worksheets to an existing workbook

    • It can populate a worksheet with data

    • It can save a workbook that was previously created using the Library

    And about the igSpreadsheet:

    • It is a jQuery widget that visualize excel documents in all modern browsers

    • It has a plenty of configurable areas (Formula bar, context menu, column headers, etc.)

    • The widget supports different features that can be enabled/disabled: selection, resizing, hiding, freezing panes, splitting panes, zooming

    • It supports data manipulations from the UI: you can insert or delete cells, columns and rows; it supports copy and paste as well as undo and redo; you can add worksheets from the UI, etc.

    • It supports visual configurations: gridlines can be shown or hidden, the cell alignment can be changed, font styles can be set, it has scrollbars, buttons for navigating through the worksheets, etc.

    • You can navigate through the cells of the active pane of the currently selected worksheet. The active cell can be changed using the keyboard or mouse

    We can say that the igSpreadsheet is a control for visualizing in the browser a document that is created using Microsoft Excel or Infragistics JavaScript Excel Library. The IgSpreadsheet control has user interface which allows the end user to manipulate the data in the browser.

    The JavaScript Excel Library, on the other hand, doesn`t have actual user interface. It can be used to create or modify data that will be rendered by the igSpreadsheet.

     

    For more detailed information you can use the help topics provided for the:

    The behaviors of the Excel Library and igSpreadsheet are illustrated by the samples that can be tested here:

     

    I hope this will help you in your work with Ignite UI.

    If something is not clear or you need further assistance, do not hesitate to contact the Infragistics support again!

    Best Regards,
    Alexander Marinov,
    Infragistics