aspose file tools*
The moose likes Other Open Source Projects and the fly likes jexcel problem with empty cells Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "jexcel problem with empty cells" Watch "jexcel problem with empty cells" New topic

jexcel problem with empty cells

Raphael Okochu

Joined: Jul 17, 2009
Posts: 22
Hi all.
Im trying to process an excel Sheet in rows. Im trying to retrieve the string contents of all the cells.
How do i replace empty cell contents with an empty string values.
Whenever i iterate, trailing empty cells are trimmed off, and empty rows return an empty array.

here is a simplified snippet from my code

I get rows with varying lengths and rowList is empty where the sheet has an empty row. i.e [] instead of [, , , , , ,..... , , ,]

Thanks in advance

I agree. Here's the link:
subject: jexcel problem with empty cells
Similar Threads
Created Excel file is missing something
facing diffculties while comparing two excel sheet using poi
Read Excel Sheet Using Java
removeRow() in AbstractTableModel
POI - empty excel rows.