He is asking if this is how "commercial" software works -- he describes how
software found on the web does it (using Automation). The answer is No -
"commercial" software writes to the Excel file spec, since as you say,
automation/COM requires Excel to be present.

--
Regards,
Tom Ogilvy

"Jon Peltier" wrote in message
...
Ong -

It seems to me that this approach would not work unless Excel is installed
on the
host machine. How else does the software activate the Excel object?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

ong wrote:

Hi all,

I found that in many reporting software, they also have a built-in
function
to export their report in Excel format, no matter the PC have Excel
installed
or not. I searched in web and found that most of the sample code is
creating
the Excel COM object (Excel.Application, Excel.Workbook etc....) and
then
write their contect into each cell and finally close/release all the
reference. However, is it the way those reporting software I have
mentioned
before export their report into Excel format ?
If not, how they can do that ? Is it there is some API which I can call
to
achieve it ?

Thanks in advance

ong