Read range name from Excel

[jaryszek]

Hi Guys,

I am total newbe but i have to know how to read named range in apache poi.

I am trying only to read value for named range.

I am using code like:

	public static void main(String[] args) throws IOException {
		
		
	
	    // setup code
	   	    String cname = "TestName";
	    
	    org.apache.poi.ss.usermodel.Workbook wb = null;
		try {
			 wb = WorkbookFactory.create(new File("C:\\Users\\admin\\Desktop\\Example Variable3.xlsm"));
		} catch (EncryptedDocumentException | InvalidFormatException | IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		int namedCellIdx = wb.getNameIndex("TestVariable");
		
		System.out.println(namedCellIdx);
	    org.apache.poi.ss.usermodel.Name aNamedCell = wb.getNameAt(namedCellIdx);
	    
	    System.out.println(aNamedCell);

	    }

	}

and my error is :

Exception in thread "main" java.lang.IllegalArgumentException: Specified name index -1 is outside the allowable range (0..0).

Can you help me how to fix this ?

Best,
Jacek

[jaryszek]

And my output is:

Attachment 7369

[jaryszek]

In attachment please find my example workbook.

I wnat to read named Range "Test" and "TestVariable".

Best,
Jacek

[jaryszek]

Anyone?

Jacek

[jim829]

Normally, a few days is not too long to wait. But this forum has not been very active this year (not sure why). So you may need to try some other forums. But when cross-posting, let each forum know where you've posted as a courtesy to avoid duplication of responses.

Regards,
Jim

[jaryszek]

Hi Jim,

thank you,
can you recommend some other java forums? :)

Best,
Jacek

[jim829]

Try https://coderanch.com

Regards,
Jim

[jaryszek]

thank you Jim!

Strange, a lot of people is wathing this topic but nobody answers.

Best,
Jacek

[SurfMan]

What happened when you tried this: https://poi.apache.org/apidocs/org/a...odel/Name.html

[jaryszek]

thank you Guys,

problem solved here:

https://coderanch.com/t/694322/java/...ctured#3259050

Best,
Jacek