Search
 
SCRIPT & CODE EXAMPLE
 

PHP

phpspreadsheet CellProtection

$spreadsheet->getActiveSheet()->getProtection()->setSheet(true);
$spreadsheet->getActiveSheet()
    ->getStyle('A2:B2')
    ->getProtection()->setLocked(
        Protection::PROTECTION_UNPROTECTED
    );
Comment

phpspreadsheet

<?php

require 'vendor/autoload.php';

use PhpOfficePhpSpreadsheetSpreadsheet;
use PhpOfficePhpSpreadsheetWriterXlsx;

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'Hello World !');

$writer = new Xlsx($spreadsheet);
$writer->save('hello world.xlsx');
Comment

PREVIOUS NEXT
Code Example
Php :: yesterday php 
Php :: php if elseif 
Php :: in_array validation laravel 
Php :: how to check where function defined in php 
Php :: php check if string ends with 
Php :: root composer.json requires php ^7.3 but your php version (8.0.3) does not satisfy that requirement. 
Php :: php remove non utf-8 characters 
Php :: curl post laravel 
Php :: jQuery is not defined load-scripts.php 
Php :: laravel fetch max value 
Php :: throwable php 
Php :: php ++ 
Php :: php .= 
Php :: how naming resource routes laravel 
Php :: check if array is empty php 
Php :: php http errorcode 
Php :: mail sending setting magneto for mailhog 
Php :: rename migration laravel 
Php :: laravel carbon time format 
Php :: Change WordPress Login Logo Url 
Php :: distinct laravel not working 
Php :: php send json post 
Php :: category title in post 
Php :: convert datetime to string in php 
Php :: laravel move file from local to s3 
Php :: create array php 
Php :: php strlen 
Php :: laravel eloquent update 
Php :: Uncaught ReferenceError: commonL10n is not defined 
Php :: cut the first character in php 
ADD CONTENT
Topic
Content
Source link
Name
1+7 =