[Solved] Updating external link data

[gurkand]

Hi All,
My Calc workbook has links to external data and after "Enabling" these connections, some of them fail to update. When I notice the failed ones, I have to update that specific one manually.
How can I do this within the script (LibreOffice Basic) that I am already running for manipulating the data afterwards?
ie. if Cell is "" Then <reload/update that specific link>
Is there a command that I can use in this kind of a logic?
Thanks in advance.

[JeJe]

macro for updating all links here:

viewtopic.php?f=20&t=6004#p28037

[gurkand]

Hello All,

I am trying to update the 4th link as seen in the list of links.jpg.

The macro I wrote for this, and the error message when I try to run are also attached as the error message.jpg.

Any help for this, please?

Thanks in advance.

[UnklDonald418]

Since the error message indicates there are fewer than 5 links on your spreadsheet, try adding 2 lines to help with debugging.
Immediately after defining oDocument add

Code: Select all

print oDocument.Title
print oDocument.SheetLinks.Count

The first to verify that oDocument is referring to the correct document.
The second to determine how many links the document supposedly has.

[Villeroy]

The html links in the screen shot aren't SheetLinks. These are AreaLinks.

[gurkand]

Many thanks for your help.

It is working now.

If you could tell me where I can I find the options that are avail like AreaLinks / getbyIndex() / refresh() I will appreciate that.

[Villeroy]

In the API documentation and with the help of MRI or any other object inspector.

[JeJe]

What I do is type in OpenOffice plus the search word into a search engine.

OpenOffice AreaLinks second result is this page which has the relevent links to the OpenOffice API reference:

https://wiki.openoffice.org/wiki/Docume ... Area_Links

You'll often find someone has had the problem before and there'll be a thread like this one - which you can also find in the search box at the top of the page.