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
Ben Hull
820
Javascript excel workbook error
posted

With version: 17.1.20171.1012

The javascript excel support files seem to have vanished:

The  js/infragistics.documents.core.js file does not exist, maybe the file is now js/modules/infragistics.documents.core_core.js ?

The js/infragistics.exel.js file does not exist, maybe the file is now js/modules/infragistics.exel_core.js?


Our Issue

When exporting using the above found js files, we are now getting errors when attempting to add a worksheet to the workbook:

var workbook = new $.ig.excel.Workbook($.ig.excel.WorkbookFormat.excel2007);
var sheet = workbook.worksheets().add('Sheet1');

I receive the error:  'Object doesn't support property or method 'worksheets'' when trying to add 'sheet1' to the workbook

This is the link to the example we originally used:

http://help.infragistics.com/Help/Doc/jQuery/2014.2/CLR4.0/html/Using_the_Client_Side_Excel_Library.html

  • 16310
    Verified Answer
    Offline posted

    ()Hello Ben,

    As per your observation the infragistics.documents.core.js and infragistics.exel.js files have been modularized and splitted into several files, some of which are infragistics.documents.core_core.js and infragistics.exel_core.js.

    Once you load all the required resources for working with the Excel library, you should have this issue ('Object doesn't support property or method 'worksheets'' when trying to add 'sheet1' to the workbook) resolved. Here is the list of all required resources:

    infragistics.ext_core.js
    infragistics.ext_collections.js
    infragistics.ext_text.js
    infragistics.ext_io.js
    infragistics.ext_ui.js
    infragistics.documents.core_core.js
    infragistics.ext_collectionsextended.js
    infragistics.excel_core.js
    infragistics.ext_threading.js
    infragistics.ext_web.js
    infragistics.xml.js
    infragistics.documents.core_openxml.js
    infragistics.excel_serialization_openxml.js

    You can refer to our live sample that is using this resources. Our JavaScript Excel Library Overview topic will have the updated resources on next release of the Help Topics site.

    Please let me know if you have further questions on the matter, I will be glad to help.