when I run this, somewhere in the middle, it produced a java.lang.NullPointerException.
I tried to investigate, the error stopped a row blank row. I was wondering because it did not generate an error for the previous blank rows. I went to my excel file, and, i highlighted the sell, and set the background color to "no fill" (current is already no color/no fill). After that, code went thru...
Is there a way for me to code this that it will detect the right color of the cell, without throwing this exceptions? I think the exception is really weird..>
it gave me a blank output. I also tried to put in an if statement to check if the code below returns a null. But it doesn't return null..
The getContents is not in the initial code I gave. I just played around to check what seems to be the problem.
Here is the stacktrace thrown by the Exception (below). The first 3 lines are success. Just to give you an idea. The number are the row numbers in excel. Then after the dash, is the color description of the cell.
After row 28, it gave me the null pointer exception. The supposedly 29 row is a blank row. Then it continued to the next.