$codigo = trim($objWorksheet->getCellByColumnAndRow(0, $i)->getValue());
$descrip = utf8_encode(trim($objWorksheet->getCellByColumnAndRow(1, $i)->getValue()));
$marca = utf8_encode(trim($objWorksheet->getCellByColumnAndRow(2, $i)->getValue()));
$refer = utf8_encode(trim($objWorksheet->getCellByColumnAndRow(3, $i)->getValue()));
$precio = $objWorksheet->getCellByColumnAndRow(4, $i)->getValue();
$respon1 = $conecta->Insertar_descripcion($descrip);
if (isset($respon1['last_cod_id'])) {
$codi_desc = $respon1['last_cod_id'];
} else {
$select_desc = 'SELECT Descri_id FROM produc_descripcion_ WHERE Descri_nomb = "' . $descrip . '"';
$busc1 = $conecta->consultas($select_desc);
$codi_desc = $busc1["Descri_id"];
//var_dump($codi_desc);
//echo " descuen ".$codi_desc." ";
}
$respon2 = $conecta->Insertar_marca($marca);
if (isset($respon2['last_cod_id'])) {
$codi_marc = $respon2['last_cod_id'];
} else {
$select_marc = 'SELECT Marca_id FROM produc_marca WHERE Marca_nomb = "' . $marca . '"';
$busc2 = $conecta->consultas($select_marc);
$codi_marc = $busc2["Marca_id"];
//var_dump($codi_marc);
//echo " marca ".$codi_desc." ";
}
$respon3 = $conecta->Insertar_referencia($refer);
if (isset($respon3['last_cod_id'])) {
$codi_refe = $respon3['last_cod_id'];
} else {
$select_refe = 'SELECT Referen_id FROM produc_referencia WHERE Referenc_nomb = "' . $refer . '"';
$busc3 = $conecta->consultas($select_refe);
