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?
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.

E-iceblue support team
User avatar
Posts: 1694
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS

Who is online

Users browsing this forum: No registered users and 0 guests