If I take the "New, generic SS Usermodel Code" at
http://poi.apache.org/spreadsheet/converting.html and add to it the
following section:
wb.createName();
right after
Workbook wb = wbs[i];
then the output workbook.xlsx cannot be opened by Excel.
Am I doing something wrong with the name?
When creating names, you are supposed to set the name name and the reference:
Name name = wb.createName();
//the following two lines are required:
name.setNameName("unique_id");
name.setRefersToFormula("'Sheet1'!$E$11");
Yegor
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
