msumesh Posted September 14, 2006 Share Posted September 14, 2006 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 52It 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.