PHP код (Отобразить)
PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- <?PHP
- // подключаем все что нужно
- require_once 'config.php';
- require_once "Classes/PHPExcel.php";
- $res = oci_parse ($conn, "select art.aid_artnr, art.artbez from globusm.art where art.aid_artnr in ('00000167000', '00004426011')");
- oci_execute ($res);
- $objPHPExcel = new PHPExcel();
- $objPHPExcel->getProperties()->setCreator("Maarten Balliauw")
- ->setLastModifiedBy("Maarten Balliauw")
- ->setTitle("Office 2007 XLSX Test Document")
- ->setSubject("Office 2007 XLSX Test Document")
- ->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")
- ->setKeywords("office 2007 openxml php")
- ->setCategory("Test result file");
- $i = null;
- while ($rez = oci_fetch_array($res, OCI_ASSOC)){
- foreach($rez as $val)
- {
- $i++;
- $objPHPExcel->setActiveSheetIndex(0)->setCellValue("A$i", $val['art.aid_artnr']);
- $objPHPExcel->setActiveSheetIndex(0)->setCellValue("B$i", $val['art.artbez']);
- }
- }
- $objPHPExcel->setActiveSheetIndex(0);
- $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
- $objWriter->save('php://output');
- // print_r($rez);
- ?>