Aspose.Cells-Cloud-SDK-PHP

Aspose.Cells-Cloud-SDK-PHP

Aspose.Cells-Cloud-SDK-PHP

Examples-PHP-AutoFilter-DeleteWorksheetDateFilter-.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new CellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $fieldIndex = 0;  
        $dateTimeGroupingType ="Day";
        $year = 2010;
        $month = 10;
        $day = 10;
        $hour = 10;
        $minute = 10;
        $second = 10;
        $folder = "PHPTest";
        $sourceFolder = ".\\data\\";
         $this->cells->uploadFile($folder . "/" .  $name , $sourceFolder. $name);
        $result = $this->cells->cellsAutoFilterDeleteWorksheetDateFilter($name, $sheet_name,$fieldIndex, $dateTimeGroupingType,$year,$month,$day,$hour,$minute,$second,$folder);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-AutoFilter-DeleteWorksheetFilter-.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new CellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $fieldIndex = 0;  
        $criteria ="Day";     
        $folder = "PHPTest";
        $sourceFolder = ".\\data\\";
        $this->cells->uploadFile($folder . "/" .  $name , $sourceFolder. $name);
        $result = $this->cells->cellsAutoFilterDeleteWorksheetFilter($name, $sheet_name,$fieldIndex, $criteria,$folder);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-AutoFilter-GetWorksheetAutoFilter-.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new CellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $fieldIndex = 0;  
         
        $folder = "PHPTest";
        $sourceFolder = ".\\data\\";
        $this->cells->uploadFile($folder . "/" .  $name , $sourceFolder. $name);
        $result = $this->cells->cellsAutoFilterGetWorksheetAutoFilter($name, $sheet_name,$folder);
        print($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-AutoFilter-PostWorksheetAutoFilterRefresh-.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new CellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        
        $folder = "PHPTest";
        $sourceFolder = ".\\data\\";
        $this->cells->uploadFile($folder . "/" .  $name , $sourceFolder. $name);
        $result = $this->cells->cellsAutoFilterPostWorksheetAutoFilterRefresh($name, $sheet_name,$folder);
        print($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-AutoFilter-PostWorksheetMatchBlanks-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class FilterData {

	public $instance;

	public function __construct() {
	    $this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postWorksheetMatchBlanks() {
      // Upload file to Aspose Cloud Storage
      $name = "Book1.xlsx";
      Utils::uploadFile($name);

      $sheet_name = "Sheet1";
      $field_index=0;

      $result = $this->cells->cellsAutoFilterPostWorksheetMatchBlanks($name, $sheet_name, $field_index, $folder=null);
      print_r($result);
	}
}

$instance = new FilterData();
$instance->postWorksheetMatchBlanks();

?>

Examples-PHP-AutoFilter-PostWorksheetMatchNonBlanks-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class FilterData {

	public $instance;

	public function __construct() {
	    $this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postWorksheetMatchNonBlanks() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $fieldIndex = 0;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsAutoFilterPostWorksheetMatchNonBlanks($name, $sheet_name,$fieldIndex, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new FilterData();
$instance->postWorksheetMatchNonBlanks();

?>

Examples-PHP-AutoFilter-PutWorksheetColorFilter-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class FilterData {

	public $instance;

	public function __construct() {
	    $this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putWorksheetColorFilter() {
    $name ='Book1.xlsx';
    $sheet_name ='Sheet1';
    $range ='A1:C10';
    $fieldIndex = 0;  
    $colorFilter = new ColorFilterRequest();
    $color = new Color();
    $color->setR(255);
    $color->setA(255);
    $color->setB(255);
    $color->setG(0);
    $cellColor = new CellsColor();
    $themeColor = new ThemeColor();
    $themeColor->setColorType("Text2");
    $themeColor->setTint(1.0);
    $cellColor->setType("Automatic");
    $cellColor->setColor($color );
    $cellColor->setThemeColor($themeColor );
    $colorFilter->setForegroundColor($cellColor);

    $color1 = new Color();
    $color1->setR(255);
    $color1->setA(255);
    $color1->setB(255);
    $color1->setG(0);
    $cellColor1 = new CellsColor();
    $themeColor1 = new ThemeColor();
    $themeColor1->setColorType("Text2");
    $themeColor1->setTint(1.0);
    $cellColor1->setType("Automatic");
    $cellColor1->setColor($color1 );
    $cellColor1->setThemeColor($themeColor1 );
    $colorFilter->setBackgroundColor($cellColor1);

    $colorFilter->setPattern('Solid' );
    $matchBlanks ='true';
    $refresh ='true';
    $folder = "Temp";
    CellsApiTestBase::ready(  $this->instance,$name ,$folder);
    $result = $this->instance->cellsAutoFilterPutWorksheetColorFilter($name, $sheet_name,$range ,$fieldIndex, $colorFilter , $matchBlanks, $refresh, $folder);
    $this->assertEquals(200, $result['code']);
	}
}

$instance = new FilterData();
$instance->putWorksheetColorFilter();

?>

Examples-PHP-AutoFilter-PutWorksheetCustomFilter-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class FilterData {

	public $instance;

	public function __construct() {
	    $this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putWorksheetCustomFilter() {
        $name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $range ='A1:C10';
        $fieldIndex = 0;  
        $operatorType1 ="LessOrEqual";
        $criteria1 ="test";
        $isAnd = 'true';
        $operatorType2 =  "LessOrEqual";
        $criteria2 =  "test";
        $matchBlanks ='true';
        $refresh ='true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsAutoFilterPutWorksheetCustomFilter($name, $sheet_name,$range ,$fieldIndex, $operatorType1 , $criteria1,$isAnd, $operatorType2 , $criteria2,$matchBlanks, $refresh, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new FilterData();
$instance->putWorksheetCustomFilter();

?>

Examples-PHP-AutoFilter-PutWorksheetDateFilter-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class FilterData {

	public $instance;

	public function __construct() {
            $this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putWorksheetDateFilter() {
	    $name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $range ='A1:C10';
        $fieldIndex = 0;  
        $dateTimeGroupingType ="Day";
        $year = 2010;
        $month = 10;
        $day = 10;
        $hour = 10;
        $minute = 10;
        $second = 10;
        $matchBlanks ='true';
        $refresh ='true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsAutoFilterPutWorksheetDateFilter($name, $sheet_name, $range,$fieldIndex, $dateTimeGroupingType,$year,$month,$day,$hour,$minute,$second,$matchBlanks, $refresh,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new FilterData();
$instance->putWorksheetDateFilter();

?>

Examples-PHP-AutoFilter-PutWorksheetDynamicFilter-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class FilterData {

	public $instance;

	public function __construct() {
	    $this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putWorksheetDynamicFilter() {
        $name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $range ='A1:C10';
        $fieldIndex = 0;  
        $dynamicFilterType ="May";        
        $matchBlanks ='true';
        $refresh ='true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsAutoFilterPutWorksheetDynamicFilter($name, $sheet_name, $range,$fieldIndex, $dynamicFilterType,$matchBlanks, $refresh,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new FilterData();
$instance->putWorksheetDynamicFilter();

?>

Examples-PHP-AutoFilter-PutWorksheetFilter-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class FilterData {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putWorksheetFilter() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $range ='A1:C10';
        $fieldIndex = 0;  
        $criteria ="May";        
        $matchBlanks ='true';
        $refresh ='true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsAutoFilterPutWorksheetFilter($name, $sheet_name, $range,$fieldIndex, $criteria,$matchBlanks, $refresh,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new FilterData();
$instance->putWorksheetFilter();

?>

Examples-PHP-AutoFilter-PutWorksheetFilterTop10-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class FilterData {

	public $instance;

	public function __construct() {
	    $this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putWorksheetFilterTop10() {
        $name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $range ='A1:C10';
        $fieldIndex = 0;  
        $isTop ='true';
        $isPercent ='true';
        $itemCount =1;        
        $matchBlanks ='true';
        $refresh ='true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsAutoFilterPutWorksheetFilterTop10($name, $sheet_name, $range,$fieldIndex, $isTop,$isPercent, $itemCount, $matchBlanks, $refresh,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new FilterData();
$instance->putWorksheetFilterTop10();

?>

Examples-PHP-AutoFilter-PutWorksheetIconFilter-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class FilterData {

	public $instance;

	public function __construct() {
	    $this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putWorksheetIconFilter() {
        $name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $range ='A1:C10';
        $fieldIndex = 0;  
        $iconSetType ='None';
        $iconId =1;        
        $matchBlanks ='true';
        $refresh ='true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsAutoFilterPutWorksheetIconFilter($name, $sheet_name, $range,$fieldIndex, $iconSetType,$iconId, $matchBlanks, $refresh,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new FilterData();
$instance->putWorksheetIconFilter();

?>

Examples-PHP-Cells-GetWorksheetCell-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetCell() {
        $name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cell_or_method_name = 'C1';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsGetWorksheetCell($name, $sheet_name, $cell_or_method_name, $folder);
        $this->assertEquals(200, $result['Code']);
	}
}

$instance = new Cell();
$instance->getWorksheetCell();

?>

Examples-PHP-Cells-GetWorksheetCells-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetCells() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $offest = 2;  
        $count =10;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =  $this->instance->cellsGetWorksheetCells($name, $sheet_name, $offest, $count,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Cell();
$instance->getWorksheetCells();

?>

Examples-PHP-Cells-GetWorksheetCellStyle-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetCellStyle() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cellName = 'C1';  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =  $this->instance->cellsGetWorksheetCellStyle($name, $sheet_name, $cellName, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Cell();
$instance->getWorksheetCellStyle();

?>

Examples-PHP-Cells-GetWorksheetFirstCell.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetCell() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cell_or_method_name = 'firstcell';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsGetWorksheetCell($name, $sheet_name, $cell_or_method_name, $folder);
        $this->assertEquals(200, $result['Code']);
	}
}

$instance = new Cell();
$instance->getWorksheetCell();

?>

Examples-PHP-Cells-GetWorksheetLastCell.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetCell() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cell_or_method_name = 'lastcell';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsGetWorksheetCell($name, $sheet_name, $cell_or_method_name, $folder);
        $this->assertEquals(200, $result['Code']);
	}
}

$instance = new Cell();
$instance->getWorksheetCell();

?>

Examples-PHP-Cells-GetWorksheetMaxColumn.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetCell() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cell_or_method_name = 'maxcolumn';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsGetWorksheetCell($name, $sheet_name, $cell_or_method_name, $folder);
        $this->assertEquals(200, $result['Code']);
	}
}

$instance = new Cell();
$instance->getWorksheetCell();

?>

Examples-PHP-Cells-GetWorksheetMaxDataColumn.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetCell() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cell_or_method_name = 'maxdatacolumn';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsGetWorksheetCell($name, $sheet_name, $cell_or_method_name, $folder);
        $this->assertEquals(200, $result['Code']);
	}
}

$instance = new Cell();
$instance->getWorksheetCell();

?>

Examples-PHP-Cells-GetWorksheetMaxDataRow.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetCell() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cell_or_method_name = 'maxdatarow';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsGetWorksheetCell($name, $sheet_name, $cell_or_method_name, $folder);
        $this->assertEquals(200, $result['Code']);
	}
}

$instance = new Cell();
$instance->getWorksheetCell();

?>

Examples-PHP-Cells-GetWorksheetMaxRow.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetCell() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cell_or_method_name = 'maxrow';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsGetWorksheetCell($name, $sheet_name, $cell_or_method_name, $folder);
        $this->assertEquals(200, $result['Code']);
	}
}

$instance = new Cell();
$instance->getWorksheetCell();

?>

Examples-PHP-Cells-GetWorkSheetMergedCell-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorkSheetMergedCell() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1'; 
        $mergedCellIndex =1;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsGetWorkSheetMergedCell($name, $sheet_name,$mergedCellIndex, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Cell();
$instance->getWorkSheetMergedCell();

?>

Examples-PHP-Cells-GetWorkSheetMergedCells-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorkSheetMergedCells() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1'; 
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsGetWorkSheetMergedCells($name, $sheet_name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Cell();
$instance->getWorkSheetMergedCells();

?>

Examples-PHP-Cells-GetWorksheetMinColumn.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetCell() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cell_or_method_name = 'mincolumn';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsGetWorksheetCell($name, $sheet_name, $cell_or_method_name, $folder);
        $this->assertEquals(200, $result['Code']);
	}
}

$instance = new Cell();
$instance->getWorksheetCell();

?>

Examples-PHP-Cells-GetWorksheetMinDataColumn.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetCell() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cell_or_method_name = 'firstcell';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsGetWorksheetCell($name, $sheet_name, $cell_or_method_name, $folder);
        $this->assertEquals(200, $result['Code']);
	}
}

$instance = new Cell();
$instance->getWorksheetCell();

?>

Examples-PHP-Cells-GetWorksheetMinDataRow.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetCell() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cell_or_method_name = 'mindatarow';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsGetWorksheetCell($name, $sheet_name, $cell_or_method_name, $folder);
        $this->assertEquals(200, $result['Code']);
	}
}

$instance = new Cell();
$instance->getWorksheetCell();

?>

Examples-PHP-Cells-GetWorksheetMinRow.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetCell() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cell_or_method_name = 'minrow';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsGetWorksheetCell($name, $sheet_name, $cell_or_method_name, $folder);
        $this->assertEquals(200, $result['Code']);
	}
}

$instance = new Cell();
$instance->getWorksheetCell();

?>

Examples-PHP-Cells-PostCalulateCellFormula-.php

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
<?php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postCalulateCellFormula() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cellName = 'C1'; 
        $value = '2018/10/09';
        $type ='DateTime';
        $formula = '=Now()';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPostWorksheetCellSetValue($name, $sheet_name, $cellName, $value,$type ,$formula ,  $folder);
        $value = '1';
        $type ='int';
        $folder = "Temp";
        $result = $this->instance->cellsPostWorksheetCellSetValue($name, $sheet_name, $cellName, $value,$type ,null ,  $folder);
        $value = '1';
        $type ='String';
        $folder = "Temp";
        $result = $this->instance->cellsPostWorksheetCellSetValue($name, $sheet_name, $cellName, $value,$type ,null ,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Cell();
$instance->postCalulateCellFormula();

?>

Examples-PHP-Cells-PostCellTextFormatting-.php

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
<?php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postCellTextFormatting() {
		$name ='Book1.xlsx';
    $sheet_name ='Sheet2';
    $cellName = 'G8';  
    $fs1 = new FontSetting();
    $font = new Font();
    $font->setSize(10.0);
    $fs1->setFont($font);
    $fs1->setStartIndex(0);
    $fs1->setLength(2);
    $options = [$fs1];
    $folder = "Temp";
    CellsApiTestBase::ready(  $this->instance,$name ,$folder);
    $result = $this->instance->cellsPostCellCharacters($name, $sheet_name, $cellName, $options, $folder);
    $this->assertEquals(200, $result['code']);
	}
}

$instance = new Cell();
$instance->postCellTextFormatting();

?>

Examples-PHP-Cells-PostClearContents-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postClearContents() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $range = 'A1:C10';  
        $startRow = 1;
        $startColumn =1;
        $endRow = 3;
        $endColumn = 3;;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =  $this->instance->cellsPostClearContents($name, $sheet_name, $range, $startRow,$startColumn,$endRow,$endColumn,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Cell();
$instance->postClearContents();

?>

Examples-PHP-Cells-PostClearFormats-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postClearFormats() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $range = 'A1:C10';  
        $startRow = 1;
        $startColumn =1;
        $endRow = 3;
        $endColumn = 3;;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =   $this->instance->cellsPostClearFormats($name, $sheet_name, $range, $startRow,$startColumn,$endRow,$endColumn,$folder);   
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Cell();
$instance->postClearFormats();

?>

Examples-PHP-Cells-PostCopyCellIntoCell-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postCopyCellIntoCell() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $destCellName = 'C1';  
        $worksheet = 'Sheet2';
        $cellName ='B1'; 
        $row =1;
        $column =2;       
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =   $this->instance->cellsPostCopyCellIntoCell($name, $cellName,$sheet_name, $worksheet, $cellName,$row,$column,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Cell();
$instance->postCopyCellIntoCell();

?>

Examples-PHP-Cells-PostSetCellHtmlString-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postSetCellHtmlString() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cellName = 'C1'; 
        $folder = "Temp";
        $html_string = "https://api.aspose.cloud/v3.0/cells";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =  $this->instance->cellsPostSetCellHtmlString($name, $sheet_name, $cellName,$html_string,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Cell();
$instance->postSetCellHtmlString();

?>

Examples-PHP-Cells-PostSetCellRangeValue-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postSetCellRangeValue() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cellarea = 'A1:C10'; 
        $value = '12345'; 
        $type = 'String'; 
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =  $this->instance->cellsPostSetCellRangeValue($name, $sheet_name, $cellarea, $value, $type, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Cell();
$instance->postSetCellRangeValue();

?>

Examples-PHP-Cells-PostUpdateWorksheetCellStyle-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postUpdateWorksheetCellStyle() {
        $name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cellName = 'C1'; 
        $style = new Style();
        $font = new Font();
        $font->setIsBold('true');
        $font->setSize(10);
        $style->setFont($font);
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPostUpdateWorksheetCellStyle($name, $sheet_name, $cellName, $style,  $folder);
        $this->assertEquals(200, $result['code']);
    }
}

$instance = new Cell();
$instance->postUpdateWorksheetCellStyle();

?>

Examples-PHP-Cells-PostWorksheetCellSetValue-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postWorksheetCellSetValue() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $cellName = 'C1'; 
        $value = '2018/10/09';
        $type ='DateTime';
        $formula = '=Now()';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPostWorksheetCellSetValue($name, $sheet_name, $cellName, $value,$type ,$formula ,  $folder);
        $value = '1';
        $type ='int';
        $folder = "Temp";
        $result = $this->instance->cellsPostWorksheetCellSetValue($name, $sheet_name, $cellName, $value,$type ,null ,  $folder);
        $value = '1';
        $type ='String';
        $folder = "Temp";
        $result = $this->instance->cellsPostWorksheetCellSetValue($name, $sheet_name, $cellName, $value,$type ,null ,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Cell();
$instance->postWorksheetCellSetValue();

?>

Examples-PHP-Cells-PostWorksheetMerge-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postWorksheetMerge() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $startRow = 1; 
        $startColumn = 1;
        $totalRows =10;
        $totalColumns = 2;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPostWorksheetMerge($name, $sheet_name, $startRow, $startColumn,$totalRows ,$totalColumns ,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Cell();
$instance->postWorksheetMerge();

?>

Examples-PHP-Cells-PostWorksheetUnmerge-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postWorksheetUnmerge() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $startRow = 1; 
        $startColumn = 1;
        $totalRows =10;
        $totalColumns = 2;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =$this->instance->cellsPostWorksheetUnmerge($name, $sheet_name, $startRow, $startColumn,$totalRows ,$totalColumns ,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Cell();
$instance->postWorksheetUnmerge();

?>

Examples-PHP-Charts-CellsChartsPostWorksheetChart-.php

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
<?php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function cellsChartsPostWorksheetChart() {
    $name ='myDocument.xlsx';
    $sheet_name ='Sheet3';
    $chartIndex = 0;  
    $chart = new Chart();
    $chart->setAutoScaling('true');
    $folder = "Temp";
    CellsApiTestBase::ready(  $this->instance,$name ,$folder);
    $result = $this->instance->cellsChartsPostWorksheetChart($name, $sheet_name, $chartIndex , $chart , $folder);
    $this->assertEquals(200, $result['code']);
	}
}

$instance = new Chart();
$instance->cellsChartsPostWorksheetChart();

?>

Examples-PHP-Charts-DeleteWorksheetChartLegend-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteWorksheetChartLegend() {
    	$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartIndex = 1;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartsDeleteWorksheetChartLegend($name, $sheet_name,$chartIndex, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Chart();
$instance->deleteWorksheetChartLegend();

?>

Examples-PHP-Charts-DeleteWorksheetChartTitle-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteWorksheetChartTitle() {
		$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartIndex = 1;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartsDeleteWorksheetChartTitle($name, $sheet_name,$chartIndex, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Chart();
$instance->deleteWorksheetChartTitle();

?>

Examples-PHP-Charts-DeleteWorksheetClearCharts-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteWorksheetClearCharts() {
		$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartIndex = 1;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartsDeleteWorksheetClearCharts($name, $sheet_name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Chart();
$instance->deleteWorksheetClearCharts();

?>

Examples-PHP-Charts-DeleteWorksheetDeleteChart-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteWorksheetDeleteChart() {
    	$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartIndex = 0;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartsDeleteWorksheetDeleteChart($name, $sheet_name,$chartIndex, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Chart();
$instance->deleteWorksheetDeleteChart();

?>

Examples-PHP-Charts-GetChartArea-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getChartArea() {
    	$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartIndex = 0;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartAreaGetChartArea($name, $sheet_name,$chartIndex, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Chart();
$instance->getChartArea();

?>

Examples-PHP-Charts-GetChartAreaBorder-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getChartAreaBorder() {
		$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartIndex = 0;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartAreaGetChartAreaBorder($name, $sheet_name,$chartIndex, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Chart();
$instance->getChartAreaBorder();

?>

Examples-PHP-Charts-GetChartAreaFillFormat-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getChartAreaFillFormat() {
    	$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartIndex = 0;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartAreaGetChartAreaFillFormat($name, $sheet_name,$chartIndex, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Chart();
$instance->getChartAreaFillFormat();

?>

Examples-PHP-Charts-GetWorksheetChart-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetChart() {
    	$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartIndex = 0;  
        $format = "png";
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartsGetWorksheetChart($name, $sheet_name,$chartIndex, $format, $folder);
        $this->assertTrue($result->getSize() > 0, "");
	}
}

$instance = new Chart();
$instance->getWorksheetChart();

?>

Examples-PHP-Charts-GetWorksheetChartLegend-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetChartLegend() {
    	$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartIndex = 0;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartsGetWorksheetChartLegend($name, $sheet_name,$chartIndex, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Chart();
$instance->getWorksheetChartLegend();

?>

Examples-PHP-Charts-GetWorksheetCharts-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetCharts() {
    	$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartIndex = 0;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartsGetWorksheetCharts($name, $sheet_name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Chart();
$instance->getWorksheetCharts();

?>

Examples-PHP-Charts-GetWorksheetChartWithFormat-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetChartWithFormat() {
    	$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartIndex = 0;  
        $format = "png";
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartsGetWorksheetChart($name, $sheet_name,$chartIndex, $format, $folder);
        $this->assertTrue($result->getSize() > 0, "");
	}
}

$instance = new Chart();
$instance->getWorksheetChartWithFormat();

?>

Examples-PHP-Charts-PostWorksheetChartLegend-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postWorksheetChartLegend() {
    	$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartIndex = 0;  
        $legend = new Legend();
        $legend->setWidth(10);
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartsPostWorksheetChartLegend($name, $sheet_name, $chartIndex , $legend , $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Chart();
$instance->postWorksheetChartLegend();

?>

Examples-PHP-Charts-PostWorksheetChartTitle-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postWorksheetChartTitle() {
		$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartIndex = 0;  
        $legend = new Legend();
        $legend->setWidth(10);
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartsPostWorksheetChartLegend($name, $sheet_name, $chartIndex , $legend , $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Chart();
$instance->postWorksheetChartTitle();

?>

Examples-PHP-Charts-PutWorksheetAddChart-.php

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
<?php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putWorksheetAddChart() {
    	$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartType = 'Pie';  
        $upperLeftRow = 5;  
        $upperLeftColumn = 5; 
        $lowerRightRow = 10; 
        $lowerRightColumn = 10; 
        $area =  "C7:D11"; 
        $isVertical = 'true';  
        $categoryData = null;  
        $isAutoGetSerialName = null;  
        $title = null;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartsPutWorksheetAddChart($name, $sheet_name, $chartType , $upperLeftRow , $upperLeftColumn, $lowerRightRow, $lowerRightColumn,         $area, $isVertical, $categoryData,$isAutoGetSerialName,$title, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Chart();
$instance->putWorksheetAddChart();

?>

Examples-PHP-Charts-PutWorksheetChartLegend-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putWorksheetChartLegend() {
    	$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartIndex = 0;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartsPutWorksheetChartLegend($name, $sheet_name, $chartIndex , $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Chart();
$instance->putWorksheetChartLegend();

?>

Examples-PHP-Charts-PutWorksheetChartTitle-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Chart {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putWorksheetChartTitle() {
    	$name ='myDocument.xlsx';
        $sheet_name ='Sheet3';
        $chartIndex = 0;  
        $title = new Title();
        $title->setText(10);
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsChartsPutWorksheetChartTitle($name, $sheet_name, $chartIndex ,$title, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new Chart();
$instance->putWorksheetChartTitle();

?>

Examples-PHP-Document Properties-DeleteDocumentProperties-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class DocumentProperty {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteDocumentProperties() {
    	$name ='Book1.xlsx';      
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPropertiesDeleteDocumentProperties($name,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$instance = new DocumentProperty();
$instance->deleteDocumentProperties();

?>

Examples-PHP-Document Properties-DeleteDocumentProperty-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class DocumentProperty {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteDocumentProperty() {
    	$name ='Book1.xlsx'; 
        $propertyName = "Author";    
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPropertiesDeleteDocumentProperty($name, $propertyName ,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$documentProperty = new DocumentProperty();
$documentProperty->deleteDocumentProperty();

?>

Examples-PHP-Document Properties-GetDocumentProperties-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class DocumentProperty {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getDocumentProperties() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPropertiesGetDocumentProperties($name,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$documentProperty = new DocumentProperty();
$documentProperty->getDocumentProperties();

?>

Examples-PHP-Document Properties-GetDocumentProperty-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class DocumentProperty {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getDocumentProperty() {
    	$name ='Book1.xlsx';
        $propertyName = "Author";       
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPropertiesGetDocumentProperty($name,$propertyName,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$documentProperty = new DocumentProperty();
$documentProperty->getDocumentProperty();

?>

Examples-PHP-Document Properties-PutDocumentProperty-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class DocumentProperty {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putDocumentProperty() {
    	$name ='Book1.xlsx';
        $propertyName = "Name";
        $property = new CellsDocumentProperty();  
        $property->setName("Author");
        $property->setValue("Val") ;   
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPropertiesPutDocumentProperty($name,$propertyName ,$property,$folder);
        $this->assertEquals(201, $result['code']);
	}
}

$documentProperty = new DocumentProperty();
$documentProperty->putDocumentProperty();

?>

Examples-PHP-Hyperlinks-DeleteWorkSheetHyperlink-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Hyperlink {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteWorkSheetHyperlink() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $hyperlinkIndex = 0;         
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsHypelinksDeleteWorkSheetHyperlink($name, $sheet_name,$hyperlinkIndex,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$hyperlink = new Hyperlink();
$hyperlink->deleteWorkSheetHyperlink();

?>

Examples-PHP-Hyperlinks-DeleteWorkSheetHyperlinks-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Hyperlink {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteWorkSheetHyperlinks() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $hyperlinkIndex = 0;         
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsHypelinksDeleteWorkSheetHyperlinks($name, $sheet_name,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$hyperlink = new Hyperlink();
$hyperlink->deleteWorkSheetHyperlinks();

?>

Examples-PHP-Hyperlinks-GetWorkSheetHyperlink-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Hyperlink {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorkSheetHyperlink() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $hyperlinkIndex = 0;         
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsHypelinksGetWorkSheetHyperlink($name, $sheet_name,$hyperlinkIndex,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$hyperlink = new Hyperlink();
$hyperlink->getWorkSheetHyperlink();

?>

Examples-PHP-Hyperlinks-GetWorkSheetHyperlinks-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Hyperlink {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorkSheetHyperlinks() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $hyperlinkIndex = 0;         
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsHypelinksGetWorkSheetHyperlinks($name, $sheet_name,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$hyperlink = new Hyperlink();
$hyperlink->getWorkSheetHyperlinks();

?>

Examples-PHP-Hyperlinks-PostWorkSheetHyperlink-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Hyperlink {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postWorkSheetHyperlink() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $hyperlinkIndex = 0;         
        $folder = "Temp";
        $hyperlink = new Hyperlink();
        $hyperlink->setAddress('http://wwww.aspose.com');
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsHypelinksPostWorkSheetHyperlink($name, $sheet_name, $hyperlinkIndex ,  $hyperlink , $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$hyperlink = new Hyperlink();
$hyperlink->postWorkSheetHyperlink();

?>

Examples-PHP-Hyperlinks-PutWorkSheetHyperlink-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Hyperlink {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putWorkSheetHyperlink() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $firstRow = 1;      
        $firstColumn =1; 
        $totalRows = 2; 
        $totalColumns = 3; 
        $address = 'http://www.aspose.com';    
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsHypelinksPutWorkSheetHyperlink($name, $sheet_name,$firstRow,$firstColumn,$totalRows,$totalColumns,$address,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$hyperlink = new Hyperlink();
$hyperlink->putWorkSheetHyperlink();

?>

Examples-PHP-Images-GetWorksheetAutoshapeWithFormat-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Image {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetAutoshapeWithFormat() {
		$name ='myDocument.xlsx';
        $sheet_name ='Sheet2';
        $autoshapeNumber = 4;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsAutoshapesGetWorksheetAutoshape($name, $sheet_name,$autoshapeNumber, null, $folder);
        $json = json_decode($result);
        $this->assertEquals(200, $json->Code);
	}
}

$image = new Image();
$image->getWorksheetAutoshapeWithFormat();

?>

Examples-PHP-Import Data-PostImportData-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class ImportData {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postImportData() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $data = new ImportIntArrayOption();
        $data->setDestinationWorksheet('Sheet1');
        $data->setFirstColumn(1);
        $data->setFirstRow(3);
        $data->setImportDataType('IntArray');
        $data->setIsVertical('true');
        $data->setData(array(1, 2, 3, 4)) ;
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookPostImportData($name, $data,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$importData = new ImportData();
$importData->postImportData();

?>

Examples-PHP-ListObjects-PostSortTableData-.php

// For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
<?php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Cell {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postSortTableData() {
        // Upload file to Aspose Cloud Storage
        $name ='Book1.xlsx';
        $sheet_name ='Sheet7';
        $listObjectIndex = 0;   
        $dataSorter = new DataSorter();
        $dataSorter->setCaseSensitive('true');
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsListObjectsPostWorksheetListObjectSortTable($name, $sheet_name,$listObjectIndex,$dataSorter,$folder);
        $this->assertEquals(200, $result['code']);
    }
}

$cell = new Cell();
$cell->postSortTableData();

?>

Examples-PHP-LiteCells-Assemble.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postAssemble( $files,'ds' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Clear.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postClearObjects($files, 'picture' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Export-chart-png.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postExport($files, 'chart','png' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Export-chart-tiff.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postExport($files, 'chart','tiff' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Export-picture-png.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postExport($files, 'picture','png' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Export-picture-tiff.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postExport($files, 'picture','tiff' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Export-shape-png.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postExport($files, 'shape','png' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Export-shape-tiff.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postExport($files, 'shape','tiff' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Export-workbook-pdf.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postExport($files, 'workbook','pdf' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Export-workbook-tiff.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postExport($files, 'workbook','pdf' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Export.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postExport($files, 'chart','pdf' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Merge.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postMerge($files, 'pdf' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Metadata-Delete.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->deleteMetadata($files );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Metadata-Get.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->getMetadata($files );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Metadata-Update.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;
use \Aspose\Cells\Cloud\Model\CellsDocumentProperty;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $cellsDocumentProperty = new CellsDocumentProperty();
        $cellsDocumentProperty->setName('test');
        $cellsDocumentProperty->setValue('test');
        $result = $this->instance->postMetadata( $files , array( $cellsDocumentProperty ) );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Protect.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postProtect($files, '123456' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Search.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postSearch($files, '1' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Split.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postSplit($files, 'pdf' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-Unlock.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postUnlock($files, '123456' );
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-LiteCells-WaterMark.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\LiteCellsApi;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new LiteCellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function runCloudAPI() {

        $DataSource ='datasource.xlsx';
        $AssemblyTest ='assemblytest.xlsx';
        $sourcePath = '../TestData/';
        $files = array (
            $DataSource =>  $sourcePath.$DataSource,
            $AssemblyTest =>  $sourcePath.$AssemblyTest
        );
        $result = $this->instance->postWaterMark($files, 'aspose cells cloud' ,'#fff');
        $this->assertNotNull($result);
    }
}

$workbook = new Workbook();
$workbook->runCloudAPI();

?>

Examples-PHP-OLEObjects-DeleteWorksheetOleObject-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class OLEObject {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteWorksheetOleObject() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet6';
        $oleObjectIndex = 0;         
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsOleObjectsDeleteWorksheetOleObject($name, $sheet_name,$oleObjectIndex,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$oLEObject = new OLEObject();
$oLEObject->deleteWorksheetOleObject();

?>

Examples-PHP-OLEObjects-DeleteWorksheetOleObjects-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class OLEObject {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteWorksheetOleObjects() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet6';
        $oleObjectIndex = 0;         
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsOleObjectsDeleteWorksheetOleObjects($name, $sheet_name,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$oLEObject = new OLEObject();
$oLEObject->deleteWorksheetOleObjects();

?>

Examples-PHP-OLEObjects-GetWorksheetOleObject-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class OLEObject {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetOleObject() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet6';
        $oleObjectIndex = 0;         
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsOleObjectsGetWorksheetOleObject($name, $sheet_name,$oleObjectIndex,null,$folder);
        $json = json_decode($result);
        $this->assertEquals(200, $json->Code);
	}
}

$oLEObject = new OLEObject();
$oLEObject->getWorksheetOleObject();

?>

Examples-PHP-OLEObjects-GetWorksheetOleObjects-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class OLEObject {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetOleObjects() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet6';
        $oleObjectIndex = 0;         
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsOleObjectsGetWorksheetOleObject($name, $sheet_name,$oleObjectIndex,null,$folder);
        $json = json_decode($result);
        $this->assertEquals(200, $json->Code);
	}
}

$oLEObject = new OLEObject();
$oLEObject->getWorksheetOleObjects();

?>

Examples-PHP-OLEObjects-GetWorksheetOleObjectWithFormat-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class OLEObject {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetOleObjectWithFormat() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet6';
        $oleObjectIndex = 0;         
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsOleObjectsGetWorksheetOleObject($name, $sheet_name,$oleObjectIndex,"png",$folder);
        $json = json_decode($result);
        $this->assertEquals(200, $json->Code);
	}
}

$oLEObject = new OLEObject();
$oLEObject->getWorksheetOleObjectWithFormat();

?>

Examples-PHP-OLEObjects-PostUpdateWorksheetOleObject-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class OLEObject {

  public $instance;

  public function __construct() {
    AsposeApp::$clientId = Utils::clientId;
    AsposeApp::$clientSecret = Utils::clientSecret;
    $this->cells = new CellsApi();
  }

	public function postUpdateWorksheetOleObject() {
    $name ='Book1.xlsx';
    $sheet_name ='Sheet6';
    $oleObjectIndex = 0;  
    $ole = new OleObject();  
    $ole->setLeft (10);
    $ole->setRight (10);
    $ole->setHeight(90);
    $ole->setWidth(78);     
    $folder = "Temp";
    CellsApiTestBase::ready(  $this->instance,$name ,$folder);
    $result = $this->instance->cellsOleObjectsPostUpdateWorksheetOleObject($name, $sheet_name,$oleObjectIndex,$ole,$folder);
    $this->assertEquals(200, $result['code']);
  }
}

$oLEObject = new OLEObject();
$oLEObject->postUpdateWorksheetOleObject();

?>

Examples-PHP-OLEObjects-PutWorksheetOleObject-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class OLEObject {

    public $instance;

    public function __construct() {
        AsposeApp::$clientId = Utils::clientId;
        AsposeApp::$clientSecret = Utils::clientSecret;
        $this->cells = new CellsApi();
    }

	public function putWorksheetOleObject() {
        $name ='Book1.xlsx';
        $sheet_name ='Sheet6';
        $ole = null;
        $upperLeftRow = 1;         
        $upperLeftColumn = 1;  
        $height = 100;  
        $width = 80;  
        $oleFile = 'OLEDoc.docx';  
        $imageFile = 'word.jpg';  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$imageFile,"");
        CellsApiTestBase::ready(  $this->instance,$oleFile,"");
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsOleObjectsPutWorksheetOleObject($name, $sheet_name, $ole,$upperLeftRow,$upperLeftColumn ,$height,$width,$oleFile, $imageFile ,$folder);
        $this->assertEquals(200, $result['code']);
    }
}

$oLEObject = new OLEObject();
$oLEObject->putWorksheetOleObject();

?>

Examples-PHP-Pictures-DeleteWorksheetPicture-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Picture {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteWorksheetPicture() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet6';
        $index = 0;         
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPicturesDeleteWorkSheetPictures($name, $sheet_name,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$picture = new Picture();
$picture->deleteWorksheetPicture();

?>

Examples-PHP-Pictures-DeleteWorkSheetPictures-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Picture {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteWorkSheetPictures() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet6';
        $index = 0;         
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPicturesDeleteWorkSheetPictures($name, $sheet_name,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$picture = new Picture();
$picture->deleteWorkSheetPictures();

?>

Examples-PHP-Pictures-GetWorksheetPicture-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Picture {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetPicture() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet6';
        $pictureIndex = 0;         
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPicturesGetWorksheetPicture($name, $sheet_name,$pictureIndex,null,$folder);
        $json = json_decode($result);
        $this->assertEquals(200, $json->Code);
	}
}

$picture = new Picture();
$picture->getWorksheetPicture();

?>

Examples-PHP-Pictures-GetWorksheetPictures-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Picture {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetPictures() {
        $name ='Book1.xlsx';
        $sheet_name ='Sheet6';
        $pictureIndex = 0;         
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPicturesGetWorksheetPictures($name, $sheet_name,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$picture = new Picture();
$picture->getWorksheetPictures();

?>

Examples-PHP-Pictures-GetWorksheetPictureWithFormat-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Picture {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetPictureWithFormat() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet6';
        $pictureIndex = 0;         
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPicturesGetWorksheetPicture($name, $sheet_name,$pictureIndex,"png",$folder);
        $json = json_decode($result);
        $this->assertEquals(200, $json->Code);
	}
}

$picture = new Picture();
$picture->getWorksheetPictureWithFormat();

?>

Examples-PHP-Pictures-PostWorkSheetPicture-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Picture {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postWorkSheetPicture() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet6';
        $pictureIndex = 0;   
        $picture = new Picture ();
        $picture->setLeft(10);      
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPicturesPostWorkSheetPicture($name, $sheet_name, $pictureIndex , $picture,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$picture = new Picture();
$picture->postWorkSheetPicture();

?>

Examples-PHP-Pictures-PutWorksheetAddPicture-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Picture {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putWorksheetAddPicture() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet6';       
        $picture = null;
        $upperLeftRow = 1;   
        $upperLeftColumn = 1;   
        $lowerRightRow = 10;   
        $lowerRightColumn = 10;   
        $picturePath = 'WaterMark.png';        
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        CellsApiTestBase::ready(  $this->instance,$picturePath ,"");
        $result = $this->instance->cellsPicturesPutWorksheetAddPicture($name, $sheet_name, $picture,   $upperLeftRow,$upperLeftColumn ,$lowerRightRow,$lowerRightColumn,$picturePath, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$picture = new Picture();
$picture->putWorksheetAddPicture();

?>

Examples-PHP-Pivot Tables-DeleteWorksheetPivotTable-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class PivotTable {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteWorksheetPivotTable() {
    	$name ='TestCase.xlsx';
        $sheet_name ='Sheet4';
        $pivotTableIndex = 0;
        $pivotFieldType = "row";
        $request = new PivotTableFieldRequest();
        $request->setData( array(1));
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPivotTablesDeleteWorksheetPivotTable($name, $sheet_name, $pivotTableIndex, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$pivotTable = new PivotTable();
$pivotTable->deleteWorksheetPivotTable();

?>

Examples-PHP-Pivot Tables-DeleteWorksheetPivotTables-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class PivotTable {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteWorksheetPivotTables() {
    	$name ='TestCase.xlsx';
        $sheet_name ='Sheet4';
        $pivotTableIndex = 0;
        $fieldIndex = 0;
        $needReCalculate = 'true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPivotTablesDeleteWorksheetPivotTables($name, $sheet_name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$pivotTable = new PivotTable();
$pivotTable->deleteWorksheetPivotTables();

?>

Examples-PHP-Pivot Tables-GetWorksheetPivotTable-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class PivotTable {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetPivotTable() {
    	$name ='TestCase.xlsx';
        $sheet_name ='Sheet4';
        $pivotTableIndex = 0;
        $fieldIndex = 0;
        $needReCalculate = 'true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPivotTablesGetWorksheetPivotTable($name, $sheet_name,$pivotTableIndex, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$pivotTable = new PivotTable();
$pivotTable->getWorksheetPivotTable();

?>

Examples-PHP-Pivot Tables-GetWorksheetPivotTables-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class PivotTable {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetPivotTables() {
    	$name ='TestCase.xlsx';
        $sheet_name ='Sheet4';
        $pivotTableIndex = 0;
        $fieldIndex = 0;
        $needReCalculate = 'true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPivotTablesGetWorksheetPivotTables($name, $sheet_name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$pivotTable = new PivotTable();
$pivotTable->getWorksheetPivotTables();

?>

Examples-PHP-Pivot Tables-PostPivotTableCellStyle-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class PivotTable {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postPivotTableCellStyle() {
    	$name ='TestCase.xlsx';
        $sheet_name ='Sheet4';
        $pivotTableIndex = 0;
        $column = 1;
        $row = 1;
        $style = new Style();
        $style->setFont( new Font());
        $style->getFont()->setSize (17);
        $needReCalculate = 'true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPivotTablesPostPivotTableCellStyle($name, $sheet_name, $pivotTableIndex ,$column,$row ,$style,$needReCalculate  ,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$pivotTable = new PivotTable();
$pivotTable->postPivotTableCellStyle();

?>

Examples-PHP-Pivot Tables-PostPivotTableStyle-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class PivotTable {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postPivotTableStyle() {
    	$name ='TestCase.xlsx';
        $sheet_name ='Sheet4';
        $pivotTableIndex = 0;
        $style = new Style();
        $style->setFont( new Font());
        $style->getFont()->setSize (17);
        $needReCalculate = 'true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPivotTablesPostPivotTableStyle($name, $sheet_name, $pivotTableIndex ,$style,$needReCalculate,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$pivotTable = new PivotTable();
$pivotTable->postPivotTableStyle();

?>

Examples-PHP-Pivot Tables-PutWorksheetPivotTable-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class PivotTable {

  public $instance;

  public function __construct() {
    AsposeApp::$clientId = Utils::clientId;
    AsposeApp::$clientSecret = Utils::clientSecret;
    $this->cells = new CellsApi();
  }

	public function putWorksheetPivotTable() {
    $name ='TestCase.xlsx';
    $sheet_name ='Sheet4';
    $request = new CreatePivotTableRequest();
    $request->setName ("TestPivot");
    $request->setDestCellName ("C1");
    $request->setSourceData ("Sheet1!C6:E13");
    $request->setUseSameSource( true);
    $sourceData = "Sheet1!C6:E13";
    $destCellName = "C1";
    $tableName = "TestPivot";
    $useSameSource = 'true';
    $folder = "Temp";
    CellsApiTestBase::ready(  $this->instance,$name ,$folder);
    $result = $this->instance->cellsPivotTablesPutWorksheetPivotTable($name, $sheet_name, null, $folder,null, $sourceData,$destCellName,$tableName,$useSameSource);
    $this->assertEquals(200, $result['code']);
  }
}

$pivotTable = new PivotTable();
$pivotTable->putWorksheetPivotTable();

?>

Examples-PHP-Rows-DeleteWorksheetRow-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Row {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteWorksheetRow() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $row_index = 1;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =  $this->instance->cellsDeleteWorksheetRow($name, $sheet_name, $row_index,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$row = new Row();
$row->deleteWorksheetRow();

?>

Examples-PHP-Rows-DeleteWorksheetRows-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Row {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function deleteWorksheetRows() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $startrow = 1;  
        $total_rows =2;
        $update_reference ='true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =  $this->instance->cellsDeleteWorksheetRows($name, $sheet_name, $startrow,$total_rows,  $update_reference, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$row = new Row();
$row->deleteWorksheetRows();

?>

Examples-PHP-Rows-GetWorksheetRow-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Row {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorksheetRow() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $rowIndex = 1;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsGetWorksheetRow($name, $sheet_name, $rowIndex,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$row = new Row();
$row->getWorksheetRow();

?>

Examples-PHP-Rows-PostAutofitWorkbookRows-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Row {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postAutofitWorkbookRows() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $autoFitterOptions = null;
        $startRow = 1;
        $endRow = 100;
        $onlyAuto = 'true';
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookPostAutofitWorkbookRows($name, $autoFitterOptions,  $startRow, $endRow, $onlyAuto , $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$row = new Row();
$row->postAutofitWorkbookRows();

?>

Examples-PHP-Rows-PostCopyWorksheetRows-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Row {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postCopyWorksheetRows() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $sourceRowIndex = 1;  
        $destinationRowIndex = 21;
        $rowNumber =1; 
        $worksheet ='Sheet2';       
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =   $this->instance->cellsPostCopyWorksheetRows($name, $sheet_name, $sourceRowIndex, $destinationRowIndex,$rowNumber,$worksheet,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$row = new Row();
$row->postCopyWorksheetRows();

?>

Examples-PHP-Rows-PostGroupWorksheetRows-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Row {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postGroupWorksheetRows() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $firstIndex = 1;  
        $lastIndex = 21;
        $hide ='true';       
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =    $this->instance->cellsPostGroupWorksheetRows($name, $sheet_name, $firstIndex, $lastIndex,$hide,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$row = new Row();
$row->postGroupWorksheetRows();

?>

Examples-PHP-Rows-PostHideWorksheetRows-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Row {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postHideWorksheetRows() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $startrow = 1;  
        $totalRows = 21;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =   $this->instance->cellsPostHideWorksheetRows($name, $sheet_name, $startrow, $totalRows,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$row = new Row();
$row->postHideWorksheetRows();

?>

Examples-PHP-Rows-PostRowStyle-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Row {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postRowStyle() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $rowIndex = 1;  
        $style = new Style();
        $font = new Font();
        $font->setIsBold('true');
        $font->setSize(10);
        $style->setFont($font);
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =   $this->instance->cellsPostRowStyle($name, $sheet_name, $rowIndex, $style,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$row = new Row();
$row->postRowStyle();

?>

Examples-PHP-Rows-PostUngroupWorksheetRows-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Row {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postUngroupWorksheetRows() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $firstIndex = 1; 
        $lastIndex = 10;
        $isAll ='true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPostUngroupWorksheetRows($name, $sheet_name, $firstIndex, $lastIndex,$isAll, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$row = new Row();
$row->postUngroupWorksheetRows();

?>

Examples-PHP-Rows-PostUnhideWorksheetRows-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Row {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postUnhideWorksheetRows() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $startrow = 1; 
        $totalRows = 10;
        $height =20.0;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPostUnhideWorksheetRows($name, $sheet_name, $startrow, $totalRows, $height, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$row = new Row();
$row->postUnhideWorksheetRows();

?>

Examples-PHP-Rows-PostUpdateWorksheetRow-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Row {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postUpdateWorksheetRow() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $rowIndex = 1; 
        $height = 10.0;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =$this->instance->cellsPostUpdateWorksheetRow($name, $sheet_name, $rowIndex, $height,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$row = new Row();
$row->postUpdateWorksheetRow();

?>

Examples-PHP-Rows-PutInsertWorksheetRow-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Row {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putInsertWorksheetRow() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $rowIndex = 1;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPutInsertWorksheetRow($name, $sheet_name, $rowIndex ,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$row = new Row();
$row->putInsertWorksheetRow();

?>

Examples-PHP-Rows-PutInsertWorksheetRows-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Row {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putInsertWorksheetRows() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $startrow = 1;
        $totalRows = 11;
        $updateReference ='true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPutInsertWorksheetRows($name, $sheet_name, $startrow ,$totalRows, $updateReference, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$row = new Row();
$row->putInsertWorksheetRows();

?>

Examples-PHP-Text-GetWorkBookTextItems-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Text {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorkBookTextItems() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $password = null;
        $isAutoFit = 'true';
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookGetWorkBookTextItems($name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$text = new Text();
$text->getWorkBookTextItems();

?>

Examples-PHP-Text-GetWorkSheetTextItems-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Text {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorkSheetTextItems() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1'; 
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsGetWorkSheetTextItems($name, $sheet_name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$text = new Text();
$text->getWorkSheetTextItems();

?>

Examples-PHP-Text-PostWorkbooksTextReplace-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Text {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postWorkbooksTextReplace() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $oldValue = "!22";
        $newValue = "22";    
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookPostWorkbooksTextReplace($name, $oldValue,$newValue,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$text = new Text();
$text->postWorkbooksTextReplace();

?>

Examples-PHP-Text-PostWorkbooksTextSearch-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Text {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postWorkbooksTextSearch() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $text = "!test";      
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookPostWorkbooksTextSearch($name, $text,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$text = new Text();
$text->postWorkbooksTextSearch();

?>

Examples-PHP-Text-PostWorkSheetTextSearch-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Text {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postWorkSheetTextSearch() {
    	$name = "Book1.xlsx";
        $sheet_name ='Sheet1'; 
        $text = "B3";       
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsPostWorkSheetTextSearch($name, $sheet_name,  $text,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$text = new Text();
$text->postWorkSheetTextSearch();

?>

Examples-PHP-Text-PostWorsheetTextReplace-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Text {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postWorsheetTextReplace() {
    	$name = "Book1.xlsx";
        $sheet_name ='Sheet1'; 
        $oldValue = "1234";    
        $newValue = "wewew4";  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsPostWorsheetTextReplace($name, $sheet_name,  $oldValue, $newValue, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$text = new Text();
$text->postWorsheetTextReplace();

?>

Examples-PHP-Utils-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once __DIR__ . '/vendor/autoload.php';

class Utils {
	#
	const ClientId = getenv("CellsCloudTestClientId");
	const ClientSecret = getenv("CellsCloudTestClientSecret");

	public static function uploadFile($fileName) {
		
		$cwd = getcwd();
        $parents = "/";
        $png = "TestData/" . $filename;
        $file = null;
        for ($x=0; $x <= 10; $x++) {
            $path = $cwd . $parents . $png;
            if (file_exists($path)) {
                $file = $path;
                break;
            }
            $parents = $parents . "../";
        }

        if ( $folder == ""){
            $fullName=$filename;
        }else{
            $fullName=$folder . "/" .  $filename;
        }
        $result = $api->uploadFile($fullName,$file,null );
        return $result;
	} 
}

?>

Examples-PHP-Workbook-DeleteDecryptDocument-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function deleteDecryptDocument() {
    	$name ='Book1.xlsx';  
        $encryption = new WorkbookEncryptionRequest();
        $encryption->setPassword("123456");
        $encryption->setKeyLength( 128);
        $encryption->setEncryptionType( "XOR");      
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookDeleteDecryptDocument($name, $encryption,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$workbook = new Workbook();
$workbook->deleteDecryptDocument();

?>

Examples-PHP-Workbook-DeleteDocumentUnProtectFromChanges-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function deleteDocumentUnProtectFromChanges() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookDeleteDocumentUnProtectFromChanges($name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$workbook = new Workbook();
$workbook->deleteDocumentUnProtectFromChanges();

?>

Examples-PHP-Workbook-DeleteUnProtectDocument-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function deleteUnProtectDocument() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $protection = new WorkbookProtectionRequest();
        $protection->setPassword ("123");
        $protection->setProtectionType( "All");
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookDeleteUnProtectDocument($name,$protection, $folder);
        $this->assertEquals(200, $result['code']);
    }	
}

$workbook = new Workbook();
$workbook->deleteUnProtectDocument();

?>

Examples-PHP-Workbook-GetExtractBarcodes-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getExtractBarcodes() {
    	// Upload file to Aspose Cloud Storage
		$fileName = "test_cells.xlsx";
		Utils::uploadFile($fileName);

        $result = $this->cells->GetExtractBarcodes($name=$fileName, $sheetName="Sheet1", $pictureNumber="0", $storage = null, $folder = null);        
        print_r($result);
	}
}

$workbook = new Workbook();
$workbook->getExtractBarcodes();

?>

Examples-PHP-Workbook-GetWorkBook-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorkBook() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $password = null;
        $isAutoFit = 'true';
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookGetWorkBook($name,$password,null,$isAutoFit, false,$folder);
        $json = json_decode($result);
        $this->assertEquals(200, $json->Code);
	}
}

$workbook = new Workbook();
$workbook->getWorkBook();

?>

Examples-PHP-Workbook-GetWorkBookDefaultStyle-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorkBookDefaultStyle() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $password = null;
        $isAutoFit = 'true';
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookGetWorkBookDefaultStyle($name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$workbook = new Workbook();
$workbook->getWorkBookDefaultStyle();

?>

Examples-PHP-Workbook-GetWorkBookName-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorkBookName() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $nameName = "Name_2";
        $isAutoFit = 'true';
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookGetWorkBookName($name,$nameName, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$workbook = new Workbook();
$workbook->getWorkBookName();

?>

Examples-PHP-Workbook-GetWorkBookNames-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}


	public function getWorkBookNames() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $password = null;
        $isAutoFit = 'true';
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookGetWorkBookNames($name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$workbook = new Workbook();
$workbook->getWorkBookNames();

?>

Examples-PHP-Workbook-GetWorkBookWithFormat-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorkBookWithFormat() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $password = null;
        $isAutoFit = 'true';
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookGetWorkBook($name,$password,null,$isAutoFit, false,$folder);
        $json = json_decode($result);
        $this->assertEquals(200, $json->Code);
	}
}

$workbook = new Workbook();
$workbook->getWorkBookWithFormat();

?>

Examples-PHP-Workbook-PostColumnStyle-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postColumnStyle() {
        $name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $columnIndex = 1;  
        $style = new Style();
        $font = new Font();
        $font->setIsBold('true');
        $font->setSize(10);
        $style->setFont($font);
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =   $this->instance->cellsPostColumnStyle($name, $sheet_name, $columnIndex, $style,$folder);
        $this->assertEquals(200, $result['code']);
    }
}

$workbook = new Workbook();
$workbook->postColumnStyle();

?>

Examples-PHP-Workbook-PostCopyWorksheetColumns-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postCopyWorksheetColumns() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $sourceColumnIndex = 1;  
        $destinationColumnIndex = 21;
        $columnNumber =1; 
        $worksheet ='Sheet2';       
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =  $this->instance->cellsPostCopyWorksheetColumns($name, $sheet_name, $sourceColumnIndex, $destinationColumnIndex,$columnNumber,$worksheet,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$workbook = new Workbook();
$workbook->postCopyWorksheetColumns();

?>

Examples-PHP-Workbook-PostDocumentSaveAs-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;


class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new CellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function postDocumentSaveAs() {
        $name ='Book1.xlsx';    
        $saveOptions = null;
        $newFilename = "newbook.xlsx";
        $isAutoFitRows= 'true';
        $isAutoFitColumns= 'true';
        $folder = "PHPTest";
        $sourceFolder = ".\\data\\";
        $this->cells->uploadFile($folder . "/" .  $name , $sourceFolder. $name);
        $result = $this->cells->cellsSaveAsPostDocumentSaveAs($name, $saveOptions, $newFilename, $isAutoFitRows, $isAutoFitColumns, $folder);        
    }
}

$workbook = new Workbook();
$workbook->postDocumentSaveAs();

?>

Examples-PHP-Workbook-PostEncryptDocument-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postEncryptDocument() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $encryption = new WorkbookEncryptionRequest();
        $encryption->setPassword("123456");
        $encryption->setKeyLength( 128);
        $encryption->setEncryptionType( "XOR");   
        $autoFitterOptions = null;
        $startRow = 1;
        $endRow = 100;
        $onlyAuto = 'true';
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookPostEncryptDocument($name, $encryption,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$workbook = new Workbook();
$workbook->postEncryptDocument();

?>

Examples-PHP-Workbook-PostGroupWorksheetColumns-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postGroupWorksheetColumns() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $firstIndex = 1;  
        $lastIndex = 21;
        $hide ='true';       
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =   $this->instance->cellsPostGroupWorksheetColumns($name, $sheet_name, $firstIndex, $lastIndex,$hide,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$workbook = new Workbook();
$workbook->postGroupWorksheetColumns();

?>

Examples-PHP-Workbook-PostImportBatchData.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;
use \Aspose\Cells\Cloud\Model\ImportBatchDataOption;
use \Aspose\Cells\Cloud\Model\CellValue;
class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new CellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function postImportBatchDataCloudFile() {

        $v1 = new CellValue();
        $v1->setRowIndex(1);
        $v1->setColumnIndex(1);
        $v1->setType('string');
        $v1->setValue('1111');

        $v2 = new CellValue();
        $v2->setRowIndex(1);
        $v2->setColumnIndex(2);
        $v2->setType('int');
        $v2->setValue('1111');

        $name ='Book1.xlsx';
        $folder = "Temp";
        $data = new ImportBatchDataOption();
        $data->setDestinationWorksheet('Sheet1');
        $data->setImportDataType('BatchData');
        $data->setBatchData(array($v1, $v2)) ;
        $sourceFolder = ".\\data\\";
        $this->cells->uploadFile($folder . "/" .  $name , $sourceFolder. $name);
        $result = $this->cells->cellsWorkbookPostImportData($name, $data,  $folder);
    }
}

$workbook = new Workbook();
$workbook->postImportBatchDataCloudFile();

?>

Examples-PHP-Workbook-PostImportCSVData.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;
use \Aspose\Cells\Cloud\Model\ImportCSVDataOption;
use \Aspose\Cells\Cloud\Model\CellValue;
class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new CellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function postImportDataCloudFile() {

        $name ='Book1.xlsx';
        $folder = "PHPTest";
        $data = new ImportCSVDataOption();
        $data->setConvertNumericData(false);
        $data->setDestinationWorksheet('Sheet2');
        $data->setFirstColumn(1);
        $data->setFirstRow(1) ;
        $data->setSeparatorString(';') ;
        $data->setImportDataType('CSVData');
        $data->setSourceFile('TestImportDataCSV.csv');
        $sourceFolder = ".\\data\\";
        $this->cells->uploadFile('TestImportDataCSV.csv', $sourceFolder.'TestImportDataCSV.csv');
        $this->cells->uploadFile($folder . "/" .  $name , $sourceFolder. $name);
        $result = $this->cells->cellsWorkbookPostImportData($name, $data,  $folder);
    }
}

$workbook = new Workbook();
$workbook->postImportDataCloudFile();

?>

Examples-PHP-Workbook-PostImportDataCloudFile-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;
use \Aspose\Cells\Cloud\Model\ImportIntArrayOption;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new CellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function postImportDataCloudFile() {
        $name ='Book1.xlsx';
        $folder = "PHPTest";
        $data = new ImportIntArrayOption();
        $data->setDestinationWorksheet('Sheet1');
        $data->setFirstColumn(1);
        $data->setFirstRow(3);
        $data->setImportDataType('IntArray');
        $data->setIsVertical('true');
        $data->setData(array(1, 2, 3, 4)) ;
        $sourceFolder = ".\\data\\";
        $this->cells->uploadFile($folder . "/" .  $name , $sourceFolder. $name);
        $result = $this->cells->cellsWorkbookPostImportData($name, $data,  $folder);
    }
}

$workbook = new Workbook();
$workbook->postImportDataCloudFile();

?>

Examples-PHP-Workbook-PostImportDataCloudFile-2.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;
use \Aspose\Cells\Cloud\Model\ImportIntArrayOption;

class Workbook {

public $cells;

public function __construct() {
    $this->cells = new CellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
}

public function postImportDataCloudFile() {
    $name ='Book1.xlsx';
    $folder = "Temp";
    $data = new ImportIntArrayOption();
    $data->setDestinationWorksheet('Sheet1');
    $data->setFirstColumn(1);
    $data->setFirstRow(3);
    $data->setImportDataType('TwoDimensionIntArray');
    $data->setData(array(array(1, 2, 3, 4),array(1, 2, 3, 4))) ;
    $sourceFolder = ".\\data\\";
     $this->cells->uploadFile($folder . "/" .  $name , $sourceFolder. $name);
    $result = $this->cells->cellsWorkbookPostImportData($name, $data,  $folder);
}
}

$workbook = new Workbook();
$workbook->postImportDataCloudFile();

?>

Examples-PHP-Workbook-PostImportDataCloudFile-2Double.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;
use \Aspose\Cells\Cloud\Model\ImportIntArrayOption;

class Workbook {

public $cells;

public function __construct() {
    $this->cells = new CellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
}

public function postImportDataCloudFile() {
    $name ='Book1.xlsx';
    $folder = "Temp";
    $data = new ImportIntArrayOption();
    $data->setDestinationWorksheet('Sheet1');
    $data->setFirstColumn(1);
    $data->setFirstRow(3);
    $data->setImportDataType('TwoDimensionDoubleArray');
    $data->setData(array(array(1.0, 0.2, 1.3, 4.1),array(1.1, 1.1112, 0.03, 4))) ;
    $sourceFolder = ".\\data\\";
     $this->cells->uploadFile($folder . "/" .  $name , $sourceFolder. $name);
    $result = $this->cells->cellsWorkbookPostImportData($name, $data,  $folder);
}
}

$workbook = new Workbook();
$workbook->postImportDataCloudFile();

?>

Examples-PHP-Workbook-PostImportDataCloudFile-2String.php

<?php

require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;
use \Aspose\Cells\Cloud\Model\ImportIntArrayOption;

class Workbook {

public $cells;

public function __construct() {
    $this->cells = new CellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
}

public function postImportDataCloudFile() {
    $name ='Book1.xlsx';
    $folder = "Temp";
    $data = new ImportIntArrayOption();
    $data->setDestinationWorksheet('Sheet1');
    $data->setFirstColumn(1);
    $data->setFirstRow(3);
    $data->setImportDataType('TwoDimensionStringArray');
    $data->setData(array(array("1.0", "0.2", "1.3", "4.1"),array("1.1", "1.1112", "0.03", "4"))) ;
    $sourceFolder = ".\\data\\";
     $this->cells->uploadFile($folder . "/" .  $name , $sourceFolder. $name);
    $result = $this->cells->cellsWorkbookPostImportData($name, $data,  $folder);
}
}

$workbook = new Workbook();
$workbook->postImportDataCloudFile();

?>

Examples-PHP-Workbook-PostImportDataCloudFile-Double.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;
use \Aspose\Cells\Cloud\Model\ImportIntArrayOption;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new CellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function postImportDataCloudFile() {
        $name ='Book1.xlsx';
        $folder = "PHPTest";
        $data = new ImportIntArrayOption();
        $data->setDestinationWorksheet('Sheet1');
        $data->setFirstColumn(1);
        $data->setFirstRow(3);
        $data->setImportDataType('DoubleArray');
        $data->setIsVertical('true');
        $data->setData(array(1.0, 0.2, 1.3, 4.1)) ;
        $sourceFolder = ".\\data\\";
        $this->cells->uploadFile($folder . "/" .  $name , $sourceFolder. $name);
        $result = $this->cells->cellsWorkbookPostImportData($name, $data,  $folder);
    }
}

$workbook = new Workbook();
$workbook->postImportDataCloudFile();

?>

Examples-PHP-Workbook-PostImportDataCloudFile-String.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once('vendor\autoload.php');
use \Aspose\Cells\Cloud\Api\CellsApi;
use \Aspose\Cells\Cloud\Model\ImportIntArrayOption;

class Workbook {

    public $cells;

    public function __construct() {
        $this->cells = new CellsApi( getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
    }

    public function postImportDataCloudFile() {
        $name ='Book1.xlsx';
        $folder = "PHPTest";
        $data = new ImportIntArrayOption();
        $data->setDestinationWorksheet('Sheet1');
        $data->setFirstColumn(1);
        $data->setFirstRow(3);
        $data->setImportDataType('StringArray');
        $data->setIsVertical('true');
        $data->setData(array('1, 2', 'ad3', '4')) ;
        $sourceFolder = ".\\data\\";
        $this->cells->uploadFile($folder . "/" .  $name , $sourceFolder. $name);
        $result = $this->cells->cellsWorkbookPostImportData($name, $data,  $folder);
    }
}

$workbook = new Workbook();
$workbook->postImportDataCloudFile();

?>

Examples-PHP-Workbook-PostImportDataMultipartContent-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postImportDataMultipartContent() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $data = new ImportIntArrayOption();
        $data->setDestinationWorksheet('Sheet1');
        $data->setFirstColumn(1);
        $data->setFirstRow(3);
        $data->setImportDataType('IntArray');
        $data->setIsVertical('true');
        $data->setData(array(1, 2, 3, 4)) ;
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookPostImportData($name, $data,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$workbook = new Workbook();
$workbook->postImportDataMultipartContent();

?>

Examples-PHP-Workbook-PostProtectDocument-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postProtectDocument() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $protection = new WorkbookProtectionRequest();
        $protection->setPassword("123");
        $protection->setProtectionType( "All");
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookPostProtectDocument($name, $protection,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$workbook = new Workbook();
$workbook->postProtectDocument();

?>

Examples-PHP-Workbook-PostTaskDataMultipart-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postTaskDataMultipartContent() {
    $name ='Book1.xlsx';
    $sheet_name ='Sheet1';
    $folder = "Temp";
    CellsApiTestBase::ready(  $this->instance,$name ,$folder);
    $task1 = new TaskDescription();
    $task1->setTaskType('SplitWorkbook');
    $param1 = new SplitWorkbookTaskParameter ();
    $param1->setDestinationFileFormat('xlsx');
    $fileSource =new FileSource();
    // $fileSource->setFilePath($folder);
    $fileSource->setFileSourceType('CloudFileSystem');
    $param1->setDestinationFilePosition($fileSource);
    $param1->setSplitNameRule('sheetname');
    $workbook =new FileSource();
    $workbook->setFilePath( $folder. "\\". $name);
    $workbook->setFileSourceType('CloudFileSystem');
    $param1->setWorkbook($workbook);
    $task1->setTaskParameter($param1);
    $taskData = new TaskData();
    $tasks =  array($task1);
    $taskData->setTasks($tasks);
    $result = $this->instance->cellsTaskPostRunTask($taskData);
	}
}

$workbook = new Workbook();
$workbook->postTaskDataMultipartContent();

?>

Examples-PHP-Workbook-PostWorkbookCalculateFormula-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postWorkbookCalculateFormula() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $options = new CalculationOptions ();
        $options->setIgnoreError( 'true');
        $ignoreError = 'true';
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookPostWorkbookCalculateFormula($name, $options,null, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$workbook = new Workbook();
$workbook->postWorkbookCalculateFormula();

?>

Examples-PHP-Workbook-PostWorkbookGetSmartMarkerResult-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postWorkbookGetSmartMarkerResult() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $xmlFile = "ReportData.xml";
        $outPath = null;
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookPostWorkbookGetSmartMarkerResult($name, $xmlFile,  $folder,null,$outPath);
        $json = json_decode($result);
	}	
}

$workbook = new Workbook();
$workbook->postWorkbookGetSmartMarkerResult();

?>

Examples-PHP-Workbook-PostWorkbooksMerge-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postWorkbooksMerge() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $formatmergeWith = "myDocument.xlsx";      
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        CellsApiTestBase::ready(  $this->instance,$formatmergeWith ,$folder);
        $result = $this->instance->cellsWorkbookPostWorkbooksMerge($name, $formatmergeWith,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$workbook = new Workbook();
$workbook->postWorkbooksMerge();

?>

Examples-PHP-Workbook-PostWorkbookSplit-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postWorkbookSplit() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $format = "png";
        $from = 1;
        $to = 3;
        $horizontalResolution = 100;
        $verticalResolution = 90;
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookPostWorkbookSplit($name, $format, $from, $to, $horizontalResolution, $verticalResolution,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$workbook = new Workbook();
$workbook->postWorkbookSplit();

?>

Examples-PHP-Workbook-PutConvertWorkBook-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function putConvertWorkBook() {
		$format ='pdf';
        $password = null;
        $outPath = null;      
        $cwd = getcwd();
        $parents = "/";
        $name = "TestData/Book1.xlsx";
        $file = null;
        for ($x=0; $x <= 10; $x++) {
            $path = $cwd . $parents . $name;
            if (file_exists($path)) {
                $file = file_get_contents($path);
                break;
            }
            $parents = $parents . "../";
        }
        
        $result = $this->instance->cellsWorkbookPutConvertWorkBook($path ,$format, $password,  $outPath);
	}
}

$workbook = new Workbook();
$workbook->putConvertWorkBook();

?>

Examples-PHP-Workbook-PutConvertWorkBookMultipart-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function putConvertWorkBookMultipart() {
		$format ='pdf';
        $password = null;
        $outPath = null;      
        $cwd = getcwd();
        $parents = "/";
        $name = "TestData/Book1.xlsx";
        $file = null;
        for ($x=0; $x <= 10; $x++) {
            $path = $cwd . $parents . $name;
            if (file_exists($path)) {
                $file = file_get_contents($path);
                break;
            }
            $parents = $parents . "../";
        }
        
        $result = $this->instance->cellsWorkbookPutConvertWorkBook($path ,$format, $password,  $outPath);
	}
}

$workbook = new Workbook();
$workbook->putConvertWorkBookMultipart();

?>

Examples-PHP-Workbook-PutDocumentProtectFromChanges-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function putDocumentProtectFromChanges() {
    	$name ='Book1.xlsx';       
        $folder = "Temp";
        $password = new PasswordRequest();
        $password->setPassword ("123456");      
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorkbookPutDocumentProtectFromChanges($name, $password,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$workbook = new Workbook();
$workbook->putDocumentProtectFromChanges();

?>

Examples-PHP-Workbook-PutWorkbookCreate-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Workbook {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function putWorkbookCreate() {
		$templateFile ='Book1.xlsx';       
        $folder = "Temp";
        date_default_timezone_set("UTC");
        $name = "NewBook".date("Y-m-d-h-i-sa").".xlsx";    
        $dataFile = "ReportData.xml";  
        CellsApiTestBase::ready(  $this->instance,$templateFile ,$folder);
        CellsApiTestBase::ready(  $this->instance,$dataFile ,$folder);
        $result = $this->instance->cellsWorkbookPutWorkbookCreate($name, $folder."/".$templateFile,$folder."/".$dataFile, true, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$workbook = new Workbook();
$workbook->putWorkbookCreate();

?>

Examples-PHP-Worksheet-DeleteUnprotectWorksheet-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function deleteUnprotectWorksheet() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $protectParameter = new ProtectSheetParameter();
        $protectParameter->setPassword ("12345") ;
        $protectParameter->setProtectionType ("All") ;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsDeleteUnprotectWorksheet($name, $sheet_name, $protectParameter, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->deleteUnprotectWorksheet();

?>

Examples-PHP-Worksheet-DeleteWorksheet-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function deleteWorksheet() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';   
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsDeleteWorksheet($name, $sheet_name,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->deleteWorksheet();

?>

Examples-PHP-Worksheet-DeleteWorkSheetBackground-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function deleteWorkSheetBackground() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';       
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsDeleteWorkSheetBackground($name, $sheet_name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->deleteWorkSheetBackground();

?>

Examples-PHP-Worksheet-DeleteWorksheetColumns-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function deleteWorksheetColumns() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $column_index = 1; 
        $columns = 2;
        $update_reference ='true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        // print $config ->getAccessToken();
        $result = $this->instance->cellsDeleteWorksheetColumns($name, $sheet_name, $column_index, $columns, $update_reference, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->deleteWorksheetColumns();

?>

Examples-PHP-Worksheet-DeleteWorkSheetComment-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function deleteWorkSheetComment() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1'; 
        $cellName = "C1";      
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsDeleteWorkSheetComment($name, $sheet_name, $cellName, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->deleteWorkSheetComment();

?>

Examples-PHP-Worksheet-DeleteWorkSheetComments-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function deleteWorkSheetComments() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';   
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsDeleteWorkSheetComments($name, $sheet_name,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->deleteWorkSheetComments();

?>

Examples-PHP-Worksheet-DeleteWorksheetFreezePanes-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function deleteWorksheetFreezePanes() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1'; 
        $row = 1;
        $column = 1;
        $freezedRows = 2;
        $freezedColumns = 2;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsDeleteWorksheetFreezePanes($name, $sheet_name, $row, $column, $freezedRows, $freezedColumns, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->deleteWorksheetFreezePanes();

?>

Examples-PHP-Worksheet-DeleteWorkSheetValidation-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function deleteWorkSheetValidation() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $validationIndex = 0;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetValidationsDeleteWorkSheetValidation($name, $sheet_name, $validationIndex, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->deleteWorkSheetValidation();

?>

Examples-PHP-Worksheet-GetWorkSheet-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorkSheet() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1'; 
        $verticalResolution =100;  
        $horizontalResolution =90;
        $area =null;
        $pageIndex = null;
        $format = "png";
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsGetWorkSheet($name, $sheet_name, $format, $verticalResolution, $horizontalResolution, $area,$pageIndex ,$folder);
        $contents = $result->fread($result->getSize());
        $this->assertGreaterThan(6000, $result->getSize(), "png file size error");
	}
}

$worksheet = new Worksheet();
$worksheet->getWorkSheet();

?>

Examples-PHP-Worksheet-GetWorksheetAutoshape-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorksheetAutoshape() {
    	$name ='myDocument.xlsx';
        $sheet_name ='Sheet2';
        $autoshapeNumber = 4;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsAutoshapesGetWorksheetAutoshape($name, $sheet_name,$autoshapeNumber, null, $folder);
        $json = json_decode($result);
        $this->assertEquals(200, $json->Code);
	}
}

$worksheet = new Worksheet();
$worksheet->getWorksheetAutoshape();

?>

Examples-PHP-Worksheet-GetWorksheetAutoshapes-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorksheetAutoshapes() {
    	$name ='myDocument.xlsx';
        $sheet_name ='Sheet2';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsAutoshapesGetWorksheetAutoshapes($name, $sheet_name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->getWorksheetAutoshapes();

?>

Examples-PHP-Worksheet-GetWorkSheetCalculateFormula-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorkSheetCalculateFormula() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1'; 
        $formula = "=NOW()";
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsGetWorkSheetCalculateFormula($name, $sheet_name, $formula, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->getWorkSheetCalculateFormula();

?>

Examples-PHP-Worksheet-GetWorksheetColumn-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorksheetColumn() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $columnIndex = 2;  
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsGetWorksheetColumn($name, $sheet_name, $columnIndex,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->getWorksheetColumn();

?>

Examples-PHP-Worksheet-GetWorksheetColumns-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorksheetColumns() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =  $this->instance->cellsGetWorksheetColumns($name, $sheet_name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->getWorksheetColumns();

?>

Examples-PHP-Worksheet-GetWorkSheetComment-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorkSheetComment() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1'; 
        $cellName = "B3";
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsGetWorkSheetComment($name, $sheet_name, $cellName, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->getWorkSheetComment();

?>

Examples-PHP-Worksheet-GetWorkSheetComments-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorkSheetComments() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1'; 
        $cellName = "B3";
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsGetWorkSheetComments($name, $sheet_name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->getWorkSheetComments();

?>

Examples-PHP-Worksheet-GetWorksheetRows-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorksheetRows() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =  $this->instance->cellsGetWorksheetRows($name, $sheet_name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->getWorksheetRows();

?>

Examples-PHP-Worksheet-GetWorkSheets-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorkSheets() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1'; 
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsGetWorkSheets($name,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->getWorkSheets();

?>

Examples-PHP-Worksheet-GetWorkSheetValidation-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorkSheetValidation() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $validationIndex = 0;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetValidationsGetWorkSheetValidation($name, $sheet_name, $validationIndex, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->getWorkSheetValidation();

?>

Examples-PHP-Worksheet-GetWorkSheetValidations-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function getWorkSheetValidations() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $validationIndex = 0;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetValidationsGetWorkSheetValidations($name, $sheet_name, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->getWorkSheetValidations();

?>

Examples-PHP-Worksheet-GetWorkSheetWithFormat-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function getWorkSheetWithFormat() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1'; 
        $verticalResolution =100;  
        $horizontalResolution =90;
        $area =null;
        $pageIndex = null;
        $format = "png";
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsGetWorkSheet($name, $sheet_name, $format, $verticalResolution, $horizontalResolution, $area,$pageIndex ,$folder);
        $contents = $result->fread($result->getSize());
        $this->assertGreaterThan(6000, $result->getSize(), "png file size error");
	}
}

$worksheet = new Worksheet();
$worksheet->getWorkSheetWithFormat();

?>

Examples-PHP-Worksheet-PostAutofitWorksheetRows-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postAutofitWorksheetRows() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1'; 
        $startRow =1;
        $endRow = 1;
        $onlyAuto = 'true';
        $autoFitterOptions = new AutoFitterOptions();
        $autoFitterOptions->setAutoFitMergedCells('true');
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsPostAutofitWorksheetRows($name, $sheet_name,  $autoFitterOptions, $startRow,$endRow, $onlyAuto, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->postAutofitWorksheetRows();

?>

Examples-PHP-Worksheet-PostCopyWorksheet-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postCopyWorksheet() {
    	$name = "NewCopy.xlsx";
        $sheet_name ='Sheet5'; 
        $sourceSheet ='Sheet6'; 
        $options = new CopyOptions();
        $options->setColumnCharacterWidth ('true') ;
        $sourceWorkbook = 'Book1.xlsx';
        $sourceFolder = "Temp";
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsPostCopyWorksheet($name, $sheet_name,  $sourceSheet, $options,$sourceWorkbook, $sourceFolder, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->postCopyWorksheet();

?>

Examples-PHP-Worksheet-PostHideWorksheetColumns-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postHideWorksheetColumns() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $startColumn = 1;  
        $totalColumns = 21;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =   $this->instance->cellsPostHideWorksheetColumns($name, $sheet_name, $startColumn, $totalColumns,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->postHideWorksheetColumns();

?>

Examples-PHP-Worksheet-PostMoveWorksheet-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postMoveWorksheet() {
    	$name = "Book1.xlsx";
        $sheet_name ='Sheet1'; 
        $moving = new WorksheetMovingRequest();
        $moving->setDestinationWorksheet('Sheet3') ;
        $moving->setPosition("after");
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsPostMoveWorksheet($name, $sheet_name,  $moving,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->postMoveWorksheet();

?>

Examples-PHP-Worksheet-PostRenameWorksheet-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postRenameWorksheet() {
    	$name = "Book1.xlsx";
        $sheet_name ='Sheet1'; 
        $newname = "renametest";     
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsPostRenameWorksheet($name, $sheet_name,  $newname,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->postRenameWorksheet();

?>

Examples-PHP-Worksheet-PostSetWorksheetColumnWidth-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postSetWorksheetColumnWidth() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $columnIndex = 1; 
        $width = '10';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =  $this->instance->cellsPostSetWorksheetColumnWidth($name, $sheet_name, $columnIndex, $width, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->postSetWorksheetColumnWidth();

?>

Examples-PHP-Worksheet-PostUngroupWorksheetColumns-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postUngroupWorksheetColumns() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $firstIndex = 1; 
        $lastIndex = 10;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result =   $this->instance->cellsPostUngroupWorksheetColumns($name, $sheet_name, $firstIndex, $lastIndex, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->postUngroupWorksheetColumns();

?>

Examples-PHP-Worksheet-PostUnhideWorksheetColumns-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postUnhideWorksheetColumns() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $startcolumn = 1; 
        $totalColumns = 10;
        $width =20.0;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPostUnhideWorksheetColumns($name, $sheet_name, $startcolumn, $totalColumns,$width, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->postUnhideWorksheetColumns();

?>

Examples-PHP-Worksheet-PostUpdateWorksheetProperty-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postUpdateWorksheetProperty() {
    	$name = "Book1.xlsx";
        $sheet_name ='Sheet1'; 
        $sheet = new Worksheet();
        $sheet->setIndex(1) ;
        $sheet->setIsGridlinesVisible("true");
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsPostUpdateWorksheetProperty($name, $sheet_name,  $sheet,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->postUpdateWorksheetProperty();

?>

Examples-PHP-Worksheet-PostUpdateWorksheetRangeStyle-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function postUpdateWorksheetRangeStyle() {
      $name ='Book1.xlsx';
      $sheet_name ='Sheet1';
      $range = 'C1:F10'; 
      $style = new Style();
      $font = new Font();
      $font->setIsBold('true');
      $font->setSize(10);
      $style->setFont($font);
      $folder = "Temp";
      CellsApiTestBase::ready(  $this->instance,$name ,$folder);
      $result = $this->instance->cellsPostUpdateWorksheetRangeStyle($name, $sheet_name, $range, $style,  $folder);
      $this->assertEquals(200, $result['code']);    
    }
}

$worksheet = new Worksheet();
$worksheet->postUpdateWorksheetRangeStyle();

?>

Examples-PHP-Worksheet-PostWorkSheetComment-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

  public $instance;

  public function __construct() {
    AsposeApp::$clientId = Utils::clientId;
    AsposeApp::$clientSecret = Utils::clientSecret;
    $this->cells = new CellsApi();
  }


	public function postWorkSheetComment() {
    $name = "Book1.xlsx";
    $sheet_name ='Sheet1'; 
    $cellName = "B3";
    $comment = new Comment();
    $comment->setAuthor("Roy");
    $folder = "Temp";
    CellsApiTestBase::ready(  $this->instance,$name ,$folder);
    $result = $this->instance->cellsWorksheetsPostWorkSheetComment($name, $sheet_name,  $cellName, $comment, $folder);
    $this->assertEquals(200, $result['code']);
  }
}

$worksheet = new Worksheet();
$worksheet->postWorkSheetComment();

?>

Examples-PHP-Worksheet-PostWorksheetRangeSort-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

  public $instance;

  public function __construct() {
    AsposeApp::$clientId = Utils::clientId;
    AsposeApp::$clientSecret = Utils::clientSecret;
    $this->cells = new CellsApi();
  }
  
	public function postWorksheetRangeSort() {
    $name = "Book1.xlsx";
        $sheet_name ='Sheet1'; 
        $cellArea = 'A1:E10';   
        $dataSorter = new DataSorter();
        $dataSorter->setCaseSensitive('true');    
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsPostWorksheetRangeSort($name, $sheet_name,  $cellArea, $dataSorter, $folder);
        $this->assertEquals(200, $result['code']);
  }
}

$worksheet = new Worksheet();
$worksheet->postWorksheetRangeSort();

?>

Examples-PHP-Worksheet-PostWorkSheetValidation-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function postWorkSheetValidation() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $validationIndex = 0;
        $validation = new Validation();
        $validation->setIgnoreBlank ('true');
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetValidationsPostWorkSheetValidation($name, $sheet_name,$validationIndex, $validation,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->postWorkSheetValidation();

?>

Examples-PHP-Worksheet-PutAddNewWorksheet-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}
	
	public function putAddNewWorksheet() {
    	$name = "Book1.xlsx";
        $sheet_name ='Sheet1'; 
        $position = 1;  
        $sheettype = "VB"; 
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsPutAddNewWorksheet($name, $sheet_name,  $position, $sheettype, $folder);
        $this->assertEquals(201, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->putAddNewWorksheet();

?>

Examples-PHP-Worksheet-PutChangeVisibilityWorksheet-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putChangeVisibilityWorksheet() {
		$name = "Book1.xlsx";
        $sheet_name ='Sheet1'; 
        $isVisible = 'true';
        $sheettype = "VB"; 
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsPutChangeVisibilityWorksheet($name, $sheet_name,  $isVisible, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->putChangeVisibilityWorksheet();

?>

Examples-PHP-Worksheet-PutInsertWorksheetColumns-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putInsertWorksheetColumns() {
    	$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $columnIndex = 1; 
        $columns = 11;
        $updateReference ='true';
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsPutInsertWorksheetColumns($name, $sheet_name, $columnIndex, $columns,$updateReference ,  $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->putInsertWorksheetColumns();

?>

Examples-PHP-Worksheet-PutWorkSheetBackground-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putWorkSheetBackground() {
		$name = "Book1.xlsx";
        $sheet_name ='Sheet1'; 
        $isVisible = 'true';
        $sheettype = "VB"; 
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        
        $cwd = getcwd();
        $parents = "/";
        $png = "TestData/WaterMark.png";
       CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        for ($x=0; $x <= 10; $x++) {
            $path = $cwd . $parents . $png;
            if (file_exists($path)) {
                $file = file_get_contents($path);
                break;
            }
            $parents = $parents . "../";
        }
        $result = $this->instance->cellsWorksheetsPutWorkSheetBackground($name, $sheet_name, $file, $folder);
		$this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->putWorkSheetBackground();

?>

Examples-PHP-Worksheet-PutWorkSheetComment-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

  public $instance;

  public function __construct() {
    AsposeApp::$clientId = Utils::clientId;
    AsposeApp::$clientSecret = Utils::clientSecret;
    $this->cells = new CellsApi();
  }
  
	public function putWorkSheetComment() {
    $name = "Book1.xlsx";
        $sheet_name ='Sheet1'; 
        $cellName = "C1";
        $comment = new Comment();
        $comment->setAuthor("Roy");
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsPutWorkSheetComment($name, $sheet_name,  $cellName, $comment, $folder);
        $this->assertEquals(200, $result['code']);
  }
}

$worksheet = new Worksheet();
$worksheet->putWorkSheetComment();

?>

Examples-PHP-Worksheet-PutWorksheetFreezePanes-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putWorksheetFreezePanes() {
		$name = "Book1.xlsx";
        $sheet_name ='Sheet1'; 
        $row = 1;
        $column = 1;
        $freezedRows = 4;
        $freezedColumns = 5;
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetsPutWorksheetFreezePanes($name, $sheet_name,  $row, $column,$freezedRows,$freezedColumns, $folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->putWorksheetFreezePanes();

?>

Examples-PHP-Worksheet-PutWorkSheetValidation-.php

<?php
# For complete examples and data files, please go to https://github.com/aspose-cells-cloud/aspose-cells-cloud-php
require_once realpath(__DIR__ . '/..') . '/vendor/autoload.php';
require_once realpath(__DIR__ . '/..') . '/Utils.php';

use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;

class Worksheet {

	public $instance;

	public function __construct() {
		$this->instance =  new CellsApi(getenv("CellsCloudTestClientId"),getenv("CellsCloudTestClientSecret"),"v3.0",getenv("CellsCloudTestApiBaseUrl"));
	}

	public function putWorkSheetValidation() {
		$name ='Book1.xlsx';
        $sheet_name ='Sheet1';
        $range = 'A1:c10';      
        $folder = "Temp";
        CellsApiTestBase::ready(  $this->instance,$name ,$folder);
        $result = $this->instance->cellsWorksheetValidationsPutWorkSheetValidation($name, $sheet_name,$range,null,$folder);
        $this->assertEquals(200, $result['code']);
	}
}

$worksheet = new Worksheet();
$worksheet->putWorkSheetValidation();

?>