On 18-07-16 18:20, Paolo Debortoli wrote:
Hi. I am working on a calc sheet and need to insert data from an url:
https://finance.google.com/finance/info?client=ig&q=NASDAQ%3aAAPL
I guess it generates a csv output (in the browser it is like:
// [ { "id": "22144" ,"t" : "AAPL" ,"e" : "NASDAQ" ,"l" : "99.92" ,"l_fix" : "99.92" ,"l_cur" : "99.92" ,"s": "0" ,"ltt":"12:13PM EDT" ,"lt" : "Jul 18, 12:13PM EDT" ,"lt_dts" : "2016-07-18T12:13:44Z"
,"c" : "+1.14" ,"c_fix" : "1.14" ,"cp" : "1.15" ,"cp_fix" : "1.15" ,"ccol" : "chg" ,"pcls_fix" : "98.78" } ]). I would need to isolate the number with 'l' label and insert it into a cell.
I also tried menu -> link external data -> url; it opens the page, sees the
table, but doesn't show it in the dialog box (with the checkbox 'update every x
seconds' .... bug??).
Thanks if you can help.
Paolo
The data you see is in JSON format
https://en.wikipedia.org/wiki/JSON
someone tried to make an extension for it 2 years ago, but it seems to
be not released right now:
http://extensions.libreoffice.org/extension-center?path=%2FLibreOffice-Extensions-and-Templates%2Fextension-center&portal_type=PSCProject&SearchableText=json
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
