Free Support Forum - aspose.com

Delete Blank Rows and Columns from Excel file using Aspose.Cells for Java

I want to Delete All Balank Rows and Columns from an Excel Sheet Using Java. .NET has similar type of functionality (sheet.Cells.DeleteBlankRows()) but not in java.

Help Required.

Thanks

Hi,

Yes, I am afraid the Java version of Aspose.Cells does not support this feature (Deleting blank rows/columns in the worksheet). I have logged your feature request into our issue tracking system with an issue id: CELLSJAVA-8458. We will look into it soon.

Thank you.

Is there any way to detect a blank row or column

Is there any way to detect a blank row or column.

Hi,

As we told you that we will implement it soon.

I think, now, as a workaround you may browse or loop through each cell in a row/column to check whether it is null or not. I think you may use Cell.getValue() to check if it is ValueTypeType.NULL or blank.

Thank you.

Hi,

Please try the attached version. We have supported your requirement of deleting blank rows/columns, the new
APIs are:
Cells.deleteBlankRows()/Cells.deleteBlankColumns()

Thank you.

The issues you have found earlier (filed as 8458) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.