The cleanest i would recomend is the excel converted to csv, albeit people can share their experience with just plain excel

an example in php would look like

<?

$file_handle = fopen("file.csv", "r");
$x=0;
$fieldsStr == "";
while (!feof($file_handle) ) {
       $x+=1;
       $line_of_text = fgetcsv($file_handle, 1024);
//no of columns
$sz = sizeof($line_of_text);
                //the line of text is an array getting the size gives you the size of the array thus the no of columns you are dealing with
// you can do the rest here
        }
       fclose($file_handle);
?>
       
that should sought you for csv,
for actual excel you should consider 
http://phpexcel.codeplex.com/


_______________________________________________________________
We must Keep on, 
   

 


On Thu, Jul 12, 2012 at 12:24 PM, <rickinyua@gmail.com> wrote:
@Joe The data
Sent from my BlackBerry®

-----Original Message-----
From: joe mwirigi <joemwirigi@gmail.com>
Sender: skunkworks-bounces@lists.my.co.ke
Date: Thu, 12 Jul 2012 12:14:29
To: Skunkworks Mailing List<skunkworks@lists.my.co.ke>
Reply-To: Skunkworks Mailing List <skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] php script for uploading an excel sheet to mysql db

_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke
_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
------------
List info, subscribe/unsubscribe
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------

Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke