Ask a question Report

Import webpage data into Excel spreadsheet [Solved]

Jeffrey - Latest answer on Jul 23, 2010 03:50PM
Hello,
I am attempting to import the web page data from "http://bet1.hkjc.com/..." through EXCEL - new web query function but unsuccessful, the 'odds' data cannot be captured. Any idea? Thanks.
Read more 
Answer
+27
moins plus
There are four steps to it, which are defined below:
Step 1:
Click on External Data ribbon, go to the "Import" section and click on XML file option.

Step 2:
Use the browse option to go to the location where the XML file is located from which data needs to be imported. Click Open and then OK.

Step 3:
Access will scan through the file and display the structure of the table to be created. The Import Options includes the following options, namely Structure Only / Structure & Data / Append data to existing table. In our process we will choose the option of both structure and data.

Step 4:
If you plan to import the same file agian in the future then you can check the box "Save Import Steps".

Now you can double click on the table that is created and would be able to see the structure and the data in it i.e. imported from the XML file.

Eliza
http://bit.ly/ceH3Nr
Add comment
Answer
+6
moins plus
Same problem faced me that Excel Web Query not returning data from table constructed from javascript. I am trying to make a query that will pull data off of below URL, however if I select the table no data is returned by reject message ""This Web query returned no data. To modify the query ....". I think it might have something to do with the fact that the table is contained within some javascript tabs.

http://support.dell.com/...

Really all I need from this page is the days left number in the bottom right.

Thanks and Regards,
Ringo
soni- Apr 20, 2009 06:20AM
Hi,

I have created a reporting page and program in .cs.
My problem is datareader should read data from stored procedure into an excel object and save it.Then i should send the data as report.
When i debug I can view the values but If I execute the page my excelsheet is blank?

When i run the procedure it gets me 1200 of row of data.
Please help .....................


thanks,
Reply
Add comment
Answer
+4
moins plus
You can use VietSpider XML from

http://sourceforge.net/projects/binhgiang/files/

Download VietSpider3_16_XML_Windows.zip or VietSpider3_16_XML_Linux.zip

VietSpider Web Data Extractor: Software crawls the data from the websites ((Data Scraper)), format to XML standard (Text, CDATA) then store in the relational database. Product supports the various of RDBMs such as Oracle, MySQL, SQL Server, H2, HSQL, Apache Derby, Postgres ...VietSpider Crawler supports session (login, query by form input), multi-downloading, JavaScript handling, proxy (and multi-proxy by auto scan the proxies from website)...
Add comment
Answer
+3
moins plus
I found it...
this page explains everything. It's an Excel feature. Chose Data -->Import External Data-->New Web Query...the site will guide you through completion.
http://www.exceluser.com/explore/webqueries_1.htm
Add comment
Answer
+2
moins plus
Actually, the New Web Query function does not work on this web page. It always rejected with fatal error "This Web query returned no data. To modify the query, click OK, click the name of the external data range in the name box on the formula bar, and then click Edit Query on the External Data toolbar". Any further idea to solve it. Thanks in advance!
Roger- Feb 3, 2010 08:51AM
I can do this with visual basic easily. Email Id removed for security
Reply
BigUglyGuy 2Posts Friday July 2, 2010Registration date July 2, 2010 Last seen - Jul 2, 2010 08:55PM
Can you please help me? I need to copy info from a web page to excel spreadsheet.
Reply
Add comment
Answer
+2
moins plus
hi,
i want display my dataset in excel sheet using windows application in c#.

Thanks & Regards
VIKRAM REDDY GADDAm
Add comment
Answer
+2
moins plus
I wrote a program that loops through a spreadsheet, goes to the right webpage and extracts the fields that I want saving it in the corrisponding cells. I designed this originally to do a crapload of Zillow searches. I'm not selling my code, but if itis a onetime project and you need me to run it for you. Please email me at Rogie3@yahoo.com. I used Visual Basic and it does about 1200 searches per hour.
TIN- Mar 3, 2010 11:48AM
Hi,

Can you send me the way to run java webpage into the Excel spreadsheet?

Thks,

TIN
Reply
sunny- Mar 6, 2010 02:14PM
Saw your post on this site. I use an automation software to automatically go to sequentially progressive webpages and then save them. Then they are bulk processed for data.

Can you help me get data (including images) from a database driven website and save the data in an excel sheet?

Email Id removed for security
Reply
congokin- Mar 19, 2010 04:41PM
i am interested in your program. can you send it to me?
Email Id removed for security
Reply
sikto- May 20, 2010 08:23AM
How to excel file read in web page ! ! !
Reply
andrew- May 25, 2010 08:31PM
Hey i need some help and it sounds like you have it worked out really well , I'm trying to import web data "from nolathane" and import it into a excel sheet , i can make a sheet with all the part numbers , but i don't know how to make excel retrieve the web data from the part list ,

The web url just needs a referance to get each part number , ie part 49154 number's info page is http://www.nolathane.com.au/product_detail.php?part_number=49154&sans_vehicle=1
And the evocom1 kits page is
http://www.nolathane.com.au/product_detail.php?part_number=evocom1&sans_vehicle=1
i want to get all the info below the search again button and have it populate a excel sheet one product per page " we use this information to make product listings" ebay zen cart etc

can you help me at all?... or point me in the right direction please ? there are a few other sites we use that this could be helpful with ?


Reguards ,
Andrew
http://www.ultracheapauto.com.au
Discount Car Parts For You!!
Reply
Add comment
Answer
+2
moins plus
Hi this article,may be helpful "how to export a iamge into excel using asp.net" in http://netprogramminghelp.com
Add comment
Answer
+2
moins plus
Use ctrl C and ctrl V. That works for me
Add comment
Answer
+1
moins plus
I'm looking for this too..let me know if you find it...i'll do the same
Roger- Feb 3, 2010 08:49AM
They make it difficult to strip data from websites on purpose. Excel cannot pull anything in Java or Ajax ect. I can use Visual Basic to creat a program that can do it by breaking everthing down to text. Please email me at Email Id removed for security and pass the word that I can do this when the excel method fails. Thanks
Reply
chenjo87- Jun 23, 2010 07:04AM
i want to transfer some data in html page into an excel sheet and to automate it... is there any tool available for this..
anyone help me.....
Reply
stuccohound- Jul 23, 2010 03:50PM
I have done this before and created a Word Macro. The Macro was stolen along with the lap laptop.

Here is what you do! Go to webpage. Go to View and select Source. Scroll down to the area the text is located. Copy the data along with html. Paste into Word or other word processor. Select segments of html and use cut and replace to convert html to delimited text fields.
Reply
Add comment
Answer
+1
moins plus
yes i have done the same thing what u want but the only thing is u have to login again and again throughthe import function where u want to import the data
Add comment
Answer
+1
moins plus
i think you can copy all data you want
then on the Excel data Worksheet Right Click -> Paste Special, select Text then OK
it works with me ( Windows XP SP2, Microsoft Office 2007, Mozilla Firefox )
Add comment
Answer
+1
moins plus
I Need Help for That Problem by Dharmaprabhu
Add comment
This document entitled « Import webpage data into Excel spreadsheet » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.

Not a member yet?

sign-up, it takes less than a minute and it's free!

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.