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