PHP COM::Get方法代码示例

 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);
 }