By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,011 Members | 2,967 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,011 IT Pros & Developers. It's quick & easy.

How to read multiple worksheet from a single excel file

P: 56
hello
Can any one tell me how to read multiple worksheets from a single excel file.I have stored that excel in xml file.so i want to read that xml that has multiple worksheet.And i want to store that multiple worksheet data in different table.How can i do it.Below is my xml file.


<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Author>The Fritz Family</Author>
<LastAuthor>com6</LastAuthor>
<Created>2008-05-17T17:58:56Z</Created>
<LastSaved>2008-06-10T06:16:20Z</LastSaved>
<Version>10.2625</Version>
</DocumentProperties>
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
<DownloadComponents/>
<LocationOfComponents HRef="file:///\\comp4\Deval%20(F)\Office%20XP\"/>
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>11640</WindowHeight>
<WindowWidth>15480</WindowWidth>
<WindowTopX>120</WindowTopX>
<WindowTopY>135</WindowTopY>
<ActiveSheet>2</ActiveSheet>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Worksheet ss:Name="Master Import Sheet">
<Table ss:ExpandedColumnCount="11" ss:ExpandedRowCount="43" x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="15">
<Column ss:StyleID="s81" ss:AutoFitWidth="0" ss:Width="90.75"/>
<Column ss:StyleID="s84" ss:Width="49.5"/>
<Column ss:StyleID="s84" ss:Width="51.75"/>
<Column ss:StyleID="s84" ss:AutoFitWidth="0" ss:Width="81.75"/>
<Column ss:StyleID="s84" ss:Width="83.25"/>
<Column ss:StyleID="s80" ss:AutoFitWidth="0" ss:Width="108"/>
<Column ss:StyleID="s80" ss:AutoFitWidth="0" ss:Width="107.25"/>
<Column ss:StyleID="s80" ss:AutoFitWidth="0" ss:Width="153.75"/>
<Column ss:StyleID="s80" ss:AutoFitWidth="0" ss:Width="127.5"/>
<Column ss:StyleID="s75" ss:Width="384.75"/>
<Column ss:Width="71.25"/>
<Row ss:Height="17.25" ss:StyleID="s62">
<Cell ss:StyleID="s76"><Data ss:Type="String">Item Number</Data><Comment
ss:Author="Matthew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma"
x:Family="Swiss" html:Size="8" html:Color="#000000">AUTOGENERATED CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s82"><Data ss:Type="String">Logo ID</Data><Comment
ss:Author="Matthew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma"
x:Family="Swiss" html:Size="8" html:Color="#000000">INPUT CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s82"><Data ss:Type="String">Color Id</Data><Comment
ss:Author="Matthew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma"
x:Family="Swiss" html:Size="8" html:Color="#000000">INPUT CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s82"><Data ss:Type="String">Style/Unit Id</Data><Comment
ss:Author="Matthew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma"
x:Family="Swiss" html:Size="8" html:Color="#000000">INPUT CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s82"><Data ss:Type="String">Descriptor ID</Data><Comment
ss:Author="Matthew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma"
x:Family="Swiss" html:Size="8" html:Color="#000000">INPUT CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s77"><Data ss:Type="String">Design/Logo Name</Data><Comment
ss:Author="Matthew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma"
x:Family="Swiss" html:Size="8" html:Color="#000000">AUTOGENERATED CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s77"><Data ss:Type="String">Color Name</Data><Comment
ss:Author="Matthew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma"
x:Family="Swiss" html:Size="8" html:Color="#000000">AUTOGENERATED CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s77"><Data ss:Type="String">Style/Unit Name</Data><Comment
ss:Author="Matthew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma"
x:Family="Swiss" html:Size="8" html:Color="#000000">AUTOGENERATED CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s77"><Data ss:Type="String">Descriptor Name</Data><Comment
ss:Author="Matthew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma"
x:Family="Swiss" html:Size="8" html:Color="#000000">AUTOGENERATED CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s73"><Data ss:Type="String">Item Name</Data><Comment
ss:Author="Matthew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Font html:Face="Tahoma"
x:Family="Swiss" html:Size="8" html:Color="#000000">AUTOGENERATED CELL</Font></B></ss:Data></Comment></Cell>
</Row>
<Row ss:Height="15.75">
<Cell ss:StyleID="s78"
ss:Formula="=CONCATENATE((TEXT(RC[1],&quot;000&quot;)),(TEXT(RC[2],&quot;000&quot;)),(TEXT(RC[3],&quot;000&quot;)),(TEXT(RC[4],&quot;000&quot;)))"><Data
ss:Type="String">001002002001</Data></Cell>
<Cell ss:StyleID="s85"><Data ss:Type="String">001</Data></Cell>
<Cell ss:StyleID="s85"><Data ss:Type="String">002</Data></Cell>
<Cell ss:StyleID="s85"><Data ss:Type="String">002</Data></Cell>
<Cell ss:StyleID="s85"><Data ss:Type="String">001</Data></Cell>
<Cell ss:StyleID="s79"
ss:Formula="=VLOOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Data
ss:Type="String">SW-Explorer</Data></Cell>
<Cell ss:Formula="=VLOOKUP(RC[-4],'Color (DEF)'!C[-6]:C[-5],2,FALSE)"><Data
ss:Type="String">Carrot</Data></Cell>
<Cell ss:Formula="=VLOOKUP(RC[-4],'StyleUnit (GHI)'!C[-7]:C[-6],2,FALSE)"><Data
ss:Type="String">Ladies Standard T-Shirt</Data></Cell>
<Cell ss:StyleID="s79"
ss:Formula="=VLOOKUP(RC[-4],'Descriptor (JKL)'!C[-8]:C[-7],2,FALSE)"><Data
ss:Type="String">Wholesale Youth XS</Data></Cell>
<Cell ss:StyleID="s74"
ss:Formula="=CONCATENATE(RC[-1],&quot; &quot;,RC[-2],&quot; &quot;,RC[-3],&quot; &quot;,RC[-4])"><Data
ss:Type="String">Wholesale Youth XS Ladies Standard T-Shirt Carrot SW-Explorer</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s78"
ss:Formula="=CONCATENATE((TEXT(RC[1],&quot;000&quot;)),(TEXT(RC[2],&quot;000&quot;)),(TEXT(RC[3],&quot;000&quot;)),(TEXT(RC[4],&quot;000&quot;)))"><Data
ss:Type="String">004001003001</Data></Cell>
<Cell ss:StyleID="s85"><Data ss:Type="String">004</Data></Cell>
<Cell ss:StyleID="s85"><Data ss:Type="String">001</Data></Cell>
<Cell ss:StyleID="s85"><Data ss:Type="String">003</Data></Cell>
<Cell ss:StyleID="s85"><Data ss:Type="String">001</Data></Cell>
<Cell ss:StyleID="s79"
ss:Formula="=VLOOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Data
ss:Type="String">SW-Animal</Data></Cell>
<Cell ss:Formula="=VLOOKUP(RC[-4],'Color (DEF)'!C[-6]:C[-5],2,FALSE)"><Data
ss:Type="String">Khaki Green</Data></Cell>
<Cell ss:Formula="=VLOOKUP(RC[-4],'StyleUnit (GHI)'!C[-7]:C[-6],2,FALSE)"><Data
ss:Type="String">Unisex Recycled T-Shirt</Data></Cell>
<Cell ss:StyleID="s79"
ss:Formula="=VLOOKUP(RC[-4],'Descriptor (JKL)'!C[-8]:C[-7],2,FALSE)"><Data
ss:Type="String">Wholesale Youth XS</Data></Cell>
<Cell ss:StyleID="s74"
ss:Formula="=CONCATENATE(RC[-1],&quot; &quot;,RC[-2],&quot; &quot;,RC[-3],&quot; &quot;,RC[-4])"><Data
ss:Type="String">Wholesale Youth XS Unisex Recycled T-Shirt Khaki Green SW-Animal</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s78"
ss:Formula="=CONCATENATE((TEXT(RC[1],&quot;000&quot;)),(TEXT(RC[2],&quot;000&quot;)),(TEXT(RC[3],&quot;000&quot;)),(TEXT(RC[4],&quot;000&quot;)))"><Data
ss:Type="String">002004001002</Data></Cell>
<Cell ss:StyleID="s85"><Data ss:Type="String">002</Data></Cell>
<Cell ss:StyleID="s85"><Data ss:Type="String">004</Data></Cell>
<Cell ss:StyleID="s85"><Data ss:Type="String">001</Data></Cell>
<Cell ss:StyleID="s85"><Data ss:Type="String">002</Data></Cell>
<Cell ss:StyleID="s79"
ss:Formula="=VLOOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Data
ss:Type="String">SW-Aid</Data></Cell>
<Cell ss:Formula="=VLOOKUP(RC[-4],'Color (DEF)'!C[-6]:C[-5],2,FALSE)"><Data
ss:Type="String">Mocha</Data></Cell>
<Cell ss:Formula="=VLOOKUP(RC[-4],'StyleUnit (GHI)'!C[-7]:C[-6],2,FALSE)"><Data
ss:Type="String">Unisex Standard T-Shirt</Data></Cell>
<Cell ss:StyleID="s79"
ss:Formula="=VLOOKUP(RC[-4],'Descriptor (JKL)'!C[-8]:C[-7],2,FALSE)"><Data
ss:Type="String">Wholesale Youth S</Data></Cell>
<Cell ss:StyleID="s74"
ss:Formula="=CONCATENATE(RC[-1],&quot; &quot;,RC[-2],&quot; &quot;,RC[-3],&quot; &quot;,RC[-4])"><Data
ss:Type="String">Wholesale Youth S Unisex Standard T-Shirt Mocha SW-Aid</Data></Cell>
</Row>

