Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

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

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: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS