How can i get the number of Row's and Column's that is hidden?

How can i get the number of Row's and Column's that is hidden?

Posted by: ricardo.aleixo on 13 December 2023, 4:26 am EST

• 

  ricardo.aleixo

  • Post Options:
  • Link
    Copy

  Posted 13 December 2023, 4:26 am EST - Updated 13 December 2023, 4:35 am EST

  When i trying select all Rows and Columns, the number that i recive is the total number, but i’ve some hidden columns or rows, so, we’ve some method that return the number of hidden columns or rows? So then i can subtract the hidden from the total to get only my visibles ones.

  Here i’ve all columns and rows selected.

  

  1815×478 59.1 KB

  When i hidde the columns or rows and get the values, the return is the same…

  

  1815×478 56.4 KB

  So again, there is some method that i can get the value of hidden columns or rows to subtract of total?

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 13 December 2023, 7:42 pm EST

  Hi,

  There isn’t a direct method to obtain the count of hidden rows or columns. However, you can use the getRowVisible and getColumnVisible methods to determine the number of hidden rows or columns.

  These methods return true if the specified row or column is visible and false if it is hidden when passing the row or column index. By traversing through all rows or columns of sheet and checking their visibility, you can keep a count of hidden rows or columns. Refer below snippet and sample.

  function getHiddenCount( sheet){
      // actual count of rows/cols
      const actualRowCount = sheet.getRowCount();
      const actualColCount = sheet.getColumnCount();
  
      // variable to store hidden rows/cols count
      let hiddenRows = 0;
      let hiddenCols = 0;
  
      // counting hidden row
      for(let i = 0; i < actualRowCount; i++){
          if(!sheet.getRowVisible(i)){
              hiddenRows++;
          }
      }
      // counting hidden col
      for(let i = 0; i < actualColCount; i++){
          if(!sheet.getColumnVisible(i)){
              hiddenCols++;
          }
      }
  
      return { rowCount: hiddenRows, colCount: hiddenCols}
  }

  sample link: https://jscodemine.grapecity.com/share/nx4mgSAgdEyhAh88Q4_1wQ/?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"ActiveFile"%3A"%2Findex.html"}

  References:
  
  getRowVisible: https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#getrowvisible

  getCoumnVisible: https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#getcolumnvisible

  Best regards,

  Ankit