Search : in
By :

Import webpage data into Excel spreadsheet

Last answer on Oct 2, 2009 12:43:10 am BST Jeffrey, on Oct 22, 2008 3:09:18 pm BST 
 Report this message to moderators

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.

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « Import webpage data into Excel spreadsheet » in :
Inserting an animated gif in Excel ShowInserting an animated gif in Excel To insert an animated gif image in an Excel spreadsheet, you must insert the image into a control. To insert the control, go to the View menu/Toolbars/Control Toolbox Activate the first button Design...
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Import contacts from Excel to Outlook ShowImport contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
Download ABC Amber Excel Converter ShowDo you know that your Excel spreadsheet can be converted into any format? Only ABC Amber Excel Converter can gather these many conversions into a single application. ABC Amber Excel Converter is a program to convert your XLS files into several...
Download Excel Viewer Show
Download Exult XML Conversion Wizard Show
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Ask your question Reply

None, on Oct 29, 2008 8:58:20 pm GMT
  • +13

I'm looking for this too..let me know if you find it...i'll do the same

   
Reply to None

2

None, on Oct 29, 2008 9:06:20 pm GMT
  • +3

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

   
Reply to None

3

Jeffrey, on Nov 17, 2008 3:20:44 pm GMT
  • +2

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!

   
Reply to Jeffrey

4

vikram reddy, on Feb 6, 2009 7:24:26 am GMT
  • +5

Hi,
i want display my dataset in excel sheet using windows application in c#.

Thanks & Regards
VIKRAM REDDY GADDAm

   
Reply to vikram reddy

5

roheet143, on Apr 17, 2009 12:03:28 pm BST
  • +2

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

   
Reply to roheet143

6

Ringo, on Apr 18, 2009 4:46:55 am BST
  • +2

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

   
Reply to Ringo

7

soni, on Apr 20, 2009 11:20:11 am BST
  • +1

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 to soni

8

 Darkman, on Oct 2, 2009 12:43:10 am BST
  • +1

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 )

   
Reply to Darkman
Ask your question Reply
They need your help