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

$cellsApi = new CellsApi(getenv("CellsCloudClientId"),getenv("CellsCloudClientSecret"),"v3.0",getenv("CellsCloudApiBaseUrl"));

$remoteFolder = "TestData/In";

$localName = "Book1.xlsx";
$remoteName = "Book1.xlsx";


 
$request = new PutInsertNewWorksheetRequest();
$request->setName( $remoteName);
$request->setSheetName( "Sheet1");
$request->setIndex( 1);
$request->setSheettype( "VB");
$request->setNewsheetname( "VBASheet");
$request->setFolder( $remoteFolder);
$request->setStorageName( "");
$cellsApi->putInsertNewWorksheet($request);