getCsv method return data contains data format

getCsv method return data contains data format

Posted by: zhoubing.yang on 12 May 2022, 4:40 am EST

• 

  zhoubing.yang

  • Post Options:
  • Link
    Copy

  Posted 12 May 2022, 4:40 am EST

  Is there a way to return all data with plain format when using getCsv method?
  Currently, when my spreadsheet contained formatted number data such as "12,000" (number with thousandsep), getCsv return "12,000" instead of "12000"
• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Replied 15 May 2022, 9:28 pm EST

  Hi,
  
  We are sorry but getCSV data only return the inside value, not the formatted text. You may create your own function to get all the text with format from a particular range. Please refer to the following code snippet and attached sample that explains the same.
  
  

  
  function getALLText(sheet, range) {
    if (!(range instanceof GC.Spread.Sheets.CellRange)) return null;
    let data = [],
      rowData = [];
    for (let row = range.row; row < range.row + range.rowCount; row++) {
      rowData = [];
      for (let col = range.col; col < range.col + range.colCount; col++) {
        rowData.push(sheet.getText(row, col));
      }
      data.push(rowData);
    }
    return data;
  }
  

  
  
  sample: https://codesandbox.io/s/spread-js-starter-forked-nwjcvh?file=/src/index.js:573-997
  
  regards,
  Avinash