Create an Excel Workbook using DOTNET.
<?php
$full_assembly_string = 'Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c';
$full_class_name = 'Microsoft.Office.Interop.Excel.ApplicationClass';
$e = new DOTNET($full_assembly_string, $full_class_name);
$wb = $e->workbooks->add();
$Precios = $wb->Worksheets(1);
$Precios->Name = 'Precios';
$Venta = $wb->Worksheets(2);
$Venta->Name = 'Venta';
$Tons = $wb->Worksheets(3);
$Tons->Name = 'Tons';
$Meses = Array('2014-01', '2014-02', '2014-03', '2014-04', '2014-05', '2014-06', '2014-07', '2014-08', '2014-09', '2014-10', '2014-11', '2014-12');
foreach ($Meses as $Numero => $Mes) {
$Precios->Range("A" . ($Numero+1))->Value = $Mes;
}
$wb->SaveAs('c:\temp\Meta.2014.05.xlsx');
$wb->Close();
?>
Go to c:\windows\assembly to know what value to put in $full_assembly_string.
If you don't know the assembly, use http://www.red-gate.com/products/dotnet-development/reflector/ to browse it, use what you learn there to fill $full_class_name.
Enjoy,
Ricardo.
La classe dotnet
(PHP 4 >= 4.1.0, PHP 5, PHP 7, PHP 8)
Introduction
La classe dotnet vous autorise à instancier une classe depuis un ensemble .NET et d'appeler et accéder à ses propriétés, si la classe et les méthodes et les propriétés sont » visible pour COM.
Ni l'instantiation de classes static ni l'appel de méthodes statique est
supporté.
L'instanciation de classes génériques telles que
System.Collections.Generic.List n'est pas non plus prise en charge.
Quelque classes .Net n'implémente pas IDispatch, donc bien qu'elles peuvent être instancié, appeller des méthodes ou accéder aux propriétés sur ces classes n'est pas supporté.
Note:
Vous devez installer le moteur d'exécution .Net sur votre serveur web pour tirer avantage de cette fonctionnalité.
Note:
Antérieur à PHP 8.0.0, le framework .Net 4.0 et ultérieurs ne sont pas supporté par la classe dotnet. Si des assemblages ont été régistré avec regasm.exe, les classes peuvent être instanciées en tant qu'objets com, cependant. À partir de PHP 8.0.0, le framework .Net 4.0 et les versions ultérieures sont supportés via la directive php.ini com.dotnet_version.
Synopsis de la classe
/* Méthodes */
}Méthodes surchargées
L'objet retourné est un objet surchargé, ceci signifie que PHP ne voit pas les méthodes fixé comme il le fait avec les classes normales ; à la place tout accès de propriété ou méthode sont passés à travers COM et à partir de là à DOTNET. Dans d'autres mots, l'objet .Net est mappé via la couche d'interopérabilité COM fournie par le moteur d'exécution .Net.
Une fois que vous avez crée un objet dotnet, PHP le traite de façon identique à n'importe quel autre objet COM ; les mêmes règles s'appliquent.
Exemples dotnet
Exemple #1 Exemple dotnet
<?php
$stack = new dotnet("mscorlib", "System.Collections.Stack");
$stack->Push(".Net");
$stack->Push("Hello ");
echo $stack->Pop() . $stack->Pop();
?>Sommaire
- dotnet::__construct — Constructeur de la classe dotnet
add a note
User Contributed Notes 12 notes
ricardopsj at gmail dot com ¶
10 years ago
juan156_elias at gmail dot com ¶
9 years ago
Using COM and DOTNET directly is quite a nightmare. DOTNET only allows you to target .Net 3.5 and below, and all the binaries need to be COM Visible. This basically means that you will need to write your own .Net binaries for everything, at least wrappers.
There is a library out there (NetPhp) built on top of the COM class that will solve all these issues, so you can get code like this:
$manager = new \NetPhp\Core\NetManager();
$manager->RegisterAssembly('mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089', 'mscorlib');
$manager->RegisterClass('mscorlib', 'System.IO.File', 'File');
$manager->RegisterClass('mscorlib', 'System.IO.FileOptions', 'FileOptions');
$file = $manager->Create('mscorlib', 'File');
$fileoptions = $manager->Create('mscorlib', 'System.IO.FileOptions')->Enum('Encrypted');
$file->Create("C:\\www\\prueba.tres", 2048, $fileoptions);
Bitterblue ¶
6 years ago
I worked with this the last few days and figured it out.
On stack overflow: https://stackoverflow.com/a/51541801/1442225
jan dot zahradnik at data3s dot com ¶
10 years ago
PHP searches only GAC for .NET 2.0 runtime, so your DLL has to be targeted 2.0 - 3.5 framework.
Also it recognize only classes, not stucts, so you can't instantiate DateTime for example.
jcastromail at yahoo dot es ¶
8 years ago
using dotnet with visual studio 2015 (and net framework 4.6.1 but its the same with others).
1) In visual studio 2015, created a library project (in this case a C#)
2) Double click in the project -> build events -> post build
"C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.6 Tools\gacutil.exe" /i "$(TargetPath)"
When the project its compiled, it adds to the GAC automatically. Please changes the bin folder according your installation.
3) in tools -> External tools, add the next external tool
Title: Get Qualified Assembly Name
Command: Powershell.exe
Arguments: -command "[System.Reflection.AssemblyName]::GetAssemblyName(\"$(TargetPath)\").FullName"
User Output Windows : checks
4) run tools -> Get qualified Assembly Name and checks the output windows
5) Creates the next class (Class1 may be its already creates)
namespace ClassLibrary2 // <-- changes it.
{
public class Class1
{
public string Ping(string t1,string t2)
{
return "pong "+t1+t2;
}
}
}
6) in php
$full="ClassLibrary2, Version=1.0.0.0, Culture=neutral, PublicKeyToken=746927f9726d7222"; // its from the output windows
$class = 'ClassLibrary2.Class1'; // its the namespace and the class.
$stack = new DOTNET($full,$class);
$r1="hello";
$r2="world";
echo $stack->Ping($r1,$r2);
IMPORTANT NOTE: PHP "caches" the dll library, so every time that the dll library is compiled, the php service should be restarted (restart the apache service).
IMPORTANT NOTE 2: May be you should run Visual Studio as an Administrator.
m dot atifmajeed at gmail dot com ¶
9 years ago
How to use donet class for creating object of parameterized constructor
http://php.net/manual/en/class.dotnet.php
private SGF ingerPrintManager m_FPM; //member variable
SGFPMDeviceName device_name = SGFPMDeviceName.DEV_ FDU02 ;
m_FPM = new SGF ingerPrintManager (device_name);
sandips (yardi) ¶
13 years ago
exercise to try different type of method signature and calling them in php.
VB.net Code
Public Class Class1
Public Function SayHello(ByVal input As String) As String
Return "Php input: " & input & "</BR>Dot net library said- 'Hello'"
End Function
Public Function ConcatArray(ByVal Values As Object()) As String
Dim ret As String = String.Empty
For Each sval As Object In Values
ret = ret & sval.ToString & " "
Next
Return ret.Substring(1, ret.Length - 1)
End Function
Public Function ReturnObject(ByVal FirstName As String, ByVal LastName As String) As Name
Dim obj As New Name
obj.FirstName = FirstName
obj.LastName = LastName
Return obj
End Function
'To explain Byref doesn't work with php
Public Function CallByRef(ByRef value As String) As String
value = "Value to ByRef parameter set in dot net."
Return "ByRef CallByRef() method called."
End Function
End Class
Public Class Name
Public FirstName As String = String.Empty
Public LastName As String = String.Empty
End Class
Php code to test .net library
<?php
$class1 = new DOTNET("DotNetTest,"
."Version=1.0.0.0,"
."Culture=neutral,"
."PublicKeyToken=6675daefc27eafc4"
,"DotNetTest.Class1");
echo $class1->SayHello("Hi PHP!!!!");
echo "</P>";
$parameter[0] = 12345;
$parameter[1] = "MyString";
$parameter[2] = false;
$ret = $class1 -> ConcatArray($parameter);
echo $ret;
echo "</P>";
$Obj = $class1 -> ReturnObject("Sandip","Shimpi");
echo $Obj->FirstName." ".$Obj->LastName;
echo "</P>";
$myByRef = "";
echo "Value of ByRef Variable before calling .net CallByRef() method: ".$myByRef;
echo "</BR>";
echo $class1 -> CallByRef($myByRef);
echo "</BR>";
echo "Now value of ByRef Variable: ".$myByRef;
echo $myByRef;
?>
Anonymous ¶
14 years ago
As suggested before, you'll likely have to use a full assembly string including the assembly name, the assembly version (not the dll file version), the culture, and the public key token. Otherwise, you'll get a 'file not found' catchable error. To quickly find this on your own system to get the ball rolling, open C:\Windows\assembly in explorer (not in cmd as that shows a different view), scroll down the list until you find the assembly you want to work with, hover the mouse over it, and the tooltip shows the exact string to use (though processcorArchitecture if shown is optional). You'll have to use .net utilities or other methods to automate collecting this info on other machines.
You'll also have to use the fully-qualified class name. In other words, if you want to use the 'Form' class within 'System.Windows.Forms', you have to use the full class hierarchy 'System.Windows.Forms.Form'. Otherwise you'll get an unhelpful 'Failed to instantiate .Net object' catchable error.
The following example shows the correct syntax to use the 'Form' class to pop up a blank form from php-cli, which can be used in leu of many Windows GUI PHP extensions out there. Replace Version with your local version, and PublicKeyToken with your own local key token.
<?php
$full_assembly_string = 'System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=a8425bc35256e463';
$full_class_name = 'System.Windows.Forms.Form';
$form = new DOTNET($full_assembly_string, $full_class_name);
// code to add buttons, menus, text, etc
$form->Show();
$form_event = '';
while($form_event !== 'close') {
// handle form functions and events
}
?>
murat at muratyaman dot co dot uk ¶
14 years ago
First, I hit the same mine:
"... Failed to instantiate .Net object [Unwrapped, QI for IDispatch] [0x80004002] No such interface supported ..."
In order to load the assembly and class in it successfully, I had to change my AssemblyInfo.cs file regarding the visibility of the types in it.
// some code above
// This sets the default COM visibility of types in the assembly to invisible.
// If you need to expose a type to COM, use [ComVisible(true)] on that type.
[assembly: ComVisible(true)]
// some code below
kschroeder at mirageworks dot com ¶
15 years ago
In order to find out what the PublicKeyToken value is, open up Explorer and go to c:\windows\assembly. In that directory you will see all of the registered assemblies along with their PublicKeyToken value.
m holmes at windowlogic dot com dot au ¶
15 years ago
For strongly-named NET assemblies that are registered in the GAC, you can just use the assembly name
e.g: $x = new DOTNET ("myAssembly", "myClass");
For strongly-named NET assemblies that aren't registered in the GAC, you need to use the full assembly string
e.g. $x = new DOTNET('myAssembly, Version=X.X.X.X, Culture=neutral, PublicKeyToken=ZZZZZZZZZZZZ', 'myClass');
You can't instantiate assemblies that haven't been strongly named.
"Strongly named" means that the assembly has a public key. To strongly name your own classes in Visual Studio, go to the Signing tab in the project properties and click the 'sign the assembly' box and choose a key file name.
To register an assembly in the GAC, there are various tools around to do that, but the easiest method is to drag-and-drop the compiled assembly into c:\windows\assembly using windows explorer (a shell extension is installed by default that handles registering dragged files).
sam at bitopia dot co dot uk ¶
16 years ago
If you want to load any other assembly apart from mscorlib, you'll need to include it like the following
$x = new DOTNET('The.Assembly.Name, Version=X.X.X.X, Culture=neutral, PublicKeyToken=ZZZZZZZZZZZZ', 'The.Class.Name');
Replace all relevant details.
