Как сгенерировать документ Excel с несколькими листами из PHP?

Попробуйте взглянуть на PHPExcel . Это простой пример, который создает файл Excel с двумя листами:

 <?php require_once 'PHPExcel.php'; require_once 'PHPExcel/IOFactory.php'; // Create new PHPExcel object $objPHPExcel = new PHPExcel(); // Create a first sheet, representing sales data $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'Something'); // Rename sheet $objPHPExcel->getActiveSheet()->setTitle('Name of Sheet 1'); // Create a new worksheet, after the default sheet $objPHPExcel->createSheet(); // Add some data to the second sheet, resembling some different data types $objPHPExcel->setActiveSheetIndex(1); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'More data'); // Rename 2nd sheet $objPHPExcel->getActiveSheet()->setTitle('Second sheet'); // Redirect output to a client's web browser (Excel5) header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename="name_of_file.xls"'); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); 

Если вы имеете в виду, что ваш PHP-скрипт создаст файл Excel, напишите на нем какие-либо материалы и т. Д., Затем предложите загрузить клиент, вы можете просто использовать встроенный COM-модуль PHP. См. http://us2.php.net/manual/en/class.com.php для всех видов примеров. Однако вам понадобится Excel (или клон, такой как OpenOffice), установленный на сервере. Если вы этого не сделаете, возможно, ответ Марка Бейкера выше будет работать без него.

  <?php require_once 'PHPExcel.php'; require_once 'PHPExcel/IOFactory.php'; //Update the multiple sheets in PHP excel $report_file = 'Report_' . date('Ym-d') . '.xlsx'; $report_file_exists = 0; //If the file doesnot exist , create new otherwise append the data at last if (!file_exists($report_file)) { $objPHPExcel = new PHPExcel(); } else { $report_file_exists = 1; $objPHPExcel = PHPExcel_IOFactory::load($report_file); } $columns = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); //Sheet details $sheet_details = array( //1st sheet details 0 => array('sheet_title' => 'Products', 'sheet_heading' => array('Article_Number','Name'), 'sheet_data' => array('1234','Pen') ), //2nd Sheet Details 1 => array('sheet_title' => 'Categories', 'sheet_heading' => array('Category Id','Name'), 'sheet_data' => array(123,'Accessories') ) ); $sheet_count = 0; $row = 1; $column = 0; while ($sheet_count <= count($sheet_details)) { $objWorkSheet = ''; if ($report_file_exists == 0) { if ($sheet_count > 0) { $objWorkSheet = $objPHPExcel->createSheet($sheet_count); } else { $objWorkSheet = $objPHPExcel->getActiveSheet(); } $row = 1; $column = 0; foreach ($sheet_details[$sheet_count]['sheet_heading'] as $head) { $objWorkSheet->setCellValue($columns[$column] . $row, $head); $column++; } } else { $objPHPExcel->setActiveSheetIndex($sheet_count); $objWorkSheet = $objPHPExcel->getActiveSheet($sheet_count); } $row = $objWorkSheet->getHighestRow() + 1; //row count foreach ($sheet_details[$sheet_count]['sheet_data'] as $report_details) { $column = 0; foreach ($report_details as $data) { $objWorkSheet->setCellValue($columns[$column] . $row, $data); $column++; } $row++; } $objWorkSheet->setTitle($sheet_details[$sheet_count]['sheet_title']); $sheet_count++; } $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); $objWriter->save($report_file); ?> 

Вы можете добиться этого

  $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setCreator("creater"); $objPHPExcel->getProperties()->setLastModifiedBy("Middle field"); $objPHPExcel->getProperties()->setSubject("Subject"); $objWorkSheet = $objPHPExcel->createSheet(); $work_sheet_count=3//number of sheets you want to create $work_sheet=0; while($work_sheet<=$work_sheet_count){ if($work_sheet==0){ $objWorkSheet->setTitle("Worksheet$work_sheet"); $objPHPExcel->setActiveSheetIndex($work_sheet)->setCellValue('A1', 'SR No. In sheet 1')->getStyle('A1')->getFont()->setBold(true); $objPHPExcel->setActiveSheetIndex($work_sheet)->setCellValueByColumnAndRow($col++, $row++, $i++);//setting value by column and row indexes if needed } if($work_sheet==1){ $objWorkSheet->setTitle("Worksheet$work_sheet"); $objPHPExcel->setActiveSheetIndex($work_sheet)->setCellValue('A1', 'SR No. In sheet 2')->getStyle('A1')->getFont()->setBold(true); $objPHPExcel->setActiveSheetIndex($work_sheet)->setCellValueByColumnAndRow($col++, $row++, $i++);//setting value by column and row indexes if needed } if($work_sheet==2){ $objWorkSheet = $objPHPExcel->createSheet($work_sheet_count); $objWorkSheet->setTitle("Worksheet$work_sheet"); $objPHPExcel->setActiveSheetIndex($work_sheet)->setCellValue('A1', 'SR No. In sheet 3')->getStyle('A1')->getFont()->setBold(true); $objPHPExcel->setActiveSheetIndex($work_sheet)->setCellValueByColumnAndRow($col++, $row++, $i++);//setting value by column and row indexes if needed } $work_sheet++; } в  $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setCreator("creater"); $objPHPExcel->getProperties()->setLastModifiedBy("Middle field"); $objPHPExcel->getProperties()->setSubject("Subject"); $objWorkSheet = $objPHPExcel->createSheet(); $work_sheet_count=3//number of sheets you want to create $work_sheet=0; while($work_sheet<=$work_sheet_count){ if($work_sheet==0){ $objWorkSheet->setTitle("Worksheet$work_sheet"); $objPHPExcel->setActiveSheetIndex($work_sheet)->setCellValue('A1', 'SR No. In sheet 1')->getStyle('A1')->getFont()->setBold(true); $objPHPExcel->setActiveSheetIndex($work_sheet)->setCellValueByColumnAndRow($col++, $row++, $i++);//setting value by column and row indexes if needed } if($work_sheet==1){ $objWorkSheet->setTitle("Worksheet$work_sheet"); $objPHPExcel->setActiveSheetIndex($work_sheet)->setCellValue('A1', 'SR No. In sheet 2')->getStyle('A1')->getFont()->setBold(true); $objPHPExcel->setActiveSheetIndex($work_sheet)->setCellValueByColumnAndRow($col++, $row++, $i++);//setting value by column and row indexes if needed } if($work_sheet==2){ $objWorkSheet = $objPHPExcel->createSheet($work_sheet_count); $objWorkSheet->setTitle("Worksheet$work_sheet"); $objPHPExcel->setActiveSheetIndex($work_sheet)->setCellValue('A1', 'SR No. In sheet 3')->getStyle('A1')->getFont()->setBold(true); $objPHPExcel->setActiveSheetIndex($work_sheet)->setCellValueByColumnAndRow($col++, $row++, $i++);//setting value by column and row indexes if needed } $work_sheet++; } 

$filename='file-name'.'.xls'; //save our workbook as this file name header('Content-Type: application/vnd.ms-excel'); //mime type header('Content-Disposition: attachment;filename="'.$filename.'"'); //tell browser what's the file name header('Cache-Control: max-age=0'); //no cache

  $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output');