Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jexcel problem with empty cells

 
Raphael Okochu
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic