473,385 Members | 1,655 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > php > questions > import excel file into database

Join Bytes to post your question to a community of 473,385 software developers and data experts.

import excel file into database

56
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......
Jun 2 '08 #1
6 2278
Atli
5,058 Expert 4TB
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.
Jun 2 '08 #2
sejal17
56
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:
Expand|Select|Wrap|Line Numbers
  1. <?php
  2.  
  3.   $data = array();
  4.   include 'ez_sql.php';
  5.   function add_person( $username, $password)
  6.   {
  7.   global $data;
  8.  
  9.   $data []= array(
  10.   'username' => $username,
  11.   'password' => $password,
  12.  
  13.   );
  14.   } 
  15.   if ( $_FILES['file']['tmp_name'] )
  16.   {
  17.   $dom = DOMDocument::load( $_FILES['file']['tmp_name'] );
  18.   $rows = $dom->getElementsByTagName( 'Row' );
  19.   $first_row = true;
  20.   foreach ($rows as $row)
  21.   {
  22.   if ( !$first_row )
  23.   {
  24.   $username = "";
  25.   $password = "";
  26.  
  27.   $index = 1;
  28.  $cells = $row->getElementsByTagName( 'Cell' );
  29.   foreach( $cells as $cell )
  30.   { 
  31.   $ind = $cell->getAttribute( 'Index' );
  32.   if ( $ind != null ) $index = $ind;
  33.  
  34.   if ( $index == 1 ) $username = $cell->nodeValue;
  35.   if ( $index == 2 ) $password = $cell->nodeValue;
  36.  
  37.   $index += 1;
  38.   }
  39.  
  40.   add_person( $username, $password);
  41.   }
  42.   $first_row = false;
  43.   }
  44.   }
  45.  
  46.    foreach( $data as $row ) {
  47.   $user=$row['username'];
  48.   $pwd=$row['password'];
  49.  
  50.  
  51.   $q2="select name from usertable where name='$user'";
  52.   $name=$db->get_var($q2);
  53.   if(!$name)
  54.   {
  55.         $q1="insert into usertable(id,name,password) values('','$user','$pwd')";
  56.           mysql_query($q1);
  57.    }
  58.  
  59.   }
  60.   ?>
  61.  
Xml of the excel file:

Expand|Select|Wrap|Line Numbers
  1. <?xml version="1.0"?>
  2. <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
  3.  xmlns:o="urn:schemas-microsoft-com:office:office"
  4.  xmlns:x="urn:schemas-microsoft-com:office:excel"
  5.  xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
  6.  xmlns:html="http://www.w3.org/TR/REC-html40">
  7.  <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  8.   <LastAuthor>com6</LastAuthor>
  9.   <Created>1996-10-14T23:33:28Z</Created>
  10.   <LastSaved>2008-06-04T09:57:38Z</LastSaved>
  11.   <Version>10.2625</Version>
  12.  </DocumentProperties>
  13.  <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
  14.   <DownloadComponents/>
  15.   <LocationOfComponents HRef="file:///\\comp4\Deval%20(F)\Office%20XP\"/>
  16.  </OfficeDocumentSettings>
  17.  <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  18.   <WindowHeight>9300</WindowHeight>
  19.   <WindowWidth>15135</WindowWidth>
  20.   <WindowTopX>120</WindowTopX>
  21.   <WindowTopY>120</WindowTopY>
  22.   <AcceptLabelsInFormulas/>
  23.   <ProtectStructure>False</ProtectStructure>
  24.   <ProtectWindows>False</ProtectWindows>
  25.  </ExcelWorkbook>
  26.  <Styles>
  27.   <Style ss:ID="Default" ss:Name="Normal">
  28.    <Alignment ss:Vertical="Bottom"/>
  29.    <Borders/>
  30.    <Font/>
  31.    <Interior/>
  32.    <NumberFormat/>
  33.    <Protection/>
  34.   </Style>
  35.  </Styles>
  36.  <Worksheet ss:Name="Sheet1">
  37.   <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="6" x:FullColumns="1"
  38.    x:FullRows="1">
  39.    <Row>
  40.     <Cell><Data ss:Type="String">password</Data></Cell>
  41.     <Cell><Data ss:Type="String">username</Data></Cell>
  42.    </Row>
  43.    <Row>
  44.     <Cell><Data ss:Type="String">sej</Data></Cell>
  45.     <Cell><Data ss:Type="String">sejal</Data></Cell>
  46.    </Row>
  47.    <Row>
  48.     <Cell><Data ss:Type="String">meh</Data></Cell>
  49.     <Cell><Data ss:Type="String">mehul</Data></Cell>
  50.    </Row>
  51.    <Row>
  52.     <Cell><Data ss:Type="String">ravi</Data></Cell>
  53.     <Cell><Data ss:Type="String">ravi</Data></Cell>
  54.    </Row>
  55.    <Row>
  56.     <Cell><Data ss:Type="String">rahul</Data></Cell>
  57.     <Cell><Data ss:Type="String">rahul</Data></Cell>
  58.    </Row>
  59.    <Row>
  60.     <Cell ss:Index="2"><Data ss:Type="String">deval</Data></Cell> 
  61.  
  62.  
  63.  // here only password i have inserted.so that it is stored in database's first field.i want to store it in second field.
  64.  
  65.   </Row>
  66.   </Table>
  67.   <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
  68.    <Selected/>
  69.    <Panes>
  70.     <Pane>
  71.      <Number>3</Number>
  72.      <ActiveCol>1</ActiveCol>
  73.     </Pane>
  74.    </Panes>
  75.    <ProtectObjects>False</ProtectObjects>
  76.    <ProtectScenarios>False</ProtectScenarios>
  77.   </WorksheetOptions>
  78.  </Worksheet>
  79.  <Worksheet ss:Name="Sheet2">
  80.   <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
  81.    <ProtectObjects>False</ProtectObjects>
  82.    <ProtectScenarios>False</ProtectScenarios>
  83.   </WorksheetOptions>
  84.  </Worksheet>
  85.  <Worksheet ss:Name="Sheet3">
  86.   <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
  87.    <ProtectObjects>False</ProtectObjects>
  88.    <ProtectScenarios>False</ProtectScenarios>
  89.   </WorksheetOptions>
  90.  </Worksheet>
  91. </Workbook>
  92.  
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.....
Jun 4 '08 #3
Atli
5,058 Expert 4TB
Should the "Index" there be "ss:Index"?
Expand|Select|Wrap|Line Numbers
  1. $ind = $cell->getAttribute( 'Index' );
  2.  
P.S.
Please post your code inside [code] tags.
Jun 4 '08 #4
sejal17
56
Should the "Index" there be "ss:Index"?
Expand|Select|Wrap|Line Numbers
  1. $ind = $cell->getAttribute( 'Index' );
  2.  
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.
Jun 6 '08 #5
Atli
5,058 Expert 4TB
Line 31 of your PHP code:
Expand|Select|Wrap|Line Numbers
  1. $ind = $cell->getAttribute( 'Index' );
Should be:
Expand|Select|Wrap|Line Numbers
  1. $ind = $cell->getAttribute( 'ss:Index' );
  2.  
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'.
Jun 6 '08 #6
sejal17
56
Line 31 of your PHP code:
Expand|Select|Wrap|Line Numbers
  1. $ind = $cell->getAttribute( 'Index' );
