import excel file into database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sejal17
    New Member
    • Dec 2007
    • 56

    #1

    import excel file into database

    hello everyone,

    I want to import only 3 field of the excel file into database.how can i do it?
    Also i don't want to insert the duplicate value of that field.Please reply me as soon as possible.




    thanks in advance......
  • Atli
    Recognized Expert Expert
    • Nov 2006
    • 5062

    #2
    Hi.

    Working with Excel documents is very annoying. It being a proprietary format from Microsoft, it doesn't really fit into the whole open-source thing PHP is built on.

    I have come across a class that allows you to interact with the Excel (.xsl) format, although I don't know if it will even work anymore. Looks like it hasn't been updated for almost a year.
    Check out this thread for more on that.

    If you can have Excel save the file as XML, things will become much easier.

    Comment

    • sejal17
      New Member
      • Dec 2007
      • 56

      #3
      Originally posted by Atli
      Hi.

      Working with Excel documents is very annoying. It being a proprietary format from Microsoft, it doesn't really fit into the whole open-source thing PHP is built on.

      I have come across a class that allows you to interact with the Excel (.xsl) format, although I don't know if it will even work anymore. Looks like it hasn't been updated for almost a year.
      Check out this thread for more on that.

      If you can have Excel save the file as XML, things will become much easier.

      Thanks for your reply...

      I have try one code in which i save as the excel file in xml.The data is inserted in database.But problem is that that if the first field is empty in excel then the second field data is inserted in database's first field.so how can i do it.here is my code:
      [code=php]
      <?php

      $data = array();
      include 'ez_sql.php';
      function add_person( $username, $password)
      {
      global $data;

      $data []= array(
      'username' => $username,
      'password' => $password,

      );
      }
      if ( $_FILES['file']['tmp_name'] )
      {
      $dom = DOMDocument::lo ad( $_FILES['file']['tmp_name'] );
      $rows = $dom->getElementsByT agName( 'Row' );
      $first_row = true;
      foreach ($rows as $row)
      {
      if ( !$first_row )
      {
      $username = "";
      $password = "";

      $index = 1;
      $cells = $row->getElementsByT agName( 'Cell' );
      foreach( $cells as $cell )
      {
      $ind = $cell->getAttribute ( 'Index' );
      if ( $ind != null ) $index = $ind;

      if ( $index == 1 ) $username = $cell->nodeValue;
      if ( $index == 2 ) $password = $cell->nodeValue;

      $index += 1;
      }

      add_person( $username, $password);
      }
      $first_row = false;
      }
      }

      foreach( $data as $row ) {
      $user=$row['username'];
      $pwd=$row['password'];


      $q2="select name from usertable where name='$user'";
      $name=$db->get_var($q2) ;
      if(!$name)
      {
      $q1="insert into usertable(id,na me,password) values('','$use r','$pwd')";
      mysql_query($q1 );
      }

      }
      ?>
      [/code]

      Xml of the excel file:

      [code=xml]
      <?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">
      <LastAuthor>com 6</LastAuthor>
      <Created>1996-10-14T23:33:28Z</Created>
      <LastSaved>20 08-06-04T09:57:38Z</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>9 300</WindowHeight>
      <WindowWidth>15 135</WindowWidth>
      <WindowTopX>120 </WindowTopX>
      <WindowTopY>120 </WindowTopY>
      <AcceptLabelsIn Formulas/>
      <ProtectStructu re>False</ProtectStructur e>
      <ProtectWindows >False</ProtectWindows>
      </ExcelWorkbook>
      <Styles>
      <Style ss:ID="Default" ss:Name="Normal ">
      <Alignment ss:Vertical="Bo ttom"/>
      <Borders/>
      <Font/>
      <Interior/>
      <NumberFormat/>
      <Protection/>
      </Style>
      </Styles>
      <Worksheet ss:Name="Sheet1 ">
      <Table ss:ExpandedColu mnCount="2" ss:ExpandedRowC ount="6" x:FullColumns=" 1"
      x:FullRows="1">
      <Row>
      <Cell><Data ss:Type="String ">password</Data></Cell>
      <Cell><Data ss:Type="String ">username</Data></Cell>
      </Row>
      <Row>
      <Cell><Data ss:Type="String ">sej</Data></Cell>
      <Cell><Data ss:Type="String ">sejal</Data></Cell>
      </Row>
      <Row>
      <Cell><Data ss:Type="String ">meh</Data></Cell>
      <Cell><Data ss:Type="String ">mehul</Data></Cell>
      </Row>
      <Row>
      <Cell><Data ss:Type="String ">ravi</Data></Cell>
      <Cell><Data ss:Type="String ">ravi</Data></Cell>
      </Row>
      <Row>
      <Cell><Data ss:Type="String ">rahul</Data></Cell>
      <Cell><Data ss:Type="String ">rahul</Data></Cell>
      </Row>
      <Row>
      <Cell ss:Index="2"><D ata ss:Type="String ">deval</Data></Cell>


      // here only password i have inserted.so that it is stored in database's first field.i want to store it in second field.

      </Row>
      </Table>
      <WorksheetOptio ns xmlns="urn:sche mas-microsoft-com:office:exce l">
      <Selected/>
      <Panes>
      <Pane>
      <Number>3</Number>
      <ActiveCol>1</ActiveCol>
      </Pane>
      </Panes>
      <ProtectObjects >False</ProtectObjects>
      <ProtectScenari os>False</ProtectScenario s>
      </WorksheetOption s>
      </Worksheet>
      <Worksheet ss:Name="Sheet2 ">
      <WorksheetOptio ns xmlns="urn:sche mas-microsoft-com:office:exce l">
      <ProtectObjects >False</ProtectObjects>
      <ProtectScenari os>False</ProtectScenario s>
      </WorksheetOption s>
      </Worksheet>
      <Worksheet ss:Name="Sheet3 ">
      <WorksheetOptio ns xmlns="urn:sche mas-microsoft-com:office:exce l">
      <ProtectObjects >False</ProtectObjects>
      <ProtectScenari os>False</ProtectScenario s>
      </WorksheetOption s>
      </Worksheet>
      </Workbook>
      [/code]

      I think the same node for username and password that is Cell create the problem.how can i differentiate it. Please write code for that.

      Thanks.....
      Last edited by Atli; Jun 4 '08, 12:35 PM. Reason: Added [code] tags.

      Comment

      • Atli
        Recognized Expert Expert
        • Nov 2006
        • 5062

        #4
        Should the "Index" there be "ss:Index"?
        [code=php]
        $ind = $cell->getAttribute ( 'Index' );
        [/code]
        P.S.
        Please post your code inside [code] tags.

        Comment

        • sejal17
          New Member
          • Dec 2007
          • 56

          #5
          Originally posted by Atli
          Should the "Index" there be "ss:Index"?
          [code=php]
          $ind = $cell->getAttribute ( 'Index' );
          [/code]
          P.S.
          Please post your code inside [code] tags.

          Hello
          I don't know what are u saying.Please help me.I have sent u my both file the first one is import file and the second one is the xml file of excel file.

          Please solve my problem.

          Thanks in advance.

          Comment

          • Atli
            Recognized Expert Expert
            • Nov 2006
            • 5062

            #6
            Line 31 of your PHP code:
            [codE=php]$ind = $cell->getAttribute ( 'Index' );[/code]
            Should be:
            [code=php]
            $ind = $cell->getAttribute ( 'ss:Index' );
            [/code]
            The name of the attribute excel uses to indicate which column a field entry is supposed to occupy is called 'ss:Index', rather than just 'Index'.

            Comment

            • sejal17
              New Member
              • Dec 2007
              • 56

              #7
              Originally posted by Atli
              Line 31 of your PHP code:
              [codE=php]$ind = $cell->getAttribute ( 'Index' );[/code]
              Should be:
              [code=php]
              $ind = $cell->getAttribute ( 'ss:Index' );
              [/code]
              The name of the attribute excel uses to indicate which column a field entry is supposed to occupy is called 'ss:Index', rather than just 'Index'.
              [code=php]
              <?php

              $data = array();
              include 'ez_sql.php';
              function import($itemno, $logoid,$colori d,$styleid,$des criptorid,$logo name,$colorname ,$stylename,$de scriptorname,$i temname)
              {
              $q2="select item_number from temp where item_number='$i temno'";
              $iname=mysql_qu ery($q2);
              $name=mysql_num _rows($iname);
              if($name == 0)
              {

              $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 = "";
              $logoname = "";
              $colorname = "";
              $stylename = "";
              $descriptorname = "";
              $itemname ="";

              $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]
              this is my page from where i m inserting the data of xml.I want to do that the item no that is already inserted that is not inserted again and if the logoid,colorid, styleid anyone from it is '000' then that record also not inserted.But i have problem with this code is that,suppose i have 5 itemnos,3rd one is duplicate and the forth one has logoid is 000 and fifth one has true data,then in database 3 records only inserted that is 1st,2nd.But 5 record is true but it also not inserted.So in real 1,2,5 records goes in database but i have only 1,2 goes in database.
              And my second problem is that,in excel i save the llogoid,colorid ,styleid,descri ptorid as 001,016,010,010 so it is stored in database as 1,16,10,10.And my itemno is as per this values that is 001016010010 but it is stored as it is.there is no problem with this.
              I sent my xml file in next post refer it.

              Here is my xml:
              <?xml version="1.0"?>

              <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">

              <Row ss:Height="15.7 5">
              <Cell ss:StyleID="s86 "
              ss:Formula="=CO NCATENATE((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 ">001016002 001</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">1</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">16</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">2</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">1</Data></Cell>
              <Cell ss:StyleID="s87 "
              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 ">Goldenrod </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="s87 "
              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="s82 "
              ss:Formula="=CO NCATENATE(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 Goldenrod SW-Explorer</Data></Cell>
              </Row>
              <Row>
              <Cell ss:StyleID="s86 "
              ss:Formula="=CO NCATENATE((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 ">004016002 001</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">4</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">16</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">2</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">1</Data></Cell>
              <Cell ss:StyleID="s87 "
              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 ">Goldenrod </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="s87 "
              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="s82 "
              ss:Formula="=CO NCATENATE(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 Goldenrod SW-Animal</Data></Cell>
              </Row>
              <Row>
              <Cell ss:StyleID="s86 "
              ss:Formula="=CO NCATENATE((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 ">016013002 001</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">16</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">13</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">2</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">1</Data></Cell>
              <Cell ss:StyleID="s87 "
              ss:Formula="=VL OOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Dat a
              ss:Type="String ">SW-Butterfly</Data></Cell>
              <Cell ss:Formula="=VL OOKUP(RC[-4],'Color (DEF)'!C[-6]:C[-5],2,FALSE)"><Dat a
              ss:Type="String ">Crunchber ry</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="s87 "
              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="s82 "
              ss:Formula="=CO NCATENATE(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 Crunchberry SW-Butterfly</Data></Cell>
              </Row>
              <Row>
              <Cell ss:StyleID="s86 "
              ss:Formula="=CO NCATENATE((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 ">016013002 001</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">16</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">13</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">2</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">1</Data></Cell>
              <Cell ss:StyleID="s87 "
              ss:Formula="=VL OOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Dat a
              ss:Type="String ">SW-Butterfly</Data></Cell>
              <Cell ss:Formula="=VL OOKUP(RC[-4],'Color (DEF)'!C[-6]:C[-5],2,FALSE)"><Dat a
              ss:Type="String ">Crunchber ry</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="s87 "
              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="s82 "
              ss:Formula="=CO NCATENATE(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 Crunchberry SW-Butterfly</Data></Cell>
              </Row>
              <Row>
              <Cell ss:StyleID="s86 "
              ss:Formula="=CO NCATENATE((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 ">000001003 004</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">0</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">1</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">3</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">4</Data></Cell>
              <Cell ss:StyleID="s87 "
              ss:Formula="=VL OOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Dat a
              ss:Type="String ">Test Logo</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="s87 "
              ss:Formula="=VL OOKUP(RC[-4],'Descriptor (JKL)'!C[-8]:C[-7],2,FALSE)"><Dat a
              ss:Type="String ">Wholesale Youth L</Data></Cell>
              <Cell ss:StyleID="s82 "
              ss:Formula="=CO NCATENATE(RC[-1],&quot; &quot;,RC[-2],&quot; &quot;,RC[-3],&quot; &quot;,RC[-4])"><Data
              ss:Type="String ">Wholesale Youth L Unisex Recycled T-Shirt Khaki Green Test Logo</Data></Cell>
              </Row>
              <Row>
              <Cell ss:StyleID="s86 "
              ss:Formula="=CO NCATENATE((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 ">005007002 003</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">5</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">7</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">2</Data></Cell>
              <Cell ss:StyleID="s91 "><Data ss:Type="Number ">3</Data></Cell>
              <Cell ss:StyleID="s87 "
              ss:Formula="=VL OOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Dat a
              ss:Type="String ">SW-Security</Data></Cell>
              <Cell ss:Formula="=VL OOKUP(RC[-4],'Color (DEF)'!C[-6]:C[-5],2,FALSE)"><Dat a
              ss:Type="String ">Bay</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="s87 "
              ss:Formula="=VL OOKUP(RC[-4],'Descriptor (JKL)'!C[-8]:C[-7],2,FALSE)"><Dat a
              ss:Type="String ">Wholesale Youth M</Data></Cell>
              <Cell ss:StyleID="s82 "
              ss:Formula="=CO NCATENATE(RC[-1],&quot; &quot;,RC[-2],&quot; &quot;,RC[-3],&quot; &quot;,RC[-4])"><Data
              ss:Type="String ">Wholesale Youth M Ladies Standard T-Shirt Bay SW-Security</Data></Cell>
              </Row>
              <Row>
              <Cell ss:StyleID="s86 "
              ss:Formula="=CO NCATENATE((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 ">000000000 000</Data></Cell>
              <Cell ss:StyleID="s91 "/>
              <Cell ss:StyleID="s91 "/>
              <Cell ss:StyleID="s91 "/>
              <Cell ss:StyleID="s91 "/>
              <Cell ss:StyleID="s87 "
              ss:Formula="=VL OOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Dat a
              ss:Type="String ">Test Logo</Data></Cell>
              <Cell ss:Formula="=VL OOKUP(RC[-4],'Color (DEF)'!C[-6]:C[-5],2,FALSE)"><Dat a
              ss:Type="String ">Custom Choice</Data></Cell>
              <Cell ss:Formula="=VL OOKUP(RC[-4],'StyleUnit (GHI)'!C[-7]:C[-6],2,FALSE)"><Dat a
              ss:Type="String ">Test Style</Data></Cell>
              <Cell ss:StyleID="s87 "
              ss:Formula="=VL OOKUP(RC[-4],'Descriptor (JKL)'!C[-8]:C[-7],2,FALSE)"><Dat a
              ss:Type="String ">Null Descriptor</Data></Cell>
              <Cell ss:StyleID="s82 "
              ss:Formula="=CO NCATENATE(RC[-1],&quot; &quot;,RC[-2],&quot; &quot;,RC[-3],&quot; &quot;,RC[-4])"><Data
              ss:Type="String ">Null Descriptor Test Style Custom Choice Test Logo</Data></Cell>
              </Row>
              </Workbook>

              Please help me........
              thanks......... ...
              Last edited by Atli; Jun 11 '08, 04:51 PM. Reason: Added [code] tags.

              Comment

              Working...