How to import external data from website to Calc?

Discuss the spreadsheet application

How to import external data from website to Calc?

Postby lok » Sun Nov 25, 2007 5:00 pm

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 ?
lok
 
Posts: 1
Joined: Sun Nov 25, 2007 4:36 pm

Re: How to import external data from website to Calc?

Postby Hagar Delest » Sun Nov 25, 2007 10:29 pm

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 ?
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28626
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: How to import external data from website to Calc?

Postby huw » Tue Dec 04, 2007 3:28 pm

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.
huw
Volunteer
 
Posts: 417
Joined: Wed Nov 21, 2007 1:57 pm

Re: How to import external data from website to Calc?

Postby TerryE » Tue Dec 04, 2007 9:31 pm

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
Ubuntu 11.04-x64 + LibreOffice 3 and MS free except the boss's Notebook which runs XP + OOo 3.3.
TerryE
Volunteer
 
Posts: 1402
Joined: Sat Oct 06, 2007 10:13 pm
Location: UK

Re: How to import external data from website to Calc?

Postby Hagar Delest » Tue Dec 04, 2007 9:34 pm

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.
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28626
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

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