Invalid CellReference:1A

Ash B <[email protected]>
Newsgroups gmane.comp.jakarta.poi.user
Message-ID <pony-495d689464ae675b141e19963bf8d5e86f353830-2ea097385f57181aca2c169b30b41d7224dbb845@user.poi.apache.org>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.