Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: How To Retreive Data From A Website And Display In Table

27 Dec 2012   #1
Pedroc1999

Windows 7 Ultimate x86
 
 
How To Retreive Data From A Website And Display In Table

I am trying to 'track' the prices of computer parts on 2 different online stores, I would like to have excel display the product name , price , and total price of all in a table. Is this possible.

example product :

Corsair Memory Vengeance Low Profile Jet Black 8GB DDR3 PC3-12800 CAS 11 Dual Channel Desktop - CML8GX3M2B1600C11 - Scan.co.uk


My System SpecsSystem Spec
.

28 Dec 2012   #2
Pedroc1999

Windows 7 Ultimate x86
 
 

Bump
My System SpecsSystem Spec
01 Jan 2013   #3
UsernameIssues

W7 Pro SP1 64bit
 
 

I don't know of a way to do what you described from within Office; but you can do it with a scripting tool like AutoHotkey or AutoIt. If this is something that you want to use for months, then it might be worth learning how to script it; otherwise, checking/entering the info manually would be easier.
My System SpecsSystem Spec
.


01 Jan 2013   #4
Pedroc1999

Windows 7 Ultimate x86
 
 

Thank you. I think the problem is that part of teh page is flash and it complicates it. Im goi g to mark this as solved but if someone wants to gjve an answer please feel free to do so
My System SpecsSystem Spec
01 Jan 2013   #5
tom982

Microsoft Community Contributor Award Recipient

Windows 8.1 Pro x64
 
 

That's no easy task, I'm afraid. Learn to program, then use an HTML agility pack to retrieve the information you need from the website.

Well, that or just spend the 30 or so seconds to check a website each day. eBuyer is cheaper by the way:

Cheap Laptops, Computers and Cheap LCD TVs | Ebuyer.com

For my build, eBuyer was cheaper than Scan, OcUK, Amazon and eBay on every component except one - which they didn't stock. Delivery was free and I got everything two days after my order, then I had to wait a week for my RAM to come from Amazon.

Well, what do you know, it's even cheaper on Amazon:

Corsair CML8GX3M2A1600C9 LP Vengeance 8GB (2 x 4GB) 1600MHz CL9 DDR3 Memory Module Kit: Amazon.co.uk: Computers & Accessories

That's a rarity!

Tom
My System SpecsSystem Spec
01 Jan 2013   #6
Pedroc1999

Windows 7 Ultimate x86
 
 

Yes i know but for my current uild it was about 10 cheaper without posting but when teh time comes im going with ebuyer. I allready know batch and lua. Im workibg on auto
My System SpecsSystem Spec
Reply

 How To Retreive Data From A Website And Display In Table




Thread Tools





Similar help and support threads
Thread Forum
At times, IE stops and freezses till it gets data from the website
I am using IE 10 on my Windows 7 X64 machine. I have 16 GB ram and all the latest drivers installed including the latest Ethernet - network adapters. I spoke to my motherboard manufacture of Intel today and there are no settings in the Ethernet drivers to change of Intel 82579V Gigabit Network...
Browsers & Mail
Corrupted Partition Table on External USB Data Backup Drive
I have a Western Digital MyBook ES 500 GB external hard drive (USB and eSATA interfaces) for data backups formatted from a Windows XP PC that I now use with my laptop running Windows 7 64-bit Home Premium. Recently my son connected it to his Apple PC and tried to create a partition to back up his...
General Discussion
Where do I retreive a core dump and how do I analyze it?
My PC keeps crashing with the blue screen of death. The BSOD dumps my physical memory somewhere. I assume that's so we can figure out what went wrong. Where is the physical memory dump? How do I analyze it (or, more accurately, who can analyze it for me)? The (important part of the) BSOD's...
BSOD Help and Support
Trouble exporting data to excel from website via IE9
Hi all, I have Windows 7 Professional and am using IE9. There's a website we use at work that needs data exported to excel. It works on my co-workers older computer but not from mine. I've attached the screen shots. When I right click on the screen, it gives me an option to export to excel....
Browsers & Mail
Internet cannot display the website
Hi- This problem started about 2 months ago. My computer doesn't open https://anthem.com So far it's the only website that I can't open. I've noticed that if I use "https" it won't open, but if I use "http" it does. I tried opening it using safari on the same computer and I was able to...
Browsers & Mail
Retreive files from WET
I used Windows Easy Transfer to move my files to an internal hard drive before installing 7 professional. Now when I attempt to access those files in order to transfer some of them to 7, I get the message "WET could not open file". When asked where the files are the only options given are...
General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 21:32.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App