Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $xmlDoc = new DOMDocument();
- $xmlDoc->load($target_file);
- $x = $xmlDoc->documentElement;
- $objReader = PHPExcel_IOFactory::createReader('Excel2007');
- $objPHPExcel = $objReader->load("../DADOS/dados_processados.xlsx");
- $worksheet = $objPHPExcel->getActiveSheet();
- $lastLine = $worksheet->getHighestRow();
- $line=$lastLine+1;
- //print "Próxima linha para inserir dados é a ".$netxLine.".<br>";
- $lastCol = $worksheet->getHighestColumn();
- $col = 'A';
- foreach ($x->childNodes AS $k) {
- if($k->nodeName!="#text")
- {
- //Só os bons valores
- //print $k->nodeName."= ".$k->nodeValue."<br>";
- $worksheet->setCellValue($col.$line,$k->nodeValue);
- $col++;
- }
- }
- $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
- $objWriter->save("../DADOS/dados_processados.xlsx");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement