×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Getting Data from Web into Excel

Getting Data from Web into Excel

Getting Data from Web into Excel

(OP)
Was wondering what might be the problem.
I am trying to get external data from the web but it only returns 50 records.
There are more records if i clicked on the arrow to Display More on the web page.
Is there a way to extract full record on the excel worksheet?

Thanks,
Arv.

RE: Getting Data from Web into Excel

We probably need more info

Can you provide t3he site details?
How are you retrieving the data (there are various ways, and without knowing which one you are trying to use, we cannot really advise ...)?

RE: Getting Data from Web into Excel

(OP)
It is the internal company site.
Looks like its oracle analytics.
Retrieving from excel > get data > web

RE: Getting Data from Web into Excel

And you are quite sure that Oracale Analytics is generating the whole page of data, rather than simply generating visible records?

RE: Getting Data from Web into Excel

(OP)
Correct. Whole page data is generated once I click display max records.

RE: Getting Data from Web into Excel

Quote (arvarr)

There are more records if i clicked on the arrow to Display More on the web page.
Before clicking the arrow, is the number of displayed records the same as in excel? You just scroll the data in the web page or the you have to click to display the full set (as in stromgm's question)?

combo

RE: Getting Data from Web into Excel

(OP)
Nope, before clicking on the arrow, it only has 50 records.

Have to click to show full details.

RE: Getting Data from Web into Excel

Any changes in address in case of full data? If so, you can try to point full dataset.

combo

RE: Getting Data from Web into Excel

(OP)
No changes to address with full data

RE: Getting Data from Web into Excel

Quote (arvarr)

It is the internal company site.
Looks like its oracle analytics.

Can’t you just ask your IT to have the access to this information straight? By-passing the web site?


---- Andy

There is a great need for a sarcasm font.

RE: Getting Data from Web into Excel

(OP)
I can run the report from the website. Then, export to csv file.
The intent is to find if there is an easier way to directly refresh from excel.

RE: Getting Data from Web into Excel

Basically, Excel screenscrapes. And it sounds like, until you press that button, you do not have all the data available to be scraped.

RE: Getting Data from Web into Excel

(OP)
After i press the button to expand the data, I tries refreshing again from excel but it still only pulls through 50 records and not the full set of data.

RE: Getting Data from Web into Excel

Excel uses the website address to pick the data, not your browser.

combo

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close