Export xlsx file using ExcelIO doesn't export background images

Export xlsx file using ExcelIO doesn't export background images

Posted by: davide.vago on 16 January 2020, 8:56 pm EST

• 

  davide.vago

  • Post Options:
  • Link
    Copy

  Posted 16 January 2020, 8:56 pm EST

  Good morning/afternoon.

  I’m currently trying to export a spreadsheet using the Excel IO library but unfortunately I noticed that if the spreadsheet instance has some cell with a background image set, the image get lost during the export, therefore when the user opens the extracted .xlsx file all the cell with a background image appears with a white background.

  Looking forward to find a solution

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 19 January 2020, 9:03 pm EST

  Hi Davide,

  Cell background images is an SJS feature, MS excel does not support background images for cell, that is why it is missing from the exported excel file. Please refer to the following doc for a list of cell settings which are supported during excel export:
  
  https://help.grapecity.com/spread/SpreadSheets12/webframe.html#excelcellex.html

  Regards
  
  Sharad

• 

  davide.vago

  • Post Options:
  • Link
    Copy

  Posted 19 January 2020, 10:55 pm EST

  Thanks Sharad for this information.
  
  Would it be possible to add some different type of cell data in order to inject some image? My goal is to add my company’s brand within the exported sheet.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 20 January 2020, 8:18 pm EST

  You could use your company’s brand logo as the workbook’s background. This feature also supports Excel export. Please refer to the following sample demonstrating the same:
  
  https://www.grapecity.com/spreadjs/demos/features/workbook/spread-background/purejs