Apologies, not an issue with the code itself. I'd just like to know how to use it. about sjxlsx HOT 6 OPEN

What I did, I create a private repository, then I add the maven Dependency into the pom of my own project, so the will try to download from my private repository into to my local .m2 repository, so the dependency will be result and all the errors will be done.

Let me know if need more help.

from sjxlsx.

Honestly I'm pretty new so going to have to search how to use maven. I've seen it mentioned in places but have no idea how to use it or what it is!

from sjxlsx.

Yea I'm going to need a little help here. I've tried making a maven project and adding this project as a dependency but it says the package com.incesoft.tools... does not exist.

from sjxlsx.

You must to create a private repository, because the package aren't in maven cloud.

from sjxlsx.

I got it! Although I have another issue. When reading an excel file it will return some empty cells as string "null" (for example A1=null) but others give a java.lang.NullPointerException. For reference I'm using the sample code below

private static void printRow(int rowPos, Cell[] row) {
    int cellPos = 0;
    for (Cell cell : row) {
        System.out.println(Sheet.getCellId(rowPos, cellPos) + "=" + cell.getValue()); 
        cellPos++;                       
    }
}

Why are some empty cells OK but others throw an exception?

from sjxlsx.

Because the format of each cell. Depends of each cell what format are you using, so they take the cell has an empty value "" but other cells doesn't have any format so they get as a null value.

from sjxlsx.