<?php

include_once "login.php";
require_once APPS_DIR . "/lib/tabella_v.class.php";
require_once APPS_DIR . "/lib/tabella_h.class.php";
$tabpath = "report";
$azione = strtolower($_REQUEST["azione"]);
$filter = "";
$cols = array();
if (in_array($azione, array('cerca', 'report'))) {
    include APPS_DIR . "db/search.report.ap.php";
    $risultati = new tabella_h("{$tabpath}/report_ap.tab", 'list');
    $risultati->set_dati($filter);
    $cols = $risultati->defColDataTable();
}
if ($azione == 'report') {
    require_once APPS_DIR . "plugins/PHPExcel.php";
    $objReader = PHPExcel_IOFactory::createReader('Excel2007');
    $objPHPExcel = $objReader->load("test.xlsx");
    $objPHPExcel->getActiveSheet()->fromArray($risultati->array_dati);
    $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
    $objWriter->save('output.xlsx');
}
?>
<html>
<head>
<title>Report</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<SCRIPT language="javascript" src="js/LoadLibs.js" type="text/javascript"></SCRIPT>
<script language="javascript">