On Wed, 10 Feb 2021, Ash B wrote:
While reading the file in java , getting below issue .
java.lang.IllegalArgumentException: Invalid CellReference:1A
at org.apache.poi.ss.util.CellReference.seperateRefParts
A cell reference of 1A is invalid - it should be A1.
Where is this problematic file coming from?
If you rename the .xlsx file to .zip, unzip and check the sheet xml files,
can you see the 1A reference there? If so, can you please share the
xml snippet?
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