</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.3"/>
<Footer x:Margin="0.3"/>
<PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
</PageSetup>
<Print>
<ValidPrinterInfo/>
<HorizontalResolution>-3</HorizontalResolution>
<VerticalResolution>-3</VerticalResolution>
</Print>
<Zoom>85</Zoom>
<Panes>
<Pane>
<Number>3</Number>
<RangeSelection>C1</RangeSelection>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="DesignLogo (ABC)">
<Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="61" x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25">
<Column ss:StyleID="s93" ss:Width="98.25"/>
<Column ss:StyleID="s70" ss:Width="122.25"/>
<Row ss:Height="15" ss:StyleID="s72">
<Cell ss:StyleID="s92"><Data ss:Type="String">Design/Logo ID</Data></Cell>
<Cell ss:StyleID="s71"><Data ss:Type="String">Design/Logo Name</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s86"><Data ss:Type="String">000</Data></Cell>
<Cell ss:StyleID="s69"><Data ss:Type="String">Test Logo</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s86"><Data ss:Type="String">001</Data></Cell>
<Cell ss:StyleID="s69"><Data ss:Type="String">SW-Explorer</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s86"><Data ss:Type="String">002</Data></Cell>
<Cell ss:StyleID="s69"><Data ss:Type="String">SW-Aid</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s86"><Data ss:Type="String">003</Data></Cell>
<Cell ss:StyleID="s69"><Data ss:Type="String">SW-Service</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s86"><Data ss:Type="String">004</Data></Cell>
<Cell ss:StyleID="s69"><Data ss:Type="String">SW-Animal</Data></Cell>
</Row>

