Nick Burch-2 wrote > > negatron wrote >> Problem is that I want to adapt the path to the external reference. >> The named range can point to a file or another (test.xlsx or test2.xlsx) >> given the inputs on the Java interface. >> Each time I change the name of the file (test.xlsx), I would have to >> open my >> Excel file (main.xlsx) and change the external reference which is not >> very >> practical. > Why not add two named ranges, or formulas in a hidden sheet, one pointing > to each of the two possible workbooks?
In fact I have 31 possible external files. Anyway I tried this solution and it works like a charm. Now I have to define all the possible named range in my main Excel file :-) Nick Burch-2 wrote > Well, or contribute the missing bit of functionality so everyone can use > linkExternalWorkbook :) I am quite new in Java programming and unfortunately I don't think I could do anything useful to contribute :-) Thank you for your help! Patrick -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Error-defining-external-XSSFName-tp5717292p5717301.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
