!C99Shell v. 2.5 [PHP 8 Update] [24.05.2025]!

Software: Apache/2.4.41 (Ubuntu). PHP/8.0.30 

uname -a: Linux apirnd 5.4.0-204-generic #224-Ubuntu SMP Thu Dec 5 13:38:28 UTC 2024 x86_64 

uid=33(www-data) gid=33(www-data) groups=33(www-data) 

Safe-mode: OFF (not secure)

/uploads/script/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Xlsx/   drwxr-xr-x
Free 13.32 GB of 57.97 GB (22.98%)
Home    Back    Forward    UPDIR    Refresh    Search    Buffer    Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Self remove    Logout    


Viewing file:     DataValidations.php (2.26 KB)      -rw-r--r--
Select action/file-type:
(+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php

namespace PhpOffice\PhpSpreadsheet\Reader\Xlsx;

use 
PhpOffice\PhpSpreadsheet\Cell\Coordinate;
use 
PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
use 
SimpleXMLElement;

class 
DataValidations
{
    private 
$worksheet;

    private 
$worksheetXml;

    public function 
__construct(Worksheet $workSheetSimpleXMLElement $worksheetXml)
    {
        
$this->worksheet $workSheet;
        
$this->worksheetXml $worksheetXml;
    }

    public function 
load(): void
    
{
        foreach (
$this->worksheetXml->dataValidations->dataValidation as $dataValidation) {
            
// Uppercase coordinate
            
$range strtoupper($dataValidation['sqref']);
            
$rangeSet explode(' '$range);
            foreach (
$rangeSet as $range) {
                
$stRange $this->worksheet->shrinkRangeToFit($range);

                
// Extract all cell references in $range
                
foreach (Coordinate::extractAllCellReferencesInRange($stRange) as $reference) {
                    
// Create validation
                    
$docValidation $this->worksheet->getCell($reference)->getDataValidation();
                    
$docValidation->setType((string) $dataValidation['type']);
                    
$docValidation->setErrorStyle((string) $dataValidation['errorStyle']);
                    
$docValidation->setOperator((string) $dataValidation['operator']);
                    
$docValidation->setAllowBlank($dataValidation['allowBlank'] != 0);
                    
$docValidation->setShowDropDown($dataValidation['showDropDown'] == 0);
                    
$docValidation->setShowInputMessage($dataValidation['showInputMessage'] != 0);
                    
$docValidation->setShowErrorMessage($dataValidation['showErrorMessage'] != 0);
                    
$docValidation->setErrorTitle((string) $dataValidation['errorTitle']);
                    
$docValidation->setError((string) $dataValidation['error']);
                    
$docValidation->setPromptTitle((string) $dataValidation['promptTitle']);
                    
$docValidation->setPrompt((string) $dataValidation['prompt']);
                    
$docValidation->setFormula1((string) $dataValidation->formula1);
                    
$docValidation->setFormula2((string) $dataValidation->formula2);
                }
            }
        }
    }
}

:: Command execute ::

Enter:
 
Select:
 

:: Search ::
  - regexp 

:: Upload ::
 
[ Read-Only ]

:: Make Dir ::
 
[ Read-Only ]
:: Make File ::
 
[ Read-Only ]

:: Go Dir ::
 
:: Go File ::
 

--[ c99shell v. 2.5 [PHP 8 Update] [24.05.2025] | Generation time: 0.0047 ]--