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()); $worksheet_index = $ptr->Call($worksheets, "Add_2", array()); $worksheet = $ptr->Get($worksheets, "Item", array($worksheet_index)); $ptr->Set($worksheet, "Name", "My Worksheet", array()); $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 . '/MyTestBook1.xls')); $worksheets = $ptr->Get($workbook, "Worksheets", array()); $sheet = $ptr->Get($worksheets, 'Item', array(0)); $imgOptions = $ptr->New("Aspose.Cells.Rendering.ImageOrPrintOptions", array()); $imageFormat = new \DOTNET('mscorlib', 'System.Drawing.Imaging.ImageFormat'); $ptr->Set($imgOptions, 'ImageFormat', $imageFormat->Jpeg, array()); $ptr->Set($imgOptions, 'OnePagePerSheet', true, array()); $sr = $ptr->New("Aspose.Cells.Rendering.SheetRender", array($sheet, $imgOptions)); $bitmap = new \DOTNET("mscorlib", "System.Drawing.Bitmap"); $bitmap->Save($dataDir . "./SheetImage.jpg"); print "Conversion to Image(s) 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()); print "Workbook opened using path successfully!" . 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; }
function windows_create_kloxo_service() { $OWN_PROCESS = 16; $NOT_INTERACTIVE = False; $NORMAL_ERROR_CONTROL = 2; $objWMIService = new COM("winmgmts:{impersonationLevel=impersonate}//./root/cimv2"); $objService = $objWMIService->Get("Win32_BaseService"); $user = new COM("WinNT://./lxlabs"); $user->setPassword("lxlabspass"); $user->setInfo(); try { //$objService->Create("LxaServer" ,"LxaServer" ,'"C:/Program Files/lxlabs/ext/lxhttpd/Apache2/bin/Apache.exe" -k runservice -f "c:/Program Files/lxlabs/ext/lxhttpd/Apache2/conf/httpd.conf"', $OWN_PROCESS, $NORMAL_ERROR_CONTROL, "Automatic", $NOT_INTERACTIVE, ".\lxlabs", "lxlabspass"); $objService->Create("LxaMultiplexer", "LxaMultiplexer", '"C:/Program Files/lxlabs/ext/Multiplexer/MultiplexerSrvc.exe"', $OWN_PROCESS, $NORMAL_ERROR_CONTROL, "Automatic", $NOT_INTERACTIVE, ".\\LocalSystem", ""); } catch (Exception $e) { print " ERROR: {$e}"; } $colListOfServices = $objWMIService->ExecQuery("Select * from Win32_Service Where Name = 'LxaMultiplexer' or Name = 'LxaServer'"); foreach ($colListOfServices as $objService) { $objService->StartService(); print "\n Done \n"; } }
<?php include "lib/include.php"; $objWMIService = new COM("winmgmts:{impersonationLevel=impersonate}//./root/cimv2"); $objService = $objWMIService->Get("Win32_BaseService"); $colListOfServices = $objWMIService->ExecQuery("Select * from Win32_Service Where Name = 'LxaMultiplexer' or Name = 'LxaServer'"); foreach ($colListOfServices as $objService) { if ($argv[1] == 'stop') { $objService->StopService(); } if ($argv[1] == 'start') { $objService->StartService(); } if ($argv[1] == 'restart') { $objService->StopService(); sleep(1); $objService->StartService(); } print "\n Done \n"; }
function os_restart_program() { return; $objWMIService = new COM("winmgmts:{impersonationLevel=impersonate}//./root/cimv2"); $objService = $objWMIService->Get("Win32_BaseService"); $colListOfServices = $objWMIService->ExecQuery("Select * from Win32_Service Where Name = 'LxaMultiplexer' or Name = 'LxaServer'"); foreach ($colListOfServices as $objService) { $objService->stopService(); sleep(1); $objService->startService(); print "\n Done \n"; } }
function createMxRecord($strDomain, $recordType, $recordValue, $MXpref) { $strContainer = $strDomain; $strOwner = $strDomain; $intTTL = $this->main->ttl; $intPreference = $MXpref; $intRecordClass = '1'; $strMailExchanger = $recordValue; $strServer = ""; $objWMIService = new COM("winmgmts://./root/MicrosoftDNS"); $colItems = $objWMIService->ExecQuery("Select * from MicrosoftDNS_MXType where domainname='{$strDomain}' and preference='{$MXpref}'"); if (mycount($colItems) > 0) { print "Already Exists/n"; throw new lxException("mx_rec_already_exist", ''); } $objItem = $objWMIService->Get("MicrosoftDNS_MXType"); $errResult = $objItem->CreateInstanceFromPropertyData($strServer, $strContainer, $strOwner, $intReCordClass, $intTTL, $intPreference, $strMailExchanger); }