NullPointerException when using system.dataset.fromExcel() on dataset with an empty cell

[jaysettle]

I'm getting a NullPointerException when trying to import excel data via system.dataset.fromExcel() that has empty cells like the following:

Excel sheet attached.
data1.xlsx

Script I'm using:

excelFilePath = "C:\Users\jayen\Documents\data1.xlsx"
dataset = system.dataset.fromExcel(input=excelFilePath, headerRow=0, sheetNumber=0)
system.util.getLogger("ExcelImportScript").info("Starting Excel import..." + str(dataset))
system.dataset.print(dataset)

Thanks for the work put into this. We found your module looking for efficiencies in our current work flow working with a customer with a lot of excel sheets.

[paul-griffith]

This should be fixed as of #48, but isn't yet available in a public release. If you'd like, you can check out the repo, build the unsigned module locally (or self-sign it) and test out the fix. I'll probably release a new public version in the next week or two.

[jaysettle]

Thanks!

[jaysettle]

The fix worked thank you! I'll check back for the public release soon.

[paul-griffith]

I went ahead and released 0.8.0:
https://github.com/IgnitionModuleDevelopmentCommunity/ignition-extensions/releases/tag/0.8.0