How to read multiple worksheet from a single excel file

**r035198x** · Jun 10 '08, 10:12 AM

Since you've already exported all the sheets, couldn't you then just read that XML file using something like DOM?

**sejal17** · Jun 10 '08, 12:50 PM

Originally posted by r035198x

Since you've already exported all the sheets, couldn't you then just read that XML file using something like DOM?

thanks for your response..

here is my php file,by using it i m retrieving data of xml but only one worksheet.I want to retrieve all worksheets data.

[CODE=php] <?php

$data = array();
include 'classes/ez_sql.php';
function import($itemno, $logoid,$colori d,$styleid,$des criptorid,$logo name,$colorname ,$stylename,$de scriptorname,$i temname)
{
$q1="insert into temp(id,item_nu mber,logo_id,co lor_id,style_id ,descriptor_id, logo_name,color _name,style_nam e,descriptor_na me,item_name) values('','$ite mno','$logoid', '$colorid','$st yleid','$descri ptorid','$logon ame','$colornam e','$stylename' ,'$descriptorna me','$itemname' )";
mysql_query($q1 );
}
if ( $_FILES['file']['tmp_name'] )
{
$dom = DOMDocument::lo ad( $_FILES['file']['tmp_name'] );
$rows = $dom->getElementsByT agName( 'Row' );
$first_row = true;
$i = 0;
foreach ($rows as $row)
{
if ( !$first_row )
{
$itemno = "";$logoid = "";$colorid = "";$styleid = "";
$descriptorid = "";$logonam e = "";$colorna me = "";$stylena me = "";
$descriptorname = "";$itemnam e ="";

$index = 1;
$cells = $row->getElementsByT agName( 'Cell' );
foreach( $cells as $cell )
{
if ( $index == 1 )
{
$itemno = $cell->nodeValue;
}
if($itemno != '000000000000')
{
if( $index == 2 ){ $logoid = $cell->nodeValue; }
if($logoid != '000')
{
if( $index == 3 ){ $colorid = $cell->nodeValue; }
if($colorid != '000')
{
if( $index == 4 ){ $styleid = $cell->nodeValue; }
if($styleid != '000')
{
if( $index == 5 ){ $descriptorid = $cell->nodeValue; }
if( $index == 6 ){ $logoname = $cell->nodeValue; }
if( $index == 7 ){ $colorname = $cell->nodeValue; }
if( $index == 8 ){ $stylename = $cell->nodeValue; }
if( $index == 9 ){ $descriptorname = $cell->nodeValue; }
if( $index == 10 ){ $itemname = $cell->nodeValue; }
}
else
{ exit; }
}
else
{} //exit; }
}
else
{ }//exit; }
}
else
{ exit; }
$index += 1;
}

import($itemno, $logoid,$colori d,$styleid,$des criptorid,$logo name,$colorname ,$stylename,$de scriptorname,$i temname);
}$first_row = false;

}
}

?>[/CODE]
Please help me..

**Atli** · Jun 11 '08, 09:07 PM

I would recommend using the SimpleXML functions rather than DOM. So much simpler. (Check out the examples).

In your code, what is up with all the exit calls in you loop there?
Would it not be better to use the continue keyword?

Also, rather than having multiple if statements checking you index, and assign a value to a fixed variable based on that, consider using an array. Like:
[code=php]
$data = array();
$index = 0;
foreach($cells as $cell) {
$data[$index] = $cell->nodeValue;
++$index;
}
saveData($data[0], $data[1], $data[2], etc..);
[/code]

How to read multiple worksheet from a single excel file

How to read multiple worksheet from a single excel file

Comment

Comment

Comment