Should be:
Expand|Select|Wrap|Line Numbers
  1. $ind = $cell->getAttribute( 'ss:Index' );
  2.  
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'.
Expand|Select|Wrap|Line Numbers
  1. <?php
  2.  
  3.   $data = array();
  4.   include 'ez_sql.php';
  5.   function import($itemno,$logoid,$colorid,$styleid,$descriptorid,$logoname,$colorname,$stylename,$descriptorname,$itemname)
  6.   {
  7.    $q2="select item_number from temp where item_number='$itemno'";
  8.   $iname=mysql_query($q2);
  9.   $name=mysql_num_rows($iname);
  10.   if($name == 0)
  11.   {
  12.  
  13.   $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')";
  14.               mysql_query($q1);
  15.   }
  16.  
  17.   } 
  18.   if ( $_FILES['file']['tmp_name'] )
  19.   {
  20.   $dom = DOMDocument::load( $_FILES['file']['tmp_name'] );
  21.   $rows = $dom->getElementsByTagName( 'Row' );
  22.   $first_row = true;
  23.   $i = 0;
  24.   foreach ($rows as $row)
  25.   {
  26.       if ( !$first_row )
  27.       {
  28.           $itemno = "";
  29.         $logoid = "";
  30.         $colorid = "";
  31.         $styleid = "";
  32.         $descriptorid = "";
  33.         $logoname = "";
  34.         $colorname = "";
  35.         $stylename = "";
  36.         $descriptorname = "";
  37.         $itemname ="";
  38.  
  39.           $index = 1;
  40.          $cells = $row->getElementsByTagName( 'Cell' );
  41.           foreach( $cells as $cell )
  42.           {
  43.                   if ( $index == 1 )
  44.                 {    
  45.                     $itemno = $cell->nodeValue;
  46.                 }
  47.                 if($itemno != '000000000000')        
  48.                 {    
  49.                     if( $index == 2 )
  50.                     {
  51.                           $logoid = $cell->nodeValue;
  52.                     }
  53.                     if($logoid != '000')
  54.                     {
  55.                         if( $index == 3 )
  56.                         {
  57.                               $colorid = $cell->nodeValue;
  58.                         }    
  59.                         if($colorid != '000')
  60.                         {
  61.                             if( $index == 4 )
  62.                             {            
  63.                                   $styleid = $cell->nodeValue;
  64.                             }    
  65.                             if($styleid != '000')
  66.                             {
  67.                                 if( $index == 5 )
  68.                                 {
  69.                                       $descriptorid = $cell->nodeValue;
  70.                                 }    
  71.                                 if( $index == 6 )
  72.                                 {
  73.                                       $logoname = $cell->nodeValue;
  74.                                 }    
  75.                                 if( $index == 7 )
  76.                                 {
  77.                                       $colorname = $cell->nodeValue;
  78.                                 }
  79.                                 if( $index == 8 )
  80.                                 {
  81.                                       $stylename = $cell->nodeValue;
  82.                                 }    
  83.                                 if( $index == 9 )
  84.                                 {
  85.                                       $descriptorname = $cell->nodeValue;
  86.                                 }
  87.                                 if( $index == 10 )
  88.                                 {
  89.                                       $itemname = $cell->nodeValue;
  90.                                 }    
  91.                             }
  92.                             else
  93.                             { exit; }    
  94.                         }
  95.                         else
  96.                         { exit; }
  97.                     }
  98.                     else
  99.                     { exit; }
  100.                 }    
  101.                 else
  102.                 { exit; }            
  103.  
  104.             $index += 1;    
  105.         }              
  106.           import($itemno,$logoid,$colorid,$styleid,$descriptorid,$logoname,$colorname,$stylename,$descriptorname,$itemname);    
  107.   }$first_row = false;
  108.  
  109.   }
  110.   }
  111.  
  112.   ?>
  113.  
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,descriptorid 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:ExpandedColumnCount="11" ss:ExpandedRowCount="43" x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="15">

<Row ss:Height="15.75">
<Cell ss:StyleID="s86"
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">001016002001</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="=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">Goldenrod</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="s87"
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="s82"
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 Goldenrod SW-Explorer</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s86"
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">004016002001</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="=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">Goldenrod</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="s87"
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="s82"
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 Goldenrod SW-Animal</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s86"
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">016013002001</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="=VLOOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Data
ss:Type="String">SW-Butterfly</Data></Cell>
<Cell ss:Formula="=VLOOKUP(RC[-4],'Color (DEF)'!C[-6]:C[-5],2,FALSE)"><Data
ss:Type="String">Crunchberry</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="s87"
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="s82"
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 Crunchberry SW-Butterfly</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s86"
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">016013002001</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="=VLOOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Data
ss:Type="String">SW-Butterfly</Data></Cell>
<Cell ss:Formula="=VLOOKUP(RC[-4],'Color (DEF)'!C[-6]:C[-5],2,FALSE)"><Data
ss:Type="String">Crunchberry</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="s87"
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="s82"
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 Crunchberry SW-Butterfly</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID="s86"
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">000001003004</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="=VLOOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Data
ss:Type="String">Test Logo</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="s87"
ss:Formula="=VLOOKUP(RC[-4],'Descriptor (JKL)'!C[-8]:C[-7],2,FALSE)"><Data
ss:Type="String">Wholesale Youth L</Data></Cell>
<Cell ss:StyleID="s82"
ss:Formula="=CONCATENATE(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="=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">005007002003</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="=VLOOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Data
ss:Type="String">SW-Security</Data></Cell>
<Cell ss:Formula="=VLOOKUP(RC[-4],'Color (DEF)'!C[-6]:C[-5],2,FALSE)"><Data
ss:Type="String">Bay</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="s87"
ss:Formula="=VLOOKUP(RC[-4],'Descriptor (JKL)'!C[-8]:C[-7],2,FALSE)"><Data
ss:Type="String">Wholesale Youth M</Data></Cell>
<Cell ss:StyleID="s82"
ss:Formula="=CONCATENATE(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="=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">000000000000</Data></Cell>
<Cell ss:StyleID="s91"/>
<Cell ss:StyleID="s91"/>
<Cell ss:StyleID="s91"/>
<Cell ss:StyleID="s91"/>
<Cell ss:StyleID="s87"
ss:Formula="=VLOOKUP(RC[-4],'DesignLogo (ABC)'!C[-5]:C[-4],2,FALSE)"><Data
ss:Type="String">Test Logo</Data></Cell>
<Cell ss:Formula="=VLOOKUP(RC[-4],'Color (DEF)'!C[-6]:C[-5],2,FALSE)"><Data
ss:Type="String">Custom Choice</Data></Cell>
<Cell ss:Formula="=VLOOKUP(RC[-4],'StyleUnit (GHI)'!C[-7]:C[-6],2,FALSE)"><Data
ss:Type="String">Test Style</Data></Cell>
<Cell ss:StyleID="s87"
ss:Formula="=VLOOKUP(RC[-4],'Descriptor (JKL)'!C[-8]:C[-7],2,FALSE)"><Data
ss:Type="String">Null Descriptor</Data></Cell>
<Cell ss:StyleID="s82"
ss:Formula="=CONCATENATE(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............
Jun 9 '08 #7

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

