Re: Invalid CellReference:1A

On 2021/02/10 11:46:37, Nick Burch <[email protected]> wrote: 
> 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]
> 
> 

Hi Thanks for you mail . 
I tried as suggested . Below is the code snippet . Could not share more ,as the code is on client's machine and manually typed it . 
<?xml version="1.0" encoding="utf-8"?>
    <x:worksheet xmlns:x="https://schemas.openxmlformats.org/spreadsheetml/2006/main">
        <x:sheetData>
         <x:row r="1"> 
           <x:c r="1A" t="inlineStr" s="2"> 
	 <x:is>
           <x:t>ID</x:t>	
         </x:is>
        </x:c>	
       <x:c r="1B" t="inlineStr" s="2">