__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
<?php
namespace PhpOffice\PhpSpreadsheet\Worksheet;
use PhpOffice\PhpSpreadsheet\Cell\CellAddress;
use PhpOffice\PhpSpreadsheet\Cell\CellRange;
use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
class AutoFit
{
protected Worksheet $worksheet;
public function __construct(Worksheet $worksheet)
{
$this->worksheet = $worksheet;
}
public function getAutoFilterIndentRanges(): array
{
$autoFilterIndentRanges = [];
$autoFilterIndentRanges[] = $this->getAutoFilterIndentRange($this->worksheet->getAutoFilter());
foreach ($this->worksheet->getTableCollection() as $table) {
/** @var Table $table */
if ($table->getShowHeaderRow() === true && $table->getAllowFilter() === true) {
$autoFilter = $table->getAutoFilter();
if ($autoFilter !== null) {
$autoFilterIndentRanges[] = $this->getAutoFilterIndentRange($autoFilter);
}
}
}
return array_filter($autoFilterIndentRanges);
}
private function getAutoFilterIndentRange(AutoFilter $autoFilter): ?string
{
$autoFilterRange = $autoFilter->getRange();
$autoFilterIndentRange = null;
if (!empty($autoFilterRange)) {
$autoFilterRangeBoundaries = Coordinate::rangeBoundaries($autoFilterRange);
$autoFilterIndentRange = (string) new CellRange(
CellAddress::fromColumnAndRow($autoFilterRangeBoundaries[0][0], $autoFilterRangeBoundaries[0][1]),
CellAddress::fromColumnAndRow($autoFilterRangeBoundaries[1][0], $autoFilterRangeBoundaries[0][1])
);
}
return $autoFilterIndentRange;
}
}
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| AutoFilter | Folder | 0777 |
|
|
| Drawing | Folder | 0777 |
|
|
| Table | Folder | 0777 |
|
|
| AutoFilter.php | File | 40.68 KB | 0777 |
|
| AutoFit.php | File | 1.68 KB | 0777 |
|
| BaseDrawing.php | File | 11.32 KB | 0777 |
|
| CellIterator.php | File | 2.06 KB | 0777 |
|
| Column.php | File | 3.97 KB | 0777 |
|
| ColumnCellIterator.php | File | 5.41 KB | 0777 |
|
| ColumnDimension.php | File | 3.29 KB | 0777 |
|
| ColumnIterator.php | File | 4.38 KB | 0777 |
|
| Dimension.php | File | 2.24 KB | 0777 |
|
| Drawing.php | File | 5.42 KB | 0777 |
|
| HeaderFooter.php | File | 11.17 KB | 0777 |
|
| HeaderFooterDrawing.php | File | 446 B | 0777 |
|
| Iterator.php | File | 1.24 KB | 0777 |
|
| MemoryDrawing.php | File | 8.68 KB | 0777 |
|
| PageBreak.php | File | 1.34 KB | 0777 |
|
| PageMargins.php | File | 3.22 KB | 0777 |
|
| PageSetup.php | File | 26.65 KB | 0777 |
|
| Protection.php | File | 10.41 KB | 0777 |
|
| Row.php | File | 3.98 KB | 0777 |
|
| RowCellIterator.php | File | 5.83 KB | 0777 |
|
| RowDimension.php | File | 2.67 KB | 0777 |
|
| RowIterator.php | File | 3.53 KB | 0777 |
|
| SheetView.php | File | 3.94 KB | 0777 |
|
| Table.php | File | 16.89 KB | 0777 |
|
| Validations.php | File | 4.56 KB | 0777 |
|
| Worksheet.php | File | 115.96 KB | 0777 |
|