Assuming new XLSX format -- I had one of these and opening it, the sheets contains the last cached value that was in the excel workbook. POI can read that value without issue. Now if you need the latest data then that's another issue.
On Wed, Jun 10, 2015 at 7:33 AM, Mark Beardsley <[email protected]> wrote: > I think it is necessary to link the worksheet to an external data source to > do this, something that would normally be done from within Excel itself - > starting by clicking Data on the ribbon. How you could accomplish this from > within POI I do not know. Also, that is think, as I am far from being an > Excel guru. > > May I ask please, is the workbook you have in the older binary format (an > xls) or the 'newer' xml based one (an xlsx)? If the patter, I would be > inclined to unzip the archive and have a dig around. Aside from that piece > of sage advice, I have nothing else to offer, sorry, but am intrigued to > see > what the answer may be. > > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/embedded-SQL-queries-tp5719060p5719061.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] > >
