COM and .Net (Windows)

Einführung
Installation/Konfiguration
Vordefinierte Konstanten
Errors and error handling
Beispiele
- For Each
- Arrays and Array-style COM properties
COM Funktionen
- COM — COM-Klasse
- DOTNET — DOTNET class
- VARIANT — VARIANT Klasse
- com_addref — Erhöht den Referenzzähler der Komponente [veraltet, nicht mehr empfohlen]
- com_create_guid — Generate a globally unique identifier (GUID)
- com_event_sink — Connect events from a COM object to a PHP object
- com_get_active_object — Returns a handle to an already running instance of a COM object
- com_get — Liefert den Wert der Eigenschaft einer COM-Komponente [veraltet, nicht mehr empfohlen]
- com_invoke — Ruft eine Methode einer COM-Komponente auf [veraltet, nicht mehr empfohlen]
- com_isenum — Überprüft, ob ein COM-Objekt ein IEnumVariant-Interface für die Iteration besitzt [veraltet, nicht mehr empfohlen]
- com_load_typelib — Lädt eine Typelib
- com_load — Erstellt eine neue Referenz auf eine COM-Komponente [veraltet, nicht mehr empfohlen]
- com_message_pump — Process COM messages, sleeping for up to timeoutms milliseconds
- com_print_typeinfo — Print out a PHP class definition for a dispatchable interface
- com_propget — Alias von com_get
- com_propput — Alias von com_set
- com_propset — Alias von com_set
- com_release — Reduziert den Referenzzähler der Komponente [veraltet, nicht mehr empfohlen]
- com_set — Weist einer Eigenschaft einer COM-Komponente einen Wert zu
- variant_abs — Returns the absolute value of a variant
- variant_add — "Adds" two variant values together and returns the result
- variant_and — Performs a bitwise AND operation between two variants
- variant_cast — Convert a variant into a new variant object of another type
- variant_cat — concatenates two variant values together and returns the result
- variant_cmp — Compares two variants
- variant_date_from_timestamp — Returns a variant date representation of a Unix timestamp
- variant_date_to_timestamp — Converts a variant date/time value to Unix timestamp
- variant_div — Returns the result from dividing two variants
- variant_eqv — Performs a bitwise equivalence on two variants
- variant_fix — Returns the integer portion of a variant
- variant_get_type — Returns the type of a variant object
- variant_idiv — Converts variants to integers and then returns the result from dividing them
- variant_imp — Performs a bitwise implication on two variants
- variant_int — Returns the integer portion of a variant
- variant_mod — Divides two variants and returns only the remainder
- variant_mul — Multiplies the values of the two variants
- variant_neg — Performs logical negation on a variant
- variant_not — Performs bitwise not negation on a variant
- variant_or — Performs a logical disjunction on two variants
- variant_pow — Returns the result of performing the power function with two variants
- variant_round — Rounds a variant to the specified number of decimal places
- variant_set_type — Convert a variant into another type "in-place"
- variant_set — Assigns a new value for a variant object
- variant_sub — Subtracts the value of the right variant from the left variant value
- variant_xor — Performs a logical exclusion on two variants

5 BenutzerBeiträge:
- Beiträge aktualisieren...

Anonymous
23.09.2009 14:00


Add hyperlink at a Word Document's bookmark





<?php


// Create COM instance to word


       function clsMSWord($Visible = false)


       {


           $this->handle = new COM("word.application") or die("Unable to instanciate Word");


           $this->handle->Visible = $Visible;


       }





function WriteHyperlink($Bookmark,$Path,$Text)


       {


               $objBookmark = $this->handle->ActiveDocument->Bookmarks($Bookmark);


               $range = $objBookmark->Range;


               $objHyperlink = $this->handle->ActiveDocument->Hyperlinks;


               $objHyperlink->add($range,$Path,"","",$Text);


           


       }


?>

Dave Bachtel
27.05.2009 23:20