</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.3"/>
<Footer x:Margin="0.3"/>
<PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
</PageSetup>
<Panes>
<Pane>
<Number>3</Number>
<RangeSelection>C1</RangeSelection>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Color (DEF)">
<Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="61" x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25">
<Column ss:StyleID="s93"/>
<Column ss:StyleID="s70" ss:Width="80.25"/>
<Row ss:Height="15" ss:StyleID="s72">
<Cell ss:StyleID="s92"><Data ss:Type="String">Color ID</Data></Cell>
<Cell ss:StyleID="s71"><Data ss:Type="String">Color Name</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s86"><Data ss:Type="String">000</Data></Cell>
<Cell ss:StyleID="s69"><Data ss:Type="String">Custom Choice</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s86"><Data ss:Type="String">001</Data></Cell>
<Cell ss:StyleID="s69"><Data ss:Type="String">Khaki Green</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s86"><Data ss:Type="String">002</Data></Cell>
<Cell ss:StyleID="s69"><Data ss:Type="String">Carrot</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s86"><Data ss:Type="String">003</Data></Cell>
<Cell ss:StyleID="s69"><Data ss:Type="String">Chrome</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s86"><Data ss:Type="String">004</Data></Cell>
<Cell ss:StyleID="s69"><Data ss:Type="String">Mocha</Data></Cell>
</Row>

