I am trying to access a excel application using COM object but i am unable to access it. OS: windows, Php5.2.5

Fatal error: Uncaught exception 'com_exception' with message 'Failed to create COM object `Excel.application': Invalid syntax ' in C:\xampp\htdocs\xls-xml\xls2xml.php:7 Stack trace: #0 C:\xampp\htdocs\xls-xml\xls2xml.php(7): com->com('Excel.applicati...') #1 {main} thrown in C:\xampp\htdocs\xls-xml\xls2xml.php on line 7

I have even tried with the below given source code by niroshan but it still displays the same error.

Thanks in advance

    I have OpenOffice installed in my system but not MS-Office, if it is OpenOffice is there any difference in accessing the OpenOffice.org Calc application.

    Thanks in advance

      bhavani,

      Please create a NEW topic for future reference, rather than replying to a topic marked 'Resolved'. We had this particular item resolved for the person who had created the topic.

      But to answer your question,

      OpenOffice is NOT Microsoft Excel, therefor the COM Objects are not alike.

      There are PHP Classes to create/manipulate/open ODS files, here

      You can read the OOo Developer API, I was able to find an example for OOo Writer, in order to implement FULL functionality, you are far better off implementing a Java wrapper to do the work using the API, or if you are skilled in C++, you can write it in the form of an extension.

      If you intend on creating and editing Microsoft's Excel (XLS / XLSX) Format(s) then I would recommend a proper library, for XLSX (XML based spreadsheets) see: http://www.phpexcel.net/.

      For XLS, etc I have found mostly commercial solutions, my company purchased one that suited our needs but was over $8,000.

      Also noteworthy, Microsoft strongly recommends against using Excel in this manner (COM for server apps) either way.

      I would recommend starting a new topic explaining htat you have OpenOffice and explaining what you want to do with it, to see if anyone can help you.

      Most people won't read this topic because it's marked Resolved, we mark the threads this way so that those who visit the board to help others know what they do/dont need to look at.

        Write a Reply...