Images not showing using imported feature

Images not showing using imported feature

Posted by: imran on 15 January 2023, 4:46 pm EST

• 

  imran

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 15 January 2023, 4:46 pm EST

  Hi,

  I am trying to use import feature using the following demo page.
  
  https://www.grapecity.com/spreadjs/demos/features/workbook/excel-import-export/angular

  I found that if i import an excel which have images then spreadjs not showing those images, All other contents showing properly.
  
  Can you please help me ASAP that what to do to show images as it is what imported excel contains?

  I attached a very simple xlsx file which have some dummy images. can you please check using this?test-xlsx.zip

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 16 January 2023, 3:48 pm EST

  Hi Imran,

  We appreciate you providing us with the Excel file. The ‘shapes’ dependency was missing from the hosted demo, which is why the images were not displayed when importing the Excel file. (https://www.grapecity.com/spreadjs/demos/features/workbook/excel-import-export/angular)

  You could import “@grapecity/spread-sheets-shapes”; to include the shapes dependency, and it would display all the images.

  You can refer to the sample below, where I’ve incorporated the dependence of shapes: https://jscodemine.grapecity.com/share/jPrW3-_akkKCuWH5l-P1rA/?defaultOpen={“OpenedFileName”%3A[“%2Findex.html”%2C"%2Fsrc%2Fapp.component.ts"%2C"%2Fpackage.json"%2C"%2Fsystemjs.config.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.component.ts"}

  You could also try importing the Excel file on our hosted SpreadJS Designer: https://www.grapecity.com/spreadjs/designer/index.html

  Shapes Demo: https://www.grapecity.com/spreadjs/demos/features/shapes/overview/angular

  I hope this clarifies your issue. Please let us know if you need further assistance on this query. We would be delighted to help you.

  Regards,

  Ankit

• 

  imran

  • Post Options:
  • Link
    Copy

  Posted 17 January 2023, 4:48 pm EST

  Hi Ankit,

  Thanks for the reply, The issue has been resolved using above solution that you posted.

  A big thanks to you

• 

  dileepkumarre.thati

  • Post Options:
  • Link
    Copy

  Posted 28 February 2023, 7:33 pm EST

  Hi,
  
  I am also facing the same problem. I am trying to import the excel which is having images and shapes both but spreadjs not showing those images/Shapes.
  
  I have tried workaround for adding images with
  
  sheetAReq.setFormula(11, 22, ‘=IMAGE("’ + base64+ ‘",4,50,150)’);

  I have tried adding shapes library script in my HTML. I am getting “Incorrect file format.” error from SpreadJS.
  
  I need help on this ASAP.spreadjs-work.zip

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 7 March 2023, 6:19 am EST

  Hi Dileep,

  I can see that you have already created a new forum case with the following link: https://www.grapecity.com/forums/spreadjs/images-and-shapes-are-not-loading-with-excel-io for the same issue.

  We have already responded to the case and will provide all the details on the case itself. Please let us know if you have any questions.

  Regards,

  Ankit