+ Reply to Thread
Results 1 to 5 of 5

Getting data from non-table website

  1. #1
    Registered User
    Join Date
    12-19-2010
    Location
    Sepsiszentgyörgy, Romania
    MS-Off Ver
    Excel 2010
    Posts
    14

    Unhappy Getting data from non-table website

    I need a way, anything quicker or perhaps more comfortable, than entering the data in a spreadsheet one by one, for entering data from a website, but on the site it is not in a table. Can this be done? The site is a php site, and there is a consistency in the page titles (could recreate them with formulas). The data could be extracted from the source code that a browser sees (not the php, of course, as I don't have access to that), as it is always preceded by it's type, that being unique (Cost: 3000 for example). Is there any way of doing this?
    If it's not possible from the net, would it be possible from a saved version of the site (and if yes, how)?
    Yoy? ; )

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Getting data from non-table website

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!

  3. #3
    Registered User
    Join Date
    12-19-2010
    Location
    Sepsiszentgyörgy, Romania
    MS-Off Ver
    Excel 2010
    Posts
    14

    Cool Re: Getting data from non-table website

    I really don't see how attaching any kind of document would help in my case. I just need a method of importing data from the web. They're all numbers, always preceded by some kind of descriptor, something like 'ThisCost 3000' and 'ThatCost 4000' and of the like. In the website's code it would look like
    Please Login or Register  to view this content.
    I don't have any "real workbook", aside from a blank one, in which the data can go in any order. I can work with it if it's in Excel in any form, I just need it to get in Excel.
    Last edited by lordyoyo; 12-20-2010 at 09:05 AM. Reason: cleared up code

  4. #4
    Registered User
    Join Date
    12-19-2010
    Location
    Sepsiszentgyörgy, Romania
    MS-Off Ver
    Excel 2010
    Posts
    14

    Cool Re: Getting data from non-table website

    Bump for still waiting for some help.

  5. #5
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Getting data from non-table website

    Sorry, but I don't think there is enough information to answer your question. You need to be more specific. Maybe provide a suitable web site link to a sample page and then give an Excel file as an example of what you would like to see as the output.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1