Loading a local excel file into node

Posted by: ross.hulford on 28 February 2023, 2:36 am EST

  • Posted 28 February 2023, 2:36 am EST

    I am trying to load an excel file into spreadjs with node, has anyone achieved this? See .zip

    spreadjs.zip

  • Posted 1 March 2023, 7:41 pm EST

    Dear Ross,

    I’m facing issue while using SpreadJS V16 with nodejs. Unfortunately, I am encountering an error where the excelIO.open callback does not seem to be triggered in the sample code. To resolve this, I have escalated the matter to our development team for further investigation. They have assigned an internal tracking ID of SJS-17203 to this issue, and are currently working towards a solution.

    Rest assured, I will keep you updated as soon as I receive any updates from the development team regarding this issue. In the meantime, please let me know if you have any further questions or concerns.

    Best regards,

    Ankit

  • Posted 7 March 2023, 6:08 am EST

    Dear Ross,

    I hope this message finds you well. Attached, please find a sample file that explains how to use SpreadJS V16 with nodejs. The sample is based on the steps outlined in the blog post located at https://www.grapecity.com/blogs/how-to-generate-excel-spreadsheets-in-nodejs, with the addition of one crucial line that enables compatibility with SpreadJS V16:

    global.self = global;

    Please refer to the modified sample file attached herewith. To run the application successfully, start by installing the dependencies using the ‘npm install’ command. Afterward, on line number 14 and 15, add a valid license key. Finally, run the application with the ‘node index.js’ command. Upon successful execution, you should be able to see the name of the sheet and the value of Cell A1 being logged in the console.

    If you encounter any issues, please do not hesitate to reach out to us. We look forward to hearing about your experience with the updated sample.

    Best regards,

    Ankit

    Sample:

    sjs_node.zip

  • Posted 7 March 2023, 6:09 am EST - Updated 7 March 2023, 6:14 am EST

  • Posted 7 March 2023, 8:11 pm EST

    Thanks for your reply, it is much appreciated.

    I am getting a

    { errorCode: 1, errorMessage: 'Incorrect file format.' }

    Regarding the licence - will it not work without one? Can we get a trial for a few days?

    Thanks,

    Ross

  • Posted 8 March 2023, 10:18 pm EST

    Hello Ross,

    To run the application, you will need a valid license key. If you attempt to use an invalid or expired license key, you will encounter an error message stating “Incorrect file format.”

    It appears that our sales team has already supplied you with a license key. I recommend trying it out and informing us if you encounter any issues.

    Please don’t hesitate to contact us if you require further assistance.

    Best regards,

    Ankit

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels