Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Programmatically change and update link to external data

I want to write a macro that updates a sheets link to external data. The data is a table in an HTML-file.

I've looked at Document.SheetLink but it seems there is no actual link there altough there is one entry, and I can't seem to write to that.

I've also tried Sheet.Link(url, sheet, filter, filter_options, mode) and it seems that updates some type of link because if the URL is incorrect Calc displays "Link could not be updated" and shows the incorrect link. But if the link is correct nothing changes.

I'm doing this in LibreOffice Basic.