Advertisement
Guest User

Untitled

a guest
Mar 25th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.85 KB | None | 0 0
  1. $xmlDoc = new DOMDocument();
  2.         $xmlDoc->load($target_file);
  3.         $x = $xmlDoc->documentElement;
  4.  
  5.         $objReader = PHPExcel_IOFactory::createReader('Excel2007');
  6.         $objPHPExcel = $objReader->load("../DADOS/dados_processados.xlsx");
  7.  
  8.         $worksheet = $objPHPExcel->getActiveSheet();
  9.        
  10.         $lastLine = $worksheet->getHighestRow();
  11.         $line=$lastLine+1;
  12.         //print "Próxima linha para inserir dados é a ".$netxLine.".<br>";
  13.         $lastCol = $worksheet->getHighestColumn();
  14.  
  15.         $col = 'A';
  16.  
  17.         foreach ($x->childNodes AS $k) {
  18.            
  19.             if($k->nodeName!="#text")
  20.             {
  21.                 //Só os bons valores
  22.                 //print $k->nodeName."=  ".$k->nodeValue."<br>";
  23.                
  24.                 $worksheet->setCellValue($col.$line,$k->nodeValue);
  25.                 $col++;
  26.  
  27.             }
  28.         }
  29.  
  30.         $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
  31.         $objWriter->save("../DADOS/dados_processados.xlsx");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement