|
<?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\Request\PostRunTaskRequest; |
|
use \Aspose\Cells\Cloud\Model\TaskDescription; |
|
use \Aspose\Cells\Cloud\Model\SplitWorkbookTaskParameter; |
|
use \Aspose\Cells\Cloud\Model\FileSource; |
|
use \Aspose\Cells\Cloud\Model\TaskData; |
|
class Workbook { |
|
|
|
public $instance; |
|
|
|
public function __construct() { |
|
$this->instance = new CellsApi(getenv("CellsCloudClientId"),getenv("CellsCloudClientSecret"),"v3.0",getenv("CellsCloudApiBaseUrl")); |
|
} |
|
|
|
public function postTaskDataMultipartContent() { |
|
$name ='Book1.xlsx'; |
|
$sheet_name ='Sheet1'; |
|
$folder = "TestData/In"; |
|
$task1 = new TaskDescription(); |
|
$task1->setTaskType('SplitWorkbook'); |
|
$param1 = new SplitWorkbookTaskParameter (); |
|
$param1->setDestinationFileFormat('xlsx'); |
|
$fileSource =new FileSource(); |
|
$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); |
|
|
|
$request = new PostRunTaskRequest(); |
|
$request->setTaskData($taskData); |
|
$result = $this->instance->postRunTask($request); |
|
} |
|
} |
|
|
|
$workbook = new Workbook(); |
|
$workbook->postTaskDataMultipartContent(); |
|
|
|
?> |
