Images and Shapes are not loading with Excel IO

Posted by: dileepkumarre.thati on 2 March 2023, 4:01 pm EST

  • Posted 2 March 2023, 4:01 pm EST

    I am trying to import Excel with images and shapes in it using Excel IO library.

    But after import the shapes and images are not displaying.

    I have tried to manage the images insertion using sheet.setFormula (IMAGE) functionality.

    For shapes I have included the Shapes Library, but I am getting invalid file format error after clicking on import.

    Can you please address this issue ASAP?

    Here I am sharing the sample excel for your reference.

  • Posted 5 March 2023, 10:27 pm EST

    Hello Dileep,

    We are sorry for the inconvenience caused. We were able to replicate the issue on our end. We tried to import the excel file provided by you in SpreadJS designer, however the designer was stucking in infinite loop.

    After investigating it further, it seemed like a bug and needs to be fixed. So we have taken necessary steps on our end and escalated this issue to our development team. They have assigned internal tracking ID SJS-17269 for this issue.

    Rest assured, we will keep you updated on this matter and provide necessary assistance in the meanwhile.



  • Posted 7 March 2023, 5:41 pm EST

    Hi Ankit,

    Thank you for your reply.

    can you please give us any tentative timeline for resolving this issue.

    As we are waiting to implement this feature and we have short deadlines for implementation.

    we also need to inform our customer regarding this feature implementation.

  • Posted 8 March 2023, 3:06 pm EST

    Dear Dileep,

    I hope this message finds you well. I wanted to provide you with an update on the bug you reported. Our development team is actively working on resolving the issue, and we expect it to be fixed soon.

    As soon as the bug is resolved, we will include the fix in the next available release of SpreadJS. Our team is working tirelessly to ensure that this happens as soon as possible, and we appreciate your patience and understanding in the meantime.

    Rest assured that we are monitoring the situation closely, and we will keep you informed of any updates from our developers. As soon as we have any news, we will let you know immediately.

    Best regards,


  • Posted 14 March 2023, 4:43 pm EST

    Hello Dileep,

    I am reaching out to provide you with an update regarding the issue you reported earlier. After a thorough investigation, we have identified three issues related to the camera and picture shapes in SpreadJS, and I wanted to share the details with you.

    Firstly, we have resolved the issue related to the import crash when the camera shape’s range is a custom name or function. This problem has been fixed in the upcoming version of SpreadJS V16.1.0, which is scheduled for release in the next month.

    Secondly, we have identified that the camera shapes currently do not support rendering shapes module. However, we are actively working on adding this feature to our product backlog. At present, we don’t have an ETA for when this feature will be added, but we will update you as soon as we have more information.

    Finally, we regret to inform you that picture shapes do not support rendering EMF format images. Unfortunately, this is a browser limitation that we cannot work around. We apologize for any inconvenience this may cause.

    I hope this update provides clarity on the issues you reported. Please do not hesitate to reach out to us if you require any further information or assistance. Our team is always ready to help you.

    Best regards,


  • Posted 14 March 2023, 7:47 pm EST

    Hi Ankit,

    Thank you for your response. Appreciate your help.

    Can we get the Dev version build for the fix, so that I can test a priority item that needs a sign off.



  • Posted 14 March 2023, 8:28 pm EST

    Hello Dileep,

    After consulting with our development team, I am pleased to inform you that the issue will be addressed in the upcoming release of SpreadJS V16.0.5. The release is expected to be available later this week, but there may be a delay of 2-3 days.

    I understand that this delay may be inconvenient for you, but I would greatly appreciate your patience in waiting for the next release.

    Once the new release is published, I will make sure to promptly update you with the details. If you have any further concerns or questions, please don’t hesitate to let me know.

    Thank you for your understanding and cooperation.

    Best regards,


  • Posted 14 March 2023, 11:07 pm EST

    Hi Ankit,

    Thank you for the response, Appreciate your help.

    I will be waiting for the release update from your end.



  • Posted 19 March 2023, 1:21 am EST

    Dear Dileep,

    I would like to inform you that the problem related to the import crash when the camera shape’s range is a custom name or function has been resolved in the latest version of SpreadJS V16.0.5. We recommend upgrading to this latest version of SpreadJS to avoid this issue.

    To download the latest version of SpreadJS, please visit the following link:

    You can also test importing the Excel file on the hosted SpreadJS Designer: The Excel file should load successfully now.

    Please do not hesitate to let us know if you encounter any issues.

    Best regards,


  • Posted 22 March 2023, 8:22 pm EST

    Hi Ankit,

    Thank you so much for your support.

    Import crash when the camera shape’s range is a custom name or function is resolved now.

    But I have another query regarding generation of PDF. I am getting errorMessage : “File read and write exception.”

    I am getting the mentioned error when I am using shapes library along with excelio library.

    And without shapes library pdf is generating but format is wrong like I have Japnese characters in my excel. It’s not displaying Japanese characters.

    I am attaching the required files for your reference.

    Can you please help us on resolving this issue.

  • Posted 23 March 2023, 10:08 pm EST

    Dear Dileep,

    Thanks for sharing the xlsx file and the screenshots with us. I was able to replicate the issue with the latest version of SpreadJS V16.0.5. I could see the “File Read and Write Exception” being shown.

    I have forwarded this as a bug to the dev team for investigation. Currently, I couldn’t find a workaround for this issue. The internal tracking id for this is: SJS-17540. I will let you know when there is an update from the dev team regarding this issue.

    Regarding the Japanese characters not being exported to the PDF, it seems like the font you are using is not registered with the SpreadJS.

    When custom fonts are used, PDF is embedded as the subset of the font in the file. But users must embed the font file while performing the export operation.

    You could refer to the following docs on Using Custom Font for PDF Export:

    Custom Font PDF Export Demo:

    Please try registering the font you are using and let us know if the issue still persists. Also, for new queries, it is advised that you create a new case. It helps us to manage and respond to the case efficiently.



  • Posted 13 April 2023, 3:05 pm EST

    Hi Dileep,

    This issue with the internal tracking id SJS-17540 has been fixed in the latest version of SpreadJS V16.0.7. Kindly upgrade to the latest version of SpreadJS. You may download the V16.0.7 using the following link:



Need extra support?

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

Learn More

Forum Channels