Delete blank rows from CellRange

Technical support for Spire.XLS

Moderators: iceblue support, Flash, Manager

Delete blank rows from CellRange

Postby veljean » Fri Jul 14, 2017 4:42 pm

giving this:

CellRange allRows = sheet.Range[firstRow, firstColumn, lastRow, lastColumn];

How can I delete blank rows from allrows?
veljean
 
Posts: 11
Joined: Tue May 28, 2013 6:22 pm

Re: Delete blank rows from CellRange

Postby Betsy.jiang » Mon Jul 17, 2017 6:06 am

Dear veljean,

Thanks for your inquiry.
Sorry that at present Spire.XLS doesn't support to delete blank rows from specific range, it only could delete entire row or entire column now. But we have added this new feature into our schedule, and we will let you know once there is any progress.

Sincerely,
Betsy
E-iceblue support team
User avatar
Betsy.jiang
 
Posts: 1424
Joined: Tue Sep 06, 2016 8:30 am


Return to Spire.XLS

Who is online

Users browsing this forum: Jane.Bai and 0 guests