Hi All ,
We are receiving an excel file (.xlsx) from Client , for reading and processing
.
We are using below apache.poi dependency , latest version.
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>5.0.0</version>
</dependency>
While reading the file in java , getting below issue .
java.lang.IllegalArgumentException: Invalid CellReference:1A
at org.apache.poi.ss.util.CellReference.seperateRefParts
On further analysis , we found that if we open the file and just do simple
save (Ctrl+S ) without modifying anything ,it works and able to read and
process the rows in a code.
Else we face above issue .
Could you please suggest , what needs to be done ?
Thanks
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
