Tags: qaf-tm/qaf
Tags
Updated dependencies - removed jxl dependency, xls files will be handled using poi. log4j 1.x was one of the dependency from jxl. By removing this dependency now log4j also will not get resolved. User can add any library of their choice for logging. - removed commons-lang dependency, will be resolved by commons-io - updated commons-io version from 2.5 to 2.11.0 - removed slf4j-log4j12 dependency. Now log4j is not required or resolved, removing this dependency. - added poi dependency with compile scope. It should exclude transitive dependencies from poi-ooxml. Updated poi version from 4.1.2 to 5.0.0
Closed #386 Fixed `NullPointerException` in `PoiExcelUtil.getTableDataAsMap` when last column is empty Code enhancement to provide empty or blank cell with null value. Example data is as below: Before this update: EXLS {Id=1.0, firstname=Test1, lastname=L1, activated=true, created=Mon Mar 01 00:00:00 PST 2021, version=1.1, [email protected], index=1.0} {Id=2.0, firstname=Test2, lastname=L2, activated=false, created=Tue Mar 02 00:00:00 PST 2021, version=1.2, [email protected], index=2.0} {Id=null, firstname=Test3, lastname=L3, activated=true, created=Wed Mar 03 00:00:00 PST 2021, version=1.3, [email protected]} {Id=4.0, firstname=Test4, lastname=L4, activated=false, created=Thu Mar 04 00:00:00 PST 2021, version=1.4, [email protected], index=4.0} XLS {Id=1.0, firstname=Test1, lastname=L1, activated=true, created=Mon Mar 01 00:00:00 PST 2021, version=1.1, [email protected], index=1.0} {Id=2.0, firstname=Test2, lastname=L2, activated=false, created=Tue Mar 02 00:00:00 PST 2021, version=1.2, [email protected], index=2.0} {Id=, firstname=Test3, lastname=L3, activated=true, created=Wed Mar 03 00:00:00 PST 2021, version=1.3, [email protected]} {Id=4.0, firstname=Test4, lastname=L4, activated=false, created=Thu Mar 04 00:00:00 PST 2021, version=1.4, [email protected], index=4.0} After this update: XLSX/XLS {Id=1.0, firstname=Test1, lastname=L1, activated=true, created=Mon Mar 01 00:00:00 PST 2021, version=1.1, [email protected], index=1.0} {Id=2.0, firstname=Test2, lastname=L2, activated=false, created=Tue Mar 02 00:00:00 PST 2021, version=1.2, [email protected], index=2.0} {Id=null, firstname=Test3, lastname=L3, activated=true, created=Wed Mar 03 00:00:00 PST 2021, version=1.3, [email protected], index=null} {Id=4.0, firstname=Test4, lastname=L4, activated=false, created=Thu Mar 04 00:00:00 PST 2021, version=1.4, [email protected], index=4.0}
PreviousNext