Jump to content

Run a EXCEL MACROS


msumesh

Recommended Posts


Hi,

How to run a excel macros, using EXCEL.APPLICATION COM with IIS Server?

If i use EXCEL.SHEET COM object, i am getting error

Fatal error: Uncaught exception 'com_exception' with message 'Unable to lookup `application': Call was rejected by callee. ' in c:\Inetpub\wwwroot\excel.php:52 Stack trace: #0 c:\Inetpub\wwwroot\excel.php(52): Excel::XL() #1 c:\Inetpub\wwwroot\testing_com.php(22): Excel->XL('Umesh.xls', 'C:\', 'Sheet1') #2 {main} thrown in c:\Inetpub\wwwroot\excel.php on line 52

It works fine in apache server and where as in the IIS server it gives the above error.

Reproduce the code.
<?php
/* Test for Excel.php: A class for use with PHP4 scripts only*/
 
# Put the include file in your php include directory
require ("excel.php");
# Put the umesh.xls file in the document directory
$workbook = "Umesh.xls";
$pathin="C:\\";
$sheet = "Sheet1";

/* Instantiate Excel and open the test file. */

#Instantiate Excel
    $E = new Excel;

#Open the workbook
    $E->XL($workbook,$pathin,$sheet);
    Print "Test starting..<br>";
# Print to browser

# Run the MACRO : Helloworld
$E->runmacro($workbook,"HelloWorldMacro");


# Close the Workbook
$E->closexl();
unset ($E);
?>


Kindly suggest me.. ???


Thanks in advance.



Link to comment
https://forums.phpfreaks.com/topic/20692-run-a-excel-macros/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.