Re: Invalid CellReference:1A

Nick Burch <[email protected]> Wed, 10 Feb 2021 11:46:37 +0000 (GMT)

Newsgroups	gmane.comp.jakarta.poi.user
Message-ID	<[email protected]>

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