What is the best way to clear all the values of a row

What is the best way to clear all the values of a row

Posted by: datta on 22 June 2023, 5:27 am EST

• 

  datta

  • Post Options:
  • Link
    Copy

  Posted 22 June 2023, 5:27 am EST

  Hi I have a use case where I should clear the values of a row without deleting it. Now the problem with clearing the value cell by cell is that I don’t know how many columns exist in that row. Is there any clearRow() api which simply clears all the values of a row? Also is there an API which gives me last cell in a row which is having a value?

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 23 June 2023, 6:20 am EST

  Hello,

  The sheet.clear() method can be used to clear a cell range. You can utilize this method to clear the values from a row. To find the number of columns in the sheet, sheet.getColumnCount() method can be used.

      let sheet = spread.getActiveSheet();
      let row = sheet.getActiveRowIndex();
      //clears the data from the specified range.
      sheet.clear(row, 0, 1, sheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);

  Additionally, you can traverse the cells of a row to find the last cell that has a value.
  
  Please refer to the attached sample for further understanding.

  sample: https://jscodemine.grapecity.com/share/26ETVj3el0mBkMtr9ZVsnQ/?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["%2Findex.html"%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  Please let us know if you need further assistance.

  References:

  sheet.clear():https://www.grapecity.com/spreadjs/api/v16/classes/GC.Spread.Sheets.Worksheet#clear

  sheet.getColumnCount():https://www.grapecity.com/spreadjs/api/v16/classes/GC.Spread.Sheets.Worksheet#getcolumncount

  Regards,

  Ankit