Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I was on Windows (if that matters) and it seems that a correct URL to a file needs to start with file:///C:/path/to/file. Note the three slashes after the colon.

What threw me off was that if you do, "sheetname", "", "",

which seems correct according to the API documentation, for an HTML-file the "sheetname" will not work even if that is one of the tables prompted when you do Sheet->Link to external data.

Probably this can only be used if you link another Calc-sheet, although I'm guessing here.

So three slashes in the URL and an empty string as the sheet name in Sheet.Link() works like I want it to.