On Thu, 4 Dec 2014, negatron wrote:
Nick Burch-2 wrote
What happens if you define a link to test.xlsx before referring to it in
formulas?
What do you mean? How can I define a link to my file?
You need to use the cunningly titled "linkExternalWorkbook" method on the
workbook you want to then define the name on:
https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/Workbook.html#linkExternalWorkbook%28java.lang.String,%20org.apache.poi.ss.usermodel.Workbook%29
Do you mean that I have to open my Excel file with Microsoft Office and
create the defined name?
That is the other way - if a workbook already has a link defined to an
external workbook, then POI can re-use that link when defining additional
names or formulas to it
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
