So I try to put data into a Excel sheet, I do it this way,
first is send the data via a ajax post:
<!doctype html>
<html lang="en">
<head>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
</head>
<script>
$(document).ready(function(){
$("#form").on('submit', function() {
$(function() {
var hello = "hello world";
$.ajax ({
type: 'POST',
url: 'example.php',
data: {hello: hello},
success: function(result) {
console.log('success');
}
});
});
});
});
</script>
<body>
<form id="form" action="example.php" method="post">
<input type="submit" value="submit">
</form>
</body>
</html>
Then I put it into a excel sheet:
<?php
include "../includes/PHPExcel.php";
$title = "Verrijking ";
$hello = $_POST['hello'];
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("RM Netherlands B.V.")
->setLastModifiedBy("RM Netherlands B.V.")
->setTitle($title)
->setSubject($title)
->setDescription($title)
->setKeywords($title)
->setCategory($title);
$pcbestand = date('Ymdhis') . ".xlsx";
$objPHPExcel->getActiveSheet()
->setCellValue("A"."1", $hello);
$objPHPExcel->getActiveSheet()->getColumnDimension("A")->setAutoSize(true);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save($pcbestand);
$file = $pcbestand;
header('Content-disposition: attachment; filename='.$file);
header('Content-type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Length: ' . filesize($file));
header('Content-Transfer-Encoding: binary');
header('Cache-Control: must-revalidate');
header('Pragma: public');
ob_clean();
flush();
readfile($file);
$DelFilePath = $setup['/var/www/clients/client1/web1/web/nordin/'.$pcbestand.''] . $pcbestand;
if (file_exists($DelFilePath)) { unlink ($DelFilePath); }
?>
the last part create's a save as file dialog and make's sure it isn't uploaded to the server.
But this is the problem I don't get the ajax post ($_POST['hello']) into my excel sheet even tho the ajax post is successful. What am I doing wrong? please help.
