Hi ,
Sorry if the question has been asked before but couldn’t find it in the archives. With EXCEL 2010 it is now possible to format ranges of cells as table (with header and all). If you look in the names manager you see these ranges listed with array’s bounds. I tried to access these ranges using the XSSFWorkbook.getname(String) method, but it keeps returning a null pointer. Does that mean that these named ranges are hidden from the outside ? or is there something I should do to enable this access ? I’m using POI 3.7. Attached is an XLSX file and a sample java code giving example of what I’d like to do. Any comments is welcome J. Thanks for any hint J. Take care, Marco.
test.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
