This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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
removeRow() in AbstractTableModel
Read Excel Sheet Using Java
POI - empty excel rows.
Created Excel file is missing something
facing diffculties while comparing two excel sheet using poi