JExcelApi

• http://jexcelapi.sourceforge.net/ (Last Update 2009-10-26)

• Locking cells in a JXL-generated Excel document
• data validation field in excel

jxl.write.WritableWorkbook.addNameArea(
 java.lang.String name, // name to be created.
 WritableSheet sheet,   // sheet containing the name
 int firstCol,          // first column this name refers to.
 int firstRow,          // first row this name refers to.
 int lastCol,           //  last column this name refers to.
 int lastRow            // last row this name refers to.
)

Attention au nom du range, pas de caractère exotique ni espace…