Similar topics

8
Import excel file into mysql database
by: Johnny | last post by:
I was looking for information on how to import an excel file or other text file into a MySql database. I have done this with both access and SQL Server and am looking for a way to do this in...
MySQL Database
5
Fixed Width Text File Import Programmtically
by: Johnny Meredith | last post by:
I have seven huge fixed width text file that I need to import to Access. They contain headers, subtotals, etc. that are not needed. There is also some corrupt data that we know about and can...
Microsoft Access / VBA
1
Import from Excel
by: John Hewitt | last post by:
A 'newbie' question - importing into Access from Excel. Googled the group postings but I can't find the amswer I have a 50 line three column file in Excel that contains Names and Tel numbers....
Microsoft Access / VBA
15
Access Import from Excel
by: daniroy | last post by:
Hello everybody, your help will be very very welcome on a very classic question... I have some Excell Macro background, a little bit of VBA knowledge. I import daily from Internet series of...
Microsoft Access / VBA
1
File Import Wizard
by: David Berry | last post by:
Hi All. I'm looking for any help or sample code that can show me how to make a file import wizard in ASP.NET (VB preferred) like the one that MS Access uses. I'm working on a web site where the...
Visual Basic .NET
3
how to import Excel file into an already normalized database?
by: fkulaga | last post by:
Hi all, I have a problem with the issue in the subject, i have all data in one big excel file, in a denormalized form, and on the other side, i have mysql database with many tables, which is...
MySQL Database
10
Import Excel data with .NET
by: Niklas | last post by:
Hi Before I start coding I need to be sure that nobody else has not done it yet and that I can use it. I need an import utility which import data from Excel to a database or some object in...
C# / C Sharp
3
How can I import 2 csv files into 1 table
by: ninrulz | last post by:
I will try to explain my situation. I know that it is hard to offers solutions without fully understanding what people would like to achieve. I receive 2 csv files every month. The csv files...
Microsoft Access / VBA
1
import from excel using vb 6.0
by: baling | last post by:
Hi.... Hi everybody, i have a code that i make in VBA and know I want to use this code in to VB6. But i don't know how to use that code in to VB 6.0 Please correct this code so i can use it in VB...
Visual Basic 4 / 5 / 6
6
VBA to import Excel File to Access table
by: provor | last post by:
Hello, I have the following code that I am using when a user presses a button to import an excel file into a table. The code is hard coded to point to the correct table. This works great for this...
Microsoft Access / VBA
0
Basic Javascript concepts
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
Javascript
0
Batch import of multiple excel files into the database
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
Data Management
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Algorithms / Advanced Math
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
0
How to build RAID in BIOS?
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
Computer Hardware
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
jinu1996
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...
Online Marketing

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!