poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aram Mirzadeh <...@mbcli.com>
Subject Re: embedded SQL queries
Date Wed, 10 Jun 2015 12:00:51 GMT
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 <markbrdsly@tiscali.co.uk>

> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message