setArray - provide cell format information within data array

setArray - provide cell format information within data array

Posted by: alexei.snisarenko on 17 December 2021, 8:59 am EST

• 

  alexei.snisarenko

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 17 December 2021, 8:59 am EST

  Hi

  I am trying to make setArray to also setup styling along with data array.

  for example:

  sheet.setArray(0, 0, [[“10/1/2021”, “11/1/2021”] ], false) I am trying to transform to something like
  
  sheet.setArray(0, 0, [[{style: “Date: mm/dd/yyyy”, value: “10/1/2021”}, style: “Date: mm/dd/yyyy”, value: “11/1/2021”}] ], false)

  Is there something that follows this approach?

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 21 December 2021, 7:57 am EST

  Hi,

  We are sorry but setArray does not support adding style information. The setArray method only sets the values/formulas in the specified two-dimensional array of objects into the specific range of cells of the worksheet.

  If you are planning to set the bulk data, use the suspendPaint and resumePaint method to improve the performance.

  You can use the setStyle Method for setting style on cell(s). For setting the formatter, you can use the formatter method.

  Formatter Method:https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.CellRange~formatter.html
  
  setStyle Method: https://www.grapecity.com/spreadjs/docs/v14/online/SpreadJS~GC.Spread.Sheets.Worksheet~setStyle.html
  
  Style Demo: https://www.grapecity.com/spreadjs/demos/features/cells/basic-style/purejs
  
  Formatter Demo: https://www.grapecity.com/spreadjs/demos/features/cells/formatter/basic-formatter/purejs
  
  suspendPaint and resumePaint: https://www.grapecity.com/spreadjs/docs/v14/online/UsingsuspendPaintandresumePaint.html

  Thanks.