How to Get an array?

How to Get an array?

Posted by: Fabrice.Mainguene on 29 November 2023, 2:30 am EST

• 

  Fabrice.Mainguene

  • Post Options:
  • Link
    Copy

  Posted 29 November 2023, 2:30 am EST

  Hi,

  I put an array in a cell:
  
  activeSheet.getCell(1, 1).formula(“{1,2,3;4,5,6}”);

  But when I try to get it with the code:
  
  activeSheet.getCell(1, 1).value();
  
  the result is : 1

  Is there a way to get the result: [[1,2,3],[4,5,6]] ?

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 29 November 2023, 5:44 pm EST

  Hi,

  In the code snippet that you have shared, you have used the value() method that returns the cell value. If you want to get the formula, you should use the “formula()” method.

  Moreover, if you want to get the array as “[[1,2,3],[4,5,6]]”, you could use the getArray() method. Kindly refer to the following code snippet and the sample:

      activeSheet.getCell(1, 1).formula("{1, 2, 3; 4, 5, 6}");
  
      let value = activeSheet.getCell(1, 1).value();
      // Log the Value
      console.log(value);
      let formula = activeSheet.getCell(1, 1).formula();
      // Log the Formula
      console.log(formula);
  
      let formulaInfo = activeSheet.getFormulaInformation(1, 1);
      if (formulaInfo && formulaInfo.baseRange) {
          let range = formulaInfo.baseRange;
          // Get the Array [[1, 2, 3], [4, 5, 6]]
          let valueArr = activeSheet.getArray(range.row, range.col, range.rowCount, range.colCount);
          console.log(valueArr);
      }

  Sample: https://jscodemine.grapecity.com/share/WUVqOftFGkS1500ODgq9IQ/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  References:

  getArray method: https://developer.mescius.com/spreadjs/api/v15/classes/GC.Spread.Sheets.Worksheet#getarray

  getFormulaInformation method: https://developer.mescius.com/spreadjs/api/v15/classes/GC.Spread.Sheets.Worksheet#getformulainformation

  formula method: https://developer.mescius.com/spreadjs/api/v15/classes/GC.Spread.Sheets.CellRange#formula

  Regards,

  Ankit