How to find blank rows in wijmo grid and delete those

How to find blank rows in wijmo grid and delete those

Posted by: ashish.sharma on 11 September 2017, 2:39 am EST

• 

  ashish.sharma

  • Post Options:
  • Link
    Copy

  Posted 11 September 2017, 2:39 am EST

  I have some blank rows in my wijmo grid now i need to check that which rows are blank and need to delete those rows in grid.

  How can I do this.

  Thanks
  
  Ashish

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 12 September 2017, 7:41 am EST

  Hi Ashish,
  
  Please check the dataItem for the rows if empty please remove it from CollectionView using https://www.grapecity.com/en/docs/wijmo/topic/wijmo.collections.CollectionView.Class.html#removeremove method.

  Hope it helps!

  Thanks,
  
  Manish Kumar Gupta

• 

  lorien0688

  • Post Options:
  • Link
    Copy

  Posted 4 April 2018, 2:59 am EST

  Make use of the Excel find function to remove blank rows

  • Select your data set > press Ctrl + F keys to open the Find and Replace dialog.
  
  • Now, click the “Options” button > select “Values” from “Look in” And let the “Find What” text box blank > click “Find All”.
  
  • After this “Find and Replace” dialog displays the entire blank cells.
  
  • Click any one record > press Ctrl + A for selecting the entire blank cells.
  
  • Next, close the “Find and Replace” dialog and without clicking anywhere else go to Home > Delete > Delete Rows.
  
  • Doing this will delete the entire selected rows.

  Source: http://www.repairmsexcel.com/blog/delete-blank-rows-in-excel