__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ 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\Exception as PhpSpreadsheetException;
class SheetView
{
// Sheet View types
const SHEETVIEW_NORMAL = 'normal';
const SHEETVIEW_PAGE_LAYOUT = 'pageLayout';
const SHEETVIEW_PAGE_BREAK_PREVIEW = 'pageBreakPreview';
private const SHEET_VIEW_TYPES = [
self::SHEETVIEW_NORMAL,
self::SHEETVIEW_PAGE_LAYOUT,
self::SHEETVIEW_PAGE_BREAK_PREVIEW,
];
/**
* ZoomScale.
*
* Valid values range from 10 to 400.
*
* @var ?int
*/
private $zoomScale = 100;
/**
* ZoomScaleNormal.
*
* Valid values range from 10 to 400.
*
* @var ?int
*/
private $zoomScaleNormal = 100;
/**
* ShowZeros.
*
* If true, "null" values from a calculation will be shown as "0". This is the default Excel behaviour and can be changed
* with the advanced worksheet option "Show a zero in cells that have zero value"
*
* @var bool
*/
private $showZeros = true;
/**
* View.
*
* Valid values range from 10 to 400.
*
* @var string
*/
private $sheetviewType = self::SHEETVIEW_NORMAL;
/**
* Create a new SheetView.
*/
public function __construct()
{
}
/**
* Get ZoomScale.
*
* @return ?int
*/
public function getZoomScale()
{
return $this->zoomScale;
}
/**
* Set ZoomScale.
* Valid values range from 10 to 400.
*
* @param ?int $zoomScale
*
* @return $this
*/
public function setZoomScale($zoomScale)
{
// Microsoft Office Excel 2007 only allows setting a scale between 10 and 400 via the user interface,
// but it is apparently still able to handle any scale >= 1
if ($zoomScale === null || $zoomScale >= 1) {
$this->zoomScale = $zoomScale;
} else {
throw new PhpSpreadsheetException('Scale must be greater than or equal to 1.');
}
return $this;
}
/**
* Get ZoomScaleNormal.
*
* @return ?int
*/
public function getZoomScaleNormal()
{
return $this->zoomScaleNormal;
}
/**
* Set ZoomScale.
* Valid values range from 10 to 400.
*
* @param ?int $zoomScaleNormal
*
* @return $this
*/
public function setZoomScaleNormal($zoomScaleNormal)
{
if ($zoomScaleNormal === null || $zoomScaleNormal >= 1) {
$this->zoomScaleNormal = $zoomScaleNormal;
} else {
throw new PhpSpreadsheetException('Scale must be greater than or equal to 1.');
}
return $this;
}
/**
* Set ShowZeroes setting.
*
* @param bool $showZeros
*/
public function setShowZeros($showZeros): void
{
$this->showZeros = $showZeros;
}
/**
* @return bool
*/
public function getShowZeros()
{
return $this->showZeros;
}
/**
* Get View.
*
* @return string
*/
public function getView()
{
return $this->sheetviewType;
}
/**
* Set View.
*
* Valid values are
* 'normal' self::SHEETVIEW_NORMAL
* 'pageLayout' self::SHEETVIEW_PAGE_LAYOUT
* 'pageBreakPreview' self::SHEETVIEW_PAGE_BREAK_PREVIEW
*
* @param ?string $sheetViewType
*
* @return $this
*/
public function setView($sheetViewType)
{
// MS Excel 2007 allows setting the view to 'normal', 'pageLayout' or 'pageBreakPreview' via the user interface
if ($sheetViewType === null) {
$sheetViewType = self::SHEETVIEW_NORMAL;
}
if (in_array($sheetViewType, self::SHEET_VIEW_TYPES)) {
$this->sheetviewType = $sheetViewType;
} else {
throw new PhpSpreadsheetException('Invalid sheetview layout type.');
}
return $this;
}
}
| 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 |
|