How to create xls/xlsx using php?

Question

PHP

You need to use php to create an excel table. No styles, functions, etc. The simplest board. I looked at the phpSpeedSheet library, but I don't have enough knowledge to understand how to use it. Are there any other libraries that would just include via require and work.

Answer 1

https://github.com/PHPOffice/PHPExcel
I used this fiddle like this:

$data // массив с данными (имя, email и т п)
$fullName = 		isset($data['FullName']) ? $data['FullName'] : '';
$accommodation =        isset($data['Accommodation']) ? $data['Accommodation'] : '';
$email = 			isset($data['Email']) ? $data['Email'] : '';
$phone = 			isset($data['Phone']) ? $data['Phone'] : '';
$date = 			date('Y-m-d, H:i:s');

require_once 'app/PHPExcel.php'; //Подключаем библиотеку

$fileType = 'Excel5';
$fileName = 'название -_файла.xls';

$objReader = PHPExcel_IOFactory::createReader($fileType);
$objPHPExcel = $objReader->load($fileName);
$objPHPExcel->setActiveSheetIndex(0);

//Получаем последний номер строки
$num_rows = $objPHPExcel->getActiveSheet()->getHighestRow() + 1;

//Добавляем данные
$objPHPExcel->getActiveSheet()->setCellValue('A'.$num_rows, $fullName); //A,B,C,D - столбцы
$objPHPExcel->getActiveSheet()->setCellValue('B'.$num_rows, $accommodation);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$num_rows, $email);
$objPHPExcel->getActiveSheet()->setCellValue('D.$num_rows, $phone);
$objPHPExcel->getActiveSheet()->setCellValue('E'.$num_rows, $date);

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, $fileType);
$objWriter->save($fileName);

Answer 2

She is quite easy to learn. Easier already nowhere.
Start small https://phpspreadsheet.readthedocs.io/en/develop/#... See the example, try it out

Answer 3

What did PHPExcel not please?

Answer 4

SimpleXLSXGen

$books = [
  ['ISBN', 'title', 'author', 'publisher', 'ctry' ],
  [618260307, 'The Hobbit', 'J. R. R. Tolkien', 'Houghton Mifflin', 'USA'],
  [908606664, 'Slinky Malinki', 'Lynley Dodd', 'Mallinson Rendel', 'NZ']
];
$xlsx = SimpleXLSXGen::fromArray( $books );
$xlsx->saveAs('books.xlsx');
// $xlsx->downloadAs('books.xlsx');