File Formats

use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

// Reading
$spreadsheet = IOFactory::load('file.xlsx');

// Writing
$writer = new Xlsx($spreadsheet);
$writer->save('output.xlsx');

use PhpOffice\PhpSpreadsheet\Reader\Xls;
use PhpOffice\PhpSpreadsheet\Writer\Xls as XlsWriter;

// Reading
$reader = new Xls();
$spreadsheet = $reader->load('file.xls');

// Writing
$writer = new XlsWriter($spreadsheet);
$writer->save('output.xls');

use PhpOffice\PhpSpreadsheet\Reader\Ods;
use PhpOffice\PhpSpreadsheet\Writer\Ods as OdsWriter;

// Reading
$reader = new Ods();
$spreadsheet = $reader->load('file.ods');

// Writing
$writer = new OdsWriter($spreadsheet);
$writer->save('output.ods');

use PhpOffice\PhpSpreadsheet\Reader\Csv;
use PhpOffice\PhpSpreadsheet\Writer\Csv as CsvWriter;

// Reading
$reader = new Csv();
$reader->setDelimiter(',');
$reader->setEnclosure('"');
$reader->setSheetIndex(0);
$spreadsheet = $reader->load('file.csv');

// Writing
$writer = new CsvWriter($spreadsheet);
$writer->setDelimiter(',');
$writer->setEnclosure('"');
$writer->setLineEnding("\r\n");
$writer->setSheetIndex(0);
$writer->save('output.csv');

$reader = new Csv();
$reader->setDelimiter(';');           // Change delimiter
$reader->setEnclosure('"');           // Quote character
$reader->setEscapeCharacter('\\');    // Escape character
$reader->setInputEncoding('UTF-8');   // Character encoding

$writer = new CsvWriter($spreadsheet);
$writer->setDelimiter(',');
$writer->setEnclosure('"');
$writer->setLineEnding("\r\n");       // Windows line endings
$writer->setUseBOM(true);             // Add UTF-8 BOM
$writer->setIncludeSeparatorLine(false);

use PhpOffice\PhpSpreadsheet\Reader\Html;
use PhpOffice\PhpSpreadsheet\Writer\Html as HtmlWriter;

// Reading
$reader = new Html();
$spreadsheet = $reader->load('table.html');

// Writing
$writer = new HtmlWriter($spreadsheet);
$writer->save('output.html');

$writer = new HtmlWriter($spreadsheet);
$writer->setSheetIndex(0);            // Which sheet to export
$writer->setImagesRoot('images/');    // Path for images
$writer->setEmbedImages(false);       // Embed images as base64
$writer->setUseInlineCss(true);       // Use inline styles

# Option 1: Dompdf
composer require dompdf/dompdf

# Option 2: mPDF
composer require mpdf/mpdf

# Option 3: TCPDF
composer require tecnickcom/tcpdf

use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Writer\Pdf\Dompdf;
use PhpOffice\PhpSpreadsheet\Writer\Pdf\Mpdf;
use PhpOffice\PhpSpreadsheet\Writer\Pdf\Tcpdf;

// Register your chosen PDF writer
IOFactory::registerWriter('Pdf', Dompdf::class);
// or
IOFactory::registerWriter('Pdf', Mpdf::class);
// or
IOFactory::registerWriter('Pdf', Tcpdf::class);

// Create and save
$writer = IOFactory::createWriter($spreadsheet, 'Pdf');
$writer->save('output.pdf');

$writer = IOFactory::createWriter($spreadsheet, 'Pdf');
$writer->setSheetIndex(0);            // Which sheet to export
$writer->writeAllSheets();            // Export all sheets

use PhpOffice\PhpSpreadsheet\IOFactory;

// Load file with automatic format detection
$spreadsheet = IOFactory::load('unknown-format.xlsx');

// Create reader for specific format
$reader = IOFactory::createReader('Xlsx');
$spreadsheet = $reader->load('file.xlsx');

// Create writer for specific format
$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save('output.xlsx');

use PhpOffice\PhpSpreadsheet\IOFactory;

// Reader constants
IOFactory::READER_XLSX      // 'Xlsx'
IOFactory::READER_XLS       // 'Xls'
IOFactory::READER_ODS       // 'Ods'
IOFactory::READER_CSV       // 'Csv'
IOFactory::READER_HTML      // 'Html'
IOFactory::READER_XML       // 'Xml'
IOFactory::READER_GNUMERIC  // 'Gnumeric'
IOFactory::READER_SYLK      // 'Slk'

// Writer constants
IOFactory::WRITER_XLSX      // 'Xlsx'
IOFactory::WRITER_XLS       // 'Xls'
IOFactory::WRITER_ODS       // 'Ods'
IOFactory::WRITER_CSV       // 'Csv'
IOFactory::WRITER_HTML      // 'Html'

use PhpOffice\PhpSpreadsheet\IOFactory;

// Convert XLS to XLSX
$spreadsheet = IOFactory::load('old-file.xls');
$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
$writer->save('new-file.xlsx');

// Convert XLSX to CSV
$spreadsheet = IOFactory::load('data.xlsx');
$writer = IOFactory::createWriter($spreadsheet, 'Csv');
$writer->save('data.csv');

// Convert XLSX to PDF
$spreadsheet = IOFactory::load('report.xlsx');
IOFactory::registerWriter('Pdf', \PhpOffice\PhpSpreadsheet\Writer\Pdf\Mpdf::class);
$writer = IOFactory::createWriter($spreadsheet, 'Pdf');
$writer->save('report.pdf');

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\IOFactory;

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'Report Data');

// Export to multiple formats
$formats = ['Xlsx', 'Xls', 'Ods', 'Csv', 'Html'];

foreach ($formats as $format) {
    $writer = IOFactory::createWriter($spreadsheet, $format);
    $writer->save("output." . strtolower($format));
}

use PhpOffice\PhpSpreadsheet\IOFactory;

$inputDir = 'input/';
$outputDir = 'output/';

$files = glob($inputDir . '*.xls');

foreach ($files as $file) {
    $spreadsheet = IOFactory::load($file);
    $filename = basename($file, '.xls');
    
    $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
    $writer->save($outputDir . $filename . '.xlsx');
    
    $spreadsheet->disconnectWorksheets();
    unset($spreadsheet);
}