I am trying to run below code.
require_once realpath(DIR . ‘/…/…/…/’) . ‘/vendor/autoload.php’;
use Aspose\Cells\CellsApi;
use Aspose\Cells\AsposeApp;
class Workbook {
public $cells;
public function __construct() {
AsposeApp::$clientId = Utils::clientId;
AsposeApp::$clientSecret = Utils::clientSecret;
$this->cells = new CellsApi( AsposeApp::$clientId,AsposeApp::$clientSecret );
}
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)) ;
$this->instance->uploadFile($folder + "/" + $name , $sourceFolder + $name);
$result = $this->instance->cellsWorkbookPostImportData($name, $data, $folder);
}
}
try {
$workbook = new Workbook();
$workbook->postImportDataCloudFile();
} catch (Exception $e) {
echo "Something went wrong: ", $e->getMessage(), "\n";
PHP_EOL;
}