We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Check if the worksheet column is empty/blank using Aspose.Cells for Java

Hi, I want to check if the column is empty/blank. Is there any method to check this?

Thanks,

Rohan


This message was posted using Page2Forum from community/public/documentation
After converting to pdf -file is corrupted
Cell.HtmlString is erroring out while setting the value- for a value
Range of sheets in formula has been changed after sheets are reordered
Alignment problem when i save as text file
Excel with circular error's showing values instead of error string
Aspose cells using ProtectedRange to allow domain users/groups edit permissions
Aspose.Cells for .NET - Add Page Header problem (XL#Webserve)
Corrupted file with new aspose version
Issues with custom formats
Cell.HtmlString is erroring out while setting the value- for a value
ROUND function cannot round a value greater than 922337.20
Saving Workbook (.xlsm) Removes Excel Table Array Formulas
Set color for Sub total in Pivot table
Performance problem with Autofit
Aspose.Cells for .NET - xlsx to pdf Japanese Day problem (XL#winbird)
Pivot Table causing error in excel templates(2007 and 2010)
Formula and language issues in connection with SheetRender (XPS)
After deleting one row in worksheet and saving the Excel file becomes corrupted in .NET
High memory usage during and after xls file conversion
Smart markers. Sub totals are calculated in incorrect order
AutofitColumns ... doesn't
[7.3.1.0] Pivot tables theme issues
German language issue Conditional Format - SheetRender
Crash excelfile viewer
Upgrading 6.0.1 to 7.3.1: WorkBookDesigner.SetDataSource() fails
Alignment problem when i save as text file
Chart Series Names are lost if CellCollection is cleared
Aspose Error & Performance Issue
Pie and Scatter Charts don't work if CellCollection is cleared
Hidden pictures disappears after worksheed copying
Worksheet corruption after open
Sheet not calculating formula's
Reg:Text box in chart in 2.5.4.1
Unable to generate Chinese PDF from Excel using Aspose Cell in Multi-Threaded environment(Weblogic 10.3)
"Excel found unreadable content..." error
Pivot table with Data Filter seem bit buggy
Bug when calculating workbook after mapping in value to a cell
Open excel without saving in local drive
Set secondary category axis tick labels' position in Java
Xml exception while saving a workbook
Workbook(inputstream) not working in Aspose 7.1.0
Saving XLSX with scatter plot enables extra options
Issues with custom formats
Table: Convert To Range
Unable to generate Chinese PDF from Excel using Aspose Cell in Multi-Threaded environment(Weblogic 10.3)
Image clarity issue in excel oleObject in Slides for pptx**** WorkStopper ***** Immediate Attention is needed *********
Set secondary category axis tick labels' position in Java
Chart title color not preserved upon save
[7.3.1.0] Pivot tables theme issues
Excel Xlsb size Issue - Pick List vanishes
Saving Data and Pivot Table : Getting ClassCastException: Integer cannot be cast to Double
Row height using AutoFitRows (for merged cells) with IsTextWrapped option on is wrong in .NET
Aspose.Cells cannot shift nonblank cell off the worksheet in import data table method
Generating thumbnails on server

Hi,

There is no quick way. You will have to iterate the column cells and check if they are blanks or with contents.

Hi,

That would be time consuming! Just like aspose has Cells.iterator it also has Columns.iterator. But if i get an iterator for column it does not fetch any records. i.e. if i do iterator.hasNext it returns false even if there is data in CSV file. The Cell.iterator works fine. Whats might be the problem?

Thanks,

Rohan

Hi,

You can create a range object, then you can use iterator of range object to iterate the cells.

For example, you want to traverse the cells in column number 6, so you can define a range something like this

(0,5, 12300, 5), then using the iterator, you can traverse all the cells from F1 till F12301.

Hi,


The iterator returned by ColumnCollection is for accessing every custom Column object, not cell objects in one Column. To access cell objects in specified column, you have to iterate cells from Cells.iterator() and check whether one Cell’s column index is equal to specified column. If it can fit your requirement, we may also add one new method such as Cells.isBlankColumn(int columnIndex) for you which will check whether given column does not contain any data.


Thank you.

Hi,

That will help! Given a Column Index if i am able to find if the column is blank using this Cells.isBlankColumn method then that would be great.

Thanks,

Rohan

Hi,

Thanks for your feedback.

We have added a New Feature Request in our database.

Once, it is available or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSJAVA-40122

Hi,

We have fixed this issue. Please download: Aspose.Cells for Java (Latest Version)

Now we have added one new method:
Cells.isBlankColumn(int columnIndex)

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


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.