PHP code example of k1low / xlsx

1. Go to this page and download the library: Download k1low/xlsx library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php.

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

k1low / xlsx example snippets



use Xlsx\Xlsx;

$xlsx = new Xlsx();
$xlsx->read('/path/to/template.xlsx')
    ->setValue('testvalue', [
        'col' => 'B',
        'row' => '10',
    ])
    ->setValue('testvalue_with_sheet', [
        'col' => 'B',
        'row' => '10',
        'sheet' => 2,
    ])
    ->setValue('testvalue_with_border', [
        'col' => 'C',
        'row' => '10',
        'border' => [
            'top' => PHPExcel_Style_Border::BORDER_THICK,
            'right' => PHPExcel_Style_Border::BORDER_MEDIUM,
            'left' => PHPExcel_Style_Border::BORDER_THIN,
            'bottom' => PHPExcel_Style_Border::BORDER_DOUBLE,
        ],
    ])
    ->setValue('testvalue_with_border', [
        'col' => 'E',
        'row' => '10',
        'border' => PHPExcel_Style_Border::BORDER_THICK,
    ])
    ->setValue('testvalue_with_color', [
        'col' => 'F',
        'row' => '10',
        'color' => PHPExcel_Style_Color::COLOR_BLUE,
    ])
    ->setValue('testvalue_with_backgroud_color', [
        'col' => 'G',
        'row' => '10',
        'backgroundColor' => PHPExcel_Style_Color::COLOR_YELLOW,
    ])
    ->write('/path/to/output.xlsx');