[Solved] Link to External data

Discuss the spreadsheet application

[Solved] Link to External data

Postby jim409 » Sun Aug 12, 2018 5:29 am

I am trying to add data from a website every hour. I want to add the data at the bottom of the column, but I end up over writing previous data. I have tried a few Macros to no avail.
Last edited by Hagar Delest on Sun Aug 12, 2018 5:40 pm, edited 1 time in total.
Reason: tagged [Solved].
Open Office 4.1.2 Windows 10
jim409
 
Posts: 2
Joined: Sun Aug 12, 2018 5:09 am

Re: Link to External data

Postby Zizi64 » Sun Aug 12, 2018 6:43 am

I am trying to add data from a website every hour.

The "External link" function will work with same selected cell range. It always will rewrite the existing data.

If you want to collect the data into a "mini database", then you must use your own macro, and you need some listener what will able to launch your macro when a new data is arrived, and the macro will able to add the newest data to the data list in a helper cell range. You can enumerate the count of the the existing data, and you can put the new data into the first empty row by the macro.

similar topic:
https://forum.openoffice.org/en/forum/v ... 45&t=30071
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.0 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 6980
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Solved Re: Link to External data

Postby jim409 » Sun Aug 12, 2018 10:33 am

Thank you! I had never used [b]listener[/b] function.
Open Office 4.1.2 Windows 10
jim409
 
Posts: 2
Joined: Sun Aug 12, 2018 5:09 am


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 50 guests