</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.3"/>
<Footer x:Margin="0.3"/>
<PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
</PageSetup>
<Selected/>
<Panes>
<Pane>
<Number>3</Number>
<ActiveCol>1</ActiveCol>
<RangeSelection>C2</RangeSelection>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="StyleUnit (GHI)">
<Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="27" x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25">
<Column ss:StyleID="s90" ss:Width="79.5"/>
<Column ss:StyleID="s68" ss:Width="154.5"/>
<Row ss:Height="15.75" ss:StyleID="s65">
<Cell ss:StyleID="s88"><Data ss:Type="String">Style/Unit ID</Data></Cell>
<Cell ss:StyleID="s64"><Data ss:Type="String">Style/Unit Name</Data></Cell>
</Row>
<Row ss:StyleID="s63">
<Cell ss:StyleID="s87"><Data ss:Type="String">000</Data></Cell>
<Cell ss:StyleID="s66"><Data ss:Type="String">Test Style</Data></Cell>
</Row>
<Row ss:StyleID="s63">
<Cell ss:StyleID="s87"><Data ss:Type="String">001</Data></Cell>
<Cell ss:StyleID="s66"><Data ss:Type="String">Unisex Standard T-Shirt</Data></Cell>
</Row>
<Row ss:StyleID="s63">
<Cell ss:StyleID="s87"><Data ss:Type="String">002</Data></Cell>
<Cell ss:StyleID="s66"><Data ss:Type="String">Ladies Standard T-Shirt</Data></Cell>
</Row>
<Row ss:StyleID="s63">
<Cell ss:StyleID="s87"><Data ss:Type="String">003</Data></Cell>
<Cell ss:StyleID="s66"><Data ss:Type="String">Unisex Recycled T-Shirt</Data></Cell>
</Row>

</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.3"/>
<Footer x:Margin="0.3"/>
<PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
</PageSetup>
<Print>
<ValidPrinterInfo/>
<HorizontalResolution>600</HorizontalResolution>
<VerticalResolution>600</VerticalResolution>
</Print>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>7</ActiveRow>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Descriptor (JKL)">
<Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="102" x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="14.25">
<Column ss:StyleID="s90" ss:Width="87.75"/>
<Column ss:StyleID="s68" ss:Width="154.5"/>
<Row ss:Height="15.75">
<Cell ss:StyleID="s88"><Data ss:Type="String">Descriptor ID</Data></Cell>
<Cell ss:StyleID="s64"><Data ss:Type="String">Style/Unit Name</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s87"><Data ss:Type="String">000</Data></Cell>
<Cell ss:StyleID="s66"/>
</Row>
<Row>
<Cell ss:StyleID="s87"><Data ss:Type="String">001</Data></Cell>
<Cell ss:StyleID="s66"><Data ss:Type="String">Wholesale Youth XS</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s87"><Data ss:Type="String">002</Data></Cell>
<Cell ss:StyleID="s66"><Data ss:Type="String">Wholesale Youth S</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s87"><Data ss:Type="String">003</Data></Cell>
<Cell ss:StyleID="s66"><Data ss:Type="String">Wholesale Youth M</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s87"><Data ss:Type="String">004</Data></Cell>
<Cell ss:StyleID="s66"><Data ss:Type="String">Wholesale Youth L</Data></Cell>
</Row>

</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.3"/>
<Footer x:Margin="0.3"/>
<PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
</PageSetup>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>7</ActiveRow>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>

How to read this multiple worksheets?
Help me pls.
Thanks
Jun 10 '08 #1
Share this Question
Share on Google+
3 Replies


10K+
P: 13,264
Since you've already exported all the sheets, couldn't you then just read that XML file using something like DOM?
Jun 10 '08 #2

P: 56
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.

Expand|Select|Wrap|Line Numbers
  1.  <?php
  2.  
  3.   $data = array();
  4.   include 'classes/ez_sql.php';
  5.   function import($itemno,$logoid,$colorid,$styleid,$descriptorid,$logoname,$colorname,$stylename,$descriptorname,$itemname)
  6.   {
  7.        $q1="insert into         temp(id,item_number,logo_id,color_id,style_id,descriptor_id,logo_name,color_name,style_name,descriptor_name,item_name) values('','$itemno','$logoid','$colorid','$styleid','$descriptorid','$logoname','$colorname','$stylename','$descriptorname','$itemname')";
  8.       mysql_query($q1);
  9.   } 
  10.   if ( $_FILES['file']['tmp_name'] )
  11.   {
  12.   $dom = DOMDocument::load( $_FILES['file']['tmp_name'] );
  13.   $rows = $dom->getElementsByTagName( 'Row' );
  14.   $first_row = true;
  15.   $i = 0;
  16.   foreach ($rows as $row)
  17.   {
  18.       if ( !$first_row )
  19.       {
  20.           $itemno = "";$logoid = "";$colorid = "";$styleid = "";
  21.         $descriptorid = "";$logoname = "";$colorname = "";$stylename = "";
  22.         $descriptorname = "";$itemname ="";
  23.  
  24.           $index = 1;
  25.          $cells = $row->getElementsByTagName( 'Cell' );
  26.           foreach( $cells as $cell )
  27.           {
  28.                   if ( $index == 1 )
  29.                 {    
  30.                     $itemno = $cell->nodeValue;
  31.                 }
  32.                 if($itemno != '000000000000')        
  33.                 {    
  34.                     if( $index == 2 ){  $logoid = $cell->nodeValue; }
  35.                     if($logoid != '000')
  36.                     {
  37.                         if( $index == 3 ){ $colorid = $cell->nodeValue; }    
  38.                         if($colorid != '000')
  39.                         {
  40.                             if( $index == 4 ){ $styleid = $cell->nodeValue; }    
  41.                             if($styleid != '000')
  42.                             {
  43.                                 if( $index == 5 ){ $descriptorid = $cell->nodeValue; }    
  44.                                 if( $index == 6 ){ $logoname = $cell->nodeValue; }    
  45.                                 if( $index == 7 ){ $colorname = $cell->nodeValue; }
  46.                                 if( $index == 8 ){ $stylename = $cell->nodeValue; }    
  47.                                 if( $index == 9 ){ $descriptorname = $cell->nodeValue; }
  48.                                 if( $index == 10 ){ $itemname = $cell->nodeValue; }    
  49.                             }
  50.                             else
  51.                             { exit; }    
  52.                         }
  53.                         else
  54.                         {} //exit; }
  55.                     }
  56.                     else
  57.                     { }//exit; }
  58.                 }    
  59.                 else
  60.                 { exit; }                
  61.             $index += 1;    
  62.         }              
  63.  
  64.           import($itemno,$logoid,$colorid,$styleid,$descriptorid,$logoname,$colorname,$stylename,$descriptorname,$itemname);    
  65.   }$first_row = false;
  66.  
  67.   }
  68.   }
  69.  
  70.   ?>
Please help me..
Jun 10 '08 #3

Atli
Expert 5K+
P: 5,058
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:
Expand|Select|Wrap|Line Numbers
  1. $data = array();
  2. $index = 0;
  3. foreach($cells as $cell) {
  4.   $data[$index] = $cell->nodeValue;
  5.   ++$index;
  6. }
  7. saveData($data[0], $data[1], $data[2], etc..);
  8.  
Jun 11 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.