open office question on importing data

Asked by james addonizio on 2014-01-21

i downloaded a excel spreadsheet to open office. The spreadsheet receives its data from a website and all i had to do was to change the "team id" number on the spreadsheet and click on get information from web and it would extract all the data and update the spreadsheet. How can i do it now??

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
2014-01-22
Last reply:
2014-01-23

Do what? It sounds like you already did whatever "it" is.

Can you please clarify the question.

Thanks

james addonizio (addyyy14) said : #2

Import the data, what i explained was how it worked with microsoft excel. I downloaded the spreadsheet to Open Office and that function does not exist. I want to know how i can update the spreadsheet in Open Office. the cell where i change the team id does not work. It does not update nor does it go to the internet and try to get the data to import. Is there a way to do it in Open Office.

Tony Pursell (ajpursell) said : #3

There is a reference to 'Inserting External Data in Table (WebQuery)' in Help, which says 'With the help of the Web Page Query (LibreOffice Calc) import filter, you can insert tables from HTML documents in a Calc spreadsheet'.

Is this what you are asking about?

Can you help with this problem?

Provide an answer of your own, or ask james addonizio for more information if necessary.

To post a message you must log in.