Aram, Mark— It's an .xlsx and in this particular case, it's kind of dumb. Well, VERY dumb. To where one link can and should be replaced by a simple calculation, and the other is a whopping four values, updated yearly. So, yeah, I don't think it's a big issue in this case, and it's probably a case-by-case thing, e.g., my solution already looks up values in databases for some situations, so there's no reason I couldn't expand that. Just curious as to what others do.
Actually, it hadn't occurred to me until now, but I may be in a small minority of people reading arbitrary workbooks. Maybe most people are using it to output Excel or read very specific spreadsheets. On Wed, Jun 10, 2015 at 5:00 AM, Aram Mirzadeh <[email protected]> wrote: > 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] > > > > > -- *Blake Watson* *PNMAC* Application Development Manager 5898 Condor Drive Moorpark, CA 93021 (805) 330.4911 x7742 [email protected] <[email protected]> www.PennyMacUSA.com <http://www.pennymacusa.com/>
