Page 1 of 1
How to import external data from website to Calc?
Posted: Sun Nov 25, 2007 5:00 pm
by lok
My os is Xp . OpenOffice version 2.3.0
Trying to import the data from this website into Calc
http://biz.thestar.com.my/marketwatch/main.asp?clp=4
After pasting the above link, the OK button remain dim, nothing happened.
please help ?
Re: How to import external data from website to Calc?
Posted: Sun Nov 25, 2007 10:29 pm
by Hagar Delest
Could you please detail what you're trying to do exactly ? There is nothing at the end of your link (the site returns "Sorry, No Data Available").
Do you want to copy & paste some data ?
Re: How to import external data from website to Calc?
Posted: Tue Dec 04, 2007 3:28 pm
by huw
Often in OpenOffice, filling an input dialogue line with paste is not detected. I usually add a space to the end of what I pasted, and then delete it again. The OK button becomes active as soon as I hit the space bar.
Re: How to import external data from website to Calc?
Posted: Tue Dec 04, 2007 9:31 pm
by TerryE
I could open the URL in Firefox, select the table and paste it into a blank sheet, and this worked fine, since paste understands html data. What this doesn't do is to give you an "Import from Web page" function based on a given URL. The URL is invalid for doing an Insert -> Link to External Data. That's the functionality, I'm sorry to say. It doesn't work in Excel either
Re: How to import external data from website to Calc?
Posted: Tue Dec 04, 2007 9:34 pm
by Hagar Delest
TerryE wrote:I could open the URL in Firefox, select the table and paste it into a blank sheet, and this worked fine, since paste understands html data.
+1.
Don't know why the site was not available before.