public static function run($dataDir = null)
{
if (is_null($dataDir)) {
die("Data Directory Undefined");
}
// Create Aspose.Cells Helper Object
$ptr = new \COM('Aspose.Cells.Interop.InteropHelper');
// Opening through Path
// Creating a Workbook object and opening an Excel file using its file path
$workbook = $ptr->New("Aspose.Cells.Workbook", array());
$worksheets = $ptr->Get($workbook, "Worksheets", array());
$sheetIndex = $ptr->Call($worksheets, "Add", array());
$worksheet = $ptr->Get($worksheets, "Item", array($sheetIndex));
$cells = $ptr->Get($worksheet, "Cells", array());
$a1 = $ptr->Get($cells, "Item_3", array("A1"));
$ptr->Call($a1, "PutValue", array(1));
$a2 = $ptr->Get($cells, "Item_3", array("A2"));
$ptr->Call($a2, "PutValue", array(2));
$a3 = $ptr->Get($cells, "Item_3", array("A3"));
$ptr->Call($a3, "PutValue", array(3));
$a4 = $ptr->Get($cells, "Item_3", array("A4"));
$ptr->Call($a3, "PutValue", array(3));
$ptr->Call($workbook, "Save", array($dataDir . "/output.xls"));
$ptr->Set($a4, "Formula", "=SUM(A1:A3)", array());
$ptr->Call($workbook, "CalculateFormula", array());
$value = $ptr->Get($a4, "Value", array());
$stringVal = $ptr->Call($value, "ToString", array());
print "Calculated Value: " . $stringVal . PHP_EOL;
$ptr->Call($workbook, "Save", array($dataDir . "/output.xls"));
print "Completed." . PHP_EOL;
}
public static function run($dataDir = null)
{
if (is_null($dataDir)) {
die("Data Directory Undefined");
}
// Create Aspose.Cells Helper Object
$ptr = new \COM('Aspose.Cells.Interop.InteropHelper');
// Opening through Path
// Creating a Workbook object and opening an Excel file using its file path
$workbook = $ptr->New("Aspose.Cells.Workbook", array($dataDir . '/book1.xls'));
$worksheets = $ptr->Get($workbook, "Worksheets", array());
$ptr->Call($worksheets, "RemoveAt_2", array("Sheet1"));
$ptr->Call($workbook, "Save", array($dataDir . "/output.xls"));
print "Completed." . PHP_EOL;
}
public static function run($dataDir = null)
{
if (is_null($dataDir)) {
die("Data Directory Undefined");
}
// Create Aspose.Cells Helper Object
$ptr = new \COM('Aspose.Cells.Interop.InteropHelper');
// Opening through Path
// Creating a Workbook object and opening an Excel file using its file path
$workbook = $ptr->New("Aspose.Cells.Workbook", array($dataDir . '/Book1.xls'));
$XOR = $ptr->New("Aspose.Cells.EncryptionType.XOR", array());
$crypt = $ptr->New("Aspose.Cells.EncryptionType.StrongCryptographicProvider", array());
$ptr->Call($workbook, "SetEncryptionOptions", array($XOR, 40));
$ptr->Call($workbook, "SetEncryptionOptions", array($crypt, 128));
$settings = $ptr->Get($workbook, "Settings", array());
$ptr->Set($settings, "Password", "1234", array());
$ptr->Call($workbook, "Save", array($dataDir . "/encryptedoutBook1.xls"));
print "Completed." . PHP_EOL;
}
public static function run($dataDir = null)
{
if (is_null($dataDir)) {
die("Data Directory Undefined");
}
// Create Aspose.Cells Helper Object
$ptr = new \COM('Aspose.Cells.Interop.InteropHelper');
// Opening through Path
// Creating a Workbook object and opening an Excel file using its file path
$workbook = $ptr->New("Aspose.Cells.Workbook", array($dataDir . '/Book1.xls'));
$ptr->Call($workbook, "Save", array($dataDir . "/outBook1.pdf"));
print "Conversion Completed" . PHP_EOL;
}
public static function run($dataDir = null)
{
if (is_null($dataDir)) {
die("Data Directory Undefined");
}
// Create Aspose.Cells Helper Object
$ptr = new \COM('Aspose.Cells.Interop.InteropHelper');
// Opening through Path
// Creating a Workbook object and opening an Excel file using its file path
$workbook = $ptr->New("Aspose.Cells.Workbook", array());
//Your Code goes here for any workbook related operations
$ptr->Call($workbook, "Save", array($dataDir . '/book1.xls'));
print "File saved successfully!" . PHP_EOL;
}
