Export sheet using toHTML with image inside

Export sheet using toHTML with image inside

Posted by: ricardo.aleixo on 24 April 2023, 8:46 am EST

• 

  ricardo.aleixo

  • Post Options:
  • Link
    Copy

  Posted 24 April 2023, 8:46 am EST - Updated 24 April 2023, 8:52 am EST

  Hi.

  i’ve a sheet with imagens witch i paste inside, but when i tried export using the method
  
  

  [code]sheet.getRange(-1, -1, -1, -1).toHtml(GC.Spread.Sheets.HeaderOptions.noHeaders);[/code]

  i can’t export the image.

  the sheet with image:
  
  

  There is a way to export this sheet with the image?

  Export using the method:
  
  

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 25 April 2023, 8:20 am EST

  Hello,

  The cellRange.toHtml() method is used to convert the specified sheet area to html table format. The html content of the specified sheet area(cell range) contains cell text, cell span and cell style. Currently, when exporting a range to HTML, picture will not be exported. Currently, this is not supported.

  You could refer to the following docs on the features that are unsupported when exporting a range to HTML: https://www.grapecity.com/spreadjs/docs/excelimpexp/export-range-to-html

  You can export the image with spreadsheet in excel, SJS and json format.

  Regards,

  Ankit