How to read multiple worksheet from a single excel file

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],"000")),(TEXT(RC[2],"000")),(TEXT(RC[3],"000")),(TEXT(RC[4],"000")))"><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]," ",RC[-2]," ",RC[-3]," ",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],"000")),(TEXT(RC[2],"000")),(TEXT(RC[3],"000")),(TEXT(RC[4],"000")))"><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]," ",RC[-2]," ",RC[-3]," ",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],"000")),(TEXT(RC[2],"000")),(TEXT(RC[3],"000")),(TEXT(RC[4],"000")))"><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]," ",RC[-2]," ",RC[-3]," ",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

Subscribe Post Reply

6167

r035198x

13,262

8TB

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

sejal17

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

  <?php
 
  $data = array();

  include 'classes/ez_sql.php';

  function import($itemno,$logoid,$colorid,$styleid,$descriptorid,$logoname,$colorname,$stylename,$descriptorname,$itemname)

  {

       $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')";

      mysql_query($q1);

  } 

  if ( $_FILES['file']['tmp_name'] )

  {

  $dom = DOMDocument::load( $_FILES['file']['tmp_name'] );

  $rows = $dom->getElementsByTagName( 'Row' );

  $first_row = true;

  $i = 0;

  foreach ($rows as $row)

  {

      if ( !$first_row )

      {

          $itemno = "";$logoid = "";$colorid = "";$styleid = "";

        $descriptorid = "";$logoname = "";$colorname = "";$stylename = "";

        $descriptorname = "";$itemname ="";
 
          $index = 1;

         $cells = $row->getElementsByTagName( '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,$colorid,$styleid,$descriptorid,$logoname,$colorname,$stylename,$descriptorname,$itemname);    

  }$first_row = false;
 
  }

  }
 
  ?>

Please help me..

Jun 10 '08 #3

Atli

5,058

Expert 4TB

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

 
$data = array();

$index = 0;

foreach($cells as $cell) {

  $data[$index] = $cell->nodeValue;

  ++$index;

}

saveData($data[0], $data[1], $data[2], etc..);

Jun 11 '08 #4

How to read multiple worksheet from a single excel file

Similar topics