Hello everybody!



Here is some helpful advice for people attempting to use COM with Microsoft MapPoint 2006 or 2009 with PHP.



If you are using apache, it MUST be running under the same credentials as a desktop user that has already installed/run mappoint or modifiy the service and select the "Allow Service to Interact with Desktop" option.  Otherwise, it won't work due to the EULA popup having to be accepted.  Mappoint 2004 works just fine, this only applies to 2006 and 2009.



For troubleshooting, the error that appears in the System event viewer is:

The server {31851F82-AFE6-11D2-A3C9-00C04F72F340} did not register with DCOM within the required timeout.



The error generated by PHP, if you happen to get lucky and let the COM() function timeout by cranking up set_time_limit() timeout is:

<?php



set_time_limit(1000) ;



$mapoint =  new COM("MapPoint.Application") or die("Unable to instantiate Mappoint COM object");



?>

Generates:

Fatal error: Uncaught exception 'com_exception' with message 'Failed to create COM object `MapPoint.Application': Server execution failed ' in [somefile.php]:9 Stack trace: #0 [somefile.php](9): com->com('MapPoint.Applic...') #1 {main} thrown in [somefile.php] on line 9



Also, if you have multiple versions of MapPoint installed, you will need to run:

c:\path\to\mappoint\MapPoint.exe /registerserver 



(using the correct folder path) to select the right version of the com object to use.  Gooood luck!

acsandeep at gmail dot com
5.04.2009 7:40


If you are trying to get the properties of a Word document opened via COM object, you may need to define some constants in your script like so.





<?php


define('wdPropertyTitle', 1);


define('wdPropertySubject', 2);


define('wdPropertyAuthor', 3);


define('wdPropertyKeywords', 4);


define('wdPropertyComments', 5);


define('wdPropertyTemplate', 6);


define('wdPropertyLastAuthor', 7);





$word = new COM("word.application") or die ("Could not initialise MS Word object.");


$word->Documents->Open(realpath("Sample.doc"));


$Author = $word->ActiveDocument->BuiltInDocumentProperties(wdPropertyAuthor);





echo $Author;


?>

long2hu3 ATT yahoo DOTT com
18.03.2009 13:38


When you work with MS Excel, Word, ... and other applications, never forget that COM doesn’t know their predefined constants, thus if you want to do sth. that would look like this in VB:



With myRange.Borders(xlEdgeBottom)

    .LineStyle = xlContinuous

    .Weight = xlThin

    .ColorIndex = xlAutomatic

End With



you should either use numbers or define constants above, like this:



<?php



define('xlEdgeBottom', 9);

define('xlContinuous', 1);

define('xlThin', 2);

define('xlAutomatic', -4105);



$ex = new COM("Excel.Application", NULL, CP_UTF8) or Die ("Did not instantiate Excel");

$wb = $ex->Application->Workbooks->Add();

$ws = $wb->Worksheets(1);



$xra = $ws->Range("A1:A6");



$bs = $xra->Borders(xlEdgeBottom);

$bs->LineStyle = xlContinuous;

$bs->Weight = xlThin;

$bs->ColorIndex = xlAutomatic;



?>



It is pointless to try to use text strings, i.e.



<?php



$bs = $xra->Borders('xlEdgeBottom');

$bs->Weight = 'xlThin';



?>



this will cause an error: Unable to set property Weight of class Border ...

ilayansmano at gmail dot com
26.08.2008 10:39


Extracting text from Word Documents via PHP and COM





<?php


$word = new COM("word.application") or die ("Could not initialise MS Word object.");


$word->Documents->Open(realpath("Sample.doc"));





// Extract content.


$content = (string) $word->ActiveDocument->Content;





echo $content;





$word->ActiveDocument->Close(false);





$word->Quit();


$word = null;


unset($word);


?>

Ein Service von Reinhard Neidl - Webprogrammierung.

COM and .Net (Windows)