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

[gormleymark]

As in how do I import the code here. Do I need to make a library with what's here or something else? I'm trying to make a library with all this but getting lots of errors.

[FranzJr]

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.

[gormleymark]

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!

[gormleymark]

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.

[FranzJr]

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

[gormleymark]

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?

[FranzJr]

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.