PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- <?PHP
- include('blocks/bd.php');
- require_once 'PHPExcel-1.8/Classes/PHPExcel.php';
- $phpexcel = new PHPExcel();
- $page = $phpexcel->setActiveSheetIndex(0);
- $page->setCellValue("A1", "id");
- $page->setCellValue("B1", "nomer");
- $page->setCellValue("C1", "nlf");
- $page->setCellValue("D1", "zag");
- $page->setCellValue("E1", "problema");
- $s = 2;
- {
- $s++;
- $page->setCellValue("A$s", $row['id']);
- $page->setCellValue("B$s", $row['nomer']);
- $page->setCellValue("C$s", $row['nlf']);
- $page->setCellValue("D$s", $row['zag']);
- $page->setCellValue("E$s", $row['problema']);
- }
- $page->setTitle("Example");
- $objWriter = PHPExcel_IOFactory::createWriter($phpexcel, 'Excel2007');
- $objWriter->save("example.xlsx");
- ?>