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. Link to comment https://forums.phpfreaks.com/topic/20692-run-a-excel-macros/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.