How to read multiple worksheet from a single excel file

56 New Member

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:sche mas-microsoft-com:office:spre adsheet"
xmlns:o="urn:sc hemas-microsoft-com:office:offi ce"
xmlns:x="urn:sc hemas-microsoft-com:office:exce l"
xmlns:ss="urn:s chemas-microsoft-com:office:spre adsheet"
xmlns:html="htt p://www.w3.org/TR/REC-html40">
<DocumentProper ties xmlns="urn:sche mas-microsoft-com:office:offi ce">
<Author>The Fritz Family</Author>
<LastAuthor>com 6</LastAuthor>
<Created>2008-05-17T17:58:56Z</Created>
<LastSaved>20 08-06-10T06:16:20Z</LastSaved>
<Version>10.262 5</Version>
</DocumentPropert ies>
<OfficeDocument Settings xmlns="urn:sche mas-microsoft-com:office:offi ce">
<DownloadCompon ents/>
<LocationOfComp onents HRef="file:///\\comp4\Deval%2 0(F)\Office%20X P\"/>
</OfficeDocumentS ettings>
<ExcelWorkboo k xmlns="urn:sche mas-microsoft-com:office:exce l">
<WindowHeight>1 1640</WindowHeight>
<WindowWidth>15 480</WindowWidth>
<WindowTopX>120 </WindowTopX>
<WindowTopY>135 </WindowTopY>
<ActiveSheet> 2</ActiveSheet>
<ProtectStructu re>False</ProtectStructur e>
<ProtectWindows >False</ProtectWindows>
</ExcelWorkbook>
<Worksheet ss:Name="Master Import Sheet">
<Table ss:ExpandedColu mnCount="11" ss:ExpandedRowC ount="43" x:FullColumns=" 1"
x:FullRows="1" ss:DefaultColum nWidth="54" ss:DefaultRowHe ight="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.2 5"/>
<Column ss:StyleID="s80 " ss:AutoFitWidth ="0" ss:Width="153.7 5"/>
<Column ss:StyleID="s80 " ss:AutoFitWidth ="0" ss:Width="127.5 "/>
<Column ss:StyleID="s75 " ss:Width="384.7 5"/>
<Column ss:Width="71.25 "/>
<Row ss:Height="17.2 5" ss:StyleID="s62 ">
<Cell ss:StyleID="s76 "><Data ss:Type="String ">Item Number</Data><Comment
ss:Author="Matt hew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Fon t html:Face="Taho ma"
x:Family="Swiss " html:Size="8" html:Color="#00 0000">AUTOGENER ATED CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s82 "><Data ss:Type="String ">Logo ID</Data><Comment
ss:Author="Matt hew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Fon t html:Face="Taho ma"
x:Family="Swiss " html:Size="8" html:Color="#00 0000">INPUT CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s82 "><Data ss:Type="String ">Color Id</Data><Comment
ss:Author="Matt hew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Fon t html:Face="Taho ma"
x:Family="Swiss " html:Size="8" html:Color="#00 0000">INPUT CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s82 "><Data ss:Type="String ">Style/Unit Id</Data><Comment
ss:Author="Matt hew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Fon t html:Face="Taho ma"
x:Family="Swiss " html:Size="8" html:Color="#00 0000">INPUT CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s82 "><Data ss:Type="String ">Descripto r ID</Data><Comment
ss:Author="Matt hew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Fon t html:Face="Taho ma"
x:Family="Swiss " html:Size="8" html:Color="#00 0000">INPUT CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s77 "><Data ss:Type="String ">Design/Logo Name</Data><Comment
ss:Author="Matt hew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Fon t html:Face="Taho ma"
x:Family="Swiss " html:Size="8" html:Color="#00 0000">AUTOGENER ATED CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s77 "><Data ss:Type="String ">Color Name</Data><Comment
ss:Author="Matt hew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Fon t html:Face="Taho ma"
x:Family="Swiss " html:Size="8" html:Color="#00 0000">AUTOGENER ATED CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s77 "><Data ss:Type="String ">Style/Unit Name</Data><Comment
ss:Author="Matt hew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Fon t html:Face="Taho ma"
x:Family="Swiss " html:Size="8" html:Color="#00 0000">AUTOGENER ATED CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s77 "><Data ss:Type="String ">Descripto r Name</Data><Comment
ss:Author="Matt hew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Fon t html:Face="Taho ma"
x:Family="Swiss " html:Size="8" html:Color="#00 0000">AUTOGENER ATED CELL</Font></B></ss:Data></Comment></Cell>
<Cell ss:StyleID="s73 "><Data ss:Type="String ">Item Name</Data><Comment
ss:Author="Matt hew T. Fritz"><ss:Data
xmlns="http://www.w3.org/TR/REC-html40"><B><Fon t html:Face="Taho ma"
x:Family="Swiss " html:Size="8" html:Color="#00 0000">AUTOGENER ATED CELL</Font></B></ss:Data></Comment></Cell>
</Row>
<Row ss:Height="15.7 5">
<Cell ss:StyleID="s78 "
ss:Formula="=CO NCATENATE((TEXT (RC[1],"000&quot ;)),(TEXT(RC[2],"000&quot ;)),(TEXT(RC[3],"000&quot ;)),(TEXT(RC[4],"000&quot ;)))"><Data
ss:Type="String ">001002002 001</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="=VL OOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Dat a
ss:Type="String ">SW-Explorer</Data></Cell>
<Cell ss:Formula="=VL OOKUP(RC[-4],'Color (DEF)'!C[-6]:C[-5],2,FALSE)"><Dat a
ss:Type="String ">Carrot</Data></Cell>
<Cell ss:Formula="=VL OOKUP(RC[-4],'StyleUnit (GHI)'!C[-7]:C[-6],2,FALSE)"><Dat a
ss:Type="String ">Ladies Standard T-Shirt</Data></Cell>
<Cell ss:StyleID="s79 "
ss:Formula="=VL OOKUP(RC[-4],'Descriptor (JKL)'!C[-8]:C[-7],2,FALSE)"><Dat a
ss:Type="String ">Wholesale Youth XS</Data></Cell>
<Cell ss:StyleID="s74 "
ss:Formula="=CO NCATENATE(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="=CO NCATENATE((TEXT (RC[1],"000&quot ;)),(TEXT(RC[2],"000&quot ;)),(TEXT(RC[3],"000&quot ;)),(TEXT(RC[4],"000&quot ;)))"><Data
ss:Type="String ">004001003 001</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="=VL OOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Dat a
ss:Type="String ">SW-Animal</Data></Cell>
<Cell ss:Formula="=VL OOKUP(RC[-4],'Color (DEF)'!C[-6]:C[-5],2,FALSE)"><Dat a
ss:Type="String ">Khaki Green</Data></Cell>
<Cell ss:Formula="=VL OOKUP(RC[-4],'StyleUnit (GHI)'!C[-7]:C[-6],2,FALSE)"><Dat a
ss:Type="String ">Unisex Recycled T-Shirt</Data></Cell>
<Cell ss:StyleID="s79 "
ss:Formula="=VL OOKUP(RC[-4],'Descriptor (JKL)'!C[-8]:C[-7],2,FALSE)"><Dat a
ss:Type="String ">Wholesale Youth XS</Data></Cell>
<Cell ss:StyleID="s74 "
ss:Formula="=CO NCATENATE(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="=CO NCATENATE((TEXT (RC[1],"000&quot ;)),(TEXT(RC[2],"000&quot ;)),(TEXT(RC[3],"000&quot ;)),(TEXT(RC[4],"000&quot ;)))"><Data
ss:Type="String ">002004001 002</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="=VL OOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Dat a
ss:Type="String ">SW-Aid</Data></Cell>
<Cell ss:Formula="=VL OOKUP(RC[-4],'Color (DEF)'!C[-6]:C[-5],2,FALSE)"><Dat a
ss:Type="String ">Mocha</Data></Cell>
<Cell ss:Formula="=VL OOKUP(RC[-4],'StyleUnit (GHI)'!C[-7]:C[-6],2,FALSE)"><Dat a
ss:Type="String ">Unisex Standard T-Shirt</Data></Cell>
<Cell ss:StyleID="s79 "
ss:Formula="=VL OOKUP(RC[-4],'Descriptor (JKL)'!C[-8]:C[-7],2,FALSE)"><Dat a
ss:Type="String ">Wholesale Youth S</Data></Cell>
<Cell ss:StyleID="s74 "
ss:Formula="=CO NCATENATE(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>
<WorksheetOptio ns xmlns="urn:sche mas-microsoft-com:office:exce l">
<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>
<ValidPrinterIn fo/>
<HorizontalReso lution>-3</HorizontalResol ution>
<VerticalResolu tion>-3</VerticalResolut ion>
</Print>
<Zoom>85</Zoom>
<Panes>
<Pane>
<Number>3</Number>
<RangeSelection >C1</RangeSelection>
</Pane>
</Panes>
<ProtectObjects >False</ProtectObjects>
<ProtectScenari os>False</ProtectScenario s>
</WorksheetOption s>
</Worksheet>
<Worksheet ss:Name="Design Logo (ABC)">
<Table ss:ExpandedColu mnCount="2" ss:ExpandedRowC ount="61" x:FullColumns=" 1"
x:FullRows="1" ss:DefaultColum nWidth="54" ss:DefaultRowHe ight="14.25">
<Column ss:StyleID="s93 " ss:Width="98.25 "/>
<Column ss:StyleID="s70 " ss:Width="122.2 5"/>
<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>
<WorksheetOptio ns xmlns="urn:sche mas-microsoft-com:office:exce l">
<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>
<ProtectScenari os>False</ProtectScenario s>
</WorksheetOption s>
</Worksheet>
<Worksheet ss:Name="Color (DEF)">
<Table ss:ExpandedColu mnCount="2" ss:ExpandedRowC ount="61" x:FullColumns=" 1"
x:FullRows="1" ss:DefaultColum nWidth="54" ss:DefaultRowHe ight="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>
<WorksheetOptio ns xmlns="urn:sche mas-microsoft-com:office:exce l">
<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>
<ProtectScenari os>False</ProtectScenario s>
</WorksheetOption s>
</Worksheet>
<Worksheet ss:Name="StyleU nit (GHI)">
<Table ss:ExpandedColu mnCount="2" ss:ExpandedRowC ount="27" x:FullColumns=" 1"
x:FullRows="1" ss:DefaultColum nWidth="54" ss:DefaultRowHe ight="14.25">
<Column ss:StyleID="s90 " ss:Width="79.5"/>
<Column ss:StyleID="s68 " ss:Width="154.5 "/>
<Row ss:Height="15.7 5" 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>
<WorksheetOptio ns xmlns="urn:sche mas-microsoft-com:office:exce l">
<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>
<ValidPrinterIn fo/>
<HorizontalReso lution>600</HorizontalResol ution>
<VerticalResolu tion>600</VerticalResolut ion>
</Print>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>7</ActiveRow>
</Pane>
</Panes>
<ProtectObjects >False</ProtectObjects>
<ProtectScenari os>False</ProtectScenario s>
</WorksheetOption s>
</Worksheet>
<Worksheet ss:Name="Descri ptor (JKL)">
<Table ss:ExpandedColu mnCount="2" ss:ExpandedRowC ount="102" x:FullColumns=" 1"
x:FullRows="1" ss:DefaultColum nWidth="54" ss:DefaultRowHe ight="14.25">
<Column ss:StyleID="s90 " ss:Width="87.75 "/>
<Column ss:StyleID="s68 " ss:Width="154.5 "/>
<Row ss:Height="15.7 5">
<Cell ss:StyleID="s88 "><Data ss:Type="String ">Descripto r 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>
<WorksheetOptio ns xmlns="urn:sche mas-microsoft-com:office:exce l">
<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>
<ProtectScenari os>False</ProtectScenario s>
</WorksheetOption s>
</Worksheet>
</Workbook>

How to read this multiple worksheets?
Help me pls.
Thanks

Jun 10 '08 #1

Subscribe Reply

6235

r035198x

13,262

MVP

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

New Member

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

Recognized Expert Expert

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

Similar topics

2526

How do I read an excel file to display the worksheet on the web.

by: sarunnio | last post by:

How do I read an excel file to display the worksheet on the web. Can I make use of some excel automation to programmatically manipulate the excel file via the web browser. Thanks in advance. What I 'd like to do is to create a link like shown below. -Link1

C# / C Sharp

4685

Read XML based file that is recognized by Excel

by: Peter | last post by:

I am having a problem reading an Excel file that is XML based. The directory I am reading contains Excel files that can be of two types. Either generic Microsoft based or XML based. I am reading the Microsoft based files with an OleDbDataAdapter. Then filling the contents of the first worksheet into a dataset. However when I try to add the...

C# / C Sharp

4618

best way to read specific record from Excel file in C#

by: Esmail Bonakarian | last post by:

Greetings all, What is the best way to access specific records in an Excel file? I have an Excel file, I want to randomly and repeatedly (maybe around up to 50 times) draw some rows of data from this Excel file and store them in a struct/class for further processing. (mostly just display the info in graphical format) This is not some...

C# / C Sharp

8701

code to export to multiple Excel worksheets within single workbook

by: paul.chae | last post by:

I have a table in Access with about 3000 records. There are ~60 unique values in the ID field for the 3000 records. What I would like to do is automatically generate multiple Excel worksheets within a single workbook with these records. I would end up with around 500 worksheets, 1 for each unique ID value. I was thinking this could be...

Microsoft Access / VBA

3643

Excel Interops - Want multiple datasources on one chart

by: c0dergirl | last post by:

This c# program allows you to select multiple items from a listbox. For each selected item, a worksheet is created in the workbook with some information. Right now I create a chart that plots some information from one of the sheets. What I want to do is have a line on the graph for every sheet. I assume I use multiple datasources to do this,...

C# / C Sharp

9767

Access Tables to Excel Worksheet Export

by: smaczylo | last post by:

Hello, I've recently been asked to work with Microsoft Access, and while I feel quite comfortable with Excel, I'm at a complete loss with databases. If someone could help me with this issue I'm having I'd be most appreciative. The database is already constructed, I'm just wanting to export the data to an excel file. In short, I'm hoping...

Microsoft Access / VBA

12799

Read Excel Data Using ASP.net 2.0 C#

by: ntuyen01 | last post by:

Hi All, I try to read the data from the excel, but I ran into this problem I have two excel files. file one.xls data inside like this: 1234 1234 1234 1234 abc-123 abc-123

C# / C Sharp

1418

To read an excel file with Excel Class in vb.net

by: nudrat | last post by:

I have added a reference Microsoft Excel 5.0 Object Library in my project. the code is as follows: Dim myExcel As Excel.Application ' Interface to Excel Dim myWorkBookCollection As Excel.Workbooks ' Workbook-collection Dim myWorkBook As Excel.Workbook ' Single Workbook (spreadsheet-collection) Dim myWorkSheet As Excel.Worksheet '...

.NET Framework

5383

how to read multiple worksheet from an excel file using php

by: sejal17 | last post by:

XML

7839

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

8338

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7959

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

8216

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

5710

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

3837

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

2345

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1449

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1180

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General