pls i would love someone with the know how to explain to me in detail (pls)how i cant extract data from a website into an excel worksheet in an easy way that works for most websites. i dont mind if we can commune via mail... thanks

Open up an excel sheet with Notepad++

What you see, is what you do

Now that a little unclear... you do understand the question right?

Chaflyje: Now that a little unclear... you do understand the question right?

Try the suggestion first nah...If you're an adept programmer, you'll get the gist immediately it opens.

Most file formats are text based with extensions

do you want to extract data from database to excel or what are the data/info you want to extract to excel.
send me email igtechnologyng@gmail.com

@spikes C, fanks man... the thing is am not yet an 'adept' programmer so how can you help me @ switchmax8 am sending you a mail right away thanks ... my email is abayomialake@gmail.com

Ok, am assuming you're storing a column by row text from a database table and you're using PHP
For example; Peoples profile with this schema:

first_name | last_name | email | gender | address

Now, your excel sheet is also supposed to have the same columns.

After getting your data from the database, you start.

//Notice the double colons used to wrap the space-separated words
//And the newline at the end. Remember it's like a variable, so treat it as such

$excel_data = '"First Name", "Last Name", "Email Address", Gender, Address' . "\r\n";

//Now we start iterating our database resultset

while($row = $result->fetch_assoc()){
    //If your results have spaces, pls remember to wrap them up in a double colon

    $excel_data .= "$row[first_name], $row[last_name], $row[email], $row[gender], $row[address]" . "\r\n";
}

Now, thats your excel sheet contained in the $excel_data variable. You can save it as a file with the .csv format or you can output it as a download immediately

Chaflyje: pls i would love someone with the know how to explain to me in detail (pls)how i cant extract data from a website into an excel worksheet in an easy way that works for most websites. i dont mind if we can commune via mail... thanks

Your looking for google docs and data extraction via xpath. I did some work on this some months ago. All these funny webmasters in nairaland - they should be called web-installers.....

You can look at the bio's i scraped from yahoo voices.... if your patient i can make a video outlining the basic steps.

^{go to https://docs.google.com/spreadsheet/ccc?key=0Aqry-cVAu0ShdFRnUHBHSXNXVWNiZ1pEV1dXT042T3c&usp=sharing}

By weekend !!

UncleJJ:

Your looking for google docs and data extraction via xpath. I did some work on this some months ago. All these funny webmasters in nairaland - they should be called web-installers.....

You can look at the bio's i scraped from yahoo voices.... if your patient i can make a video outlining the basic steps.


By weekend !!

really

Google docs
Web installers indeed

spikes C:
really

Google docs
Web installers indeed

Use the link, except you dont have a google account - which would make you weird !

I call them web-installers - cos they only know how to use fantastico to install sites online.

Hence the term - web-installers !

UncleJJ:

Use the link, except you dont have a google account - which would make you weird !

I call them web-installers - cos they only know how to use fantastico to install sites online.

Hence the term - web-installers !

You're trying too hard to make yourself seem intelligent. What has google docs got to do with creating excel sheets in an application.

And no, not having google account doesn't make people weird

spikes C:

You're trying too hard to make yourself seem intelligent. What has google docs got to do with creating excel sheets in an application.

And no, not having google account doesn't make people weird

Me... intelligent ha ha .... i repeated a whole class in UNI..... am not intelligent brov !

But, i can read english... and the OP never mentioned "application" he said and i qoute

Chaflyje: pls i would love someone with the know how to explain to me in detail (pls)how i cant extract data from a website into an excel worksheet in an easy way that works for most websites. i dont mind if we can commune via mail... thanks

I dont think he meant an application, but if he did. mybad !!!

And about the google account - where in 2013 not 1996 !

Definitely, i missed a part but it still doesn't relate to google docs.

He needs to tell us the website he wants to extract data from so we can tell him the best way to go about it. Meanwhile, the method to create an excel sheet has been finished.