Export to Excel API
 

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

Export to Excel API
 

Sorry for dupicate post.

Please ignore this message.


"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

Export to Excel API
 

The excel file format would be pretty difficult to create.

But you could create a comma separated value file (plain text file) in your
application.

If excel is on a pc, then the .csv extension will be owned by excel (if the user
hasn't changed it).

If you really want to try, you may want to review the posts by Tom Ogilvy in
this thread:

http://groups.google.co.uk/groups?th...gp13.phx .gbl

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

--

Dave Peterson

Export to Excel API
 

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

Export to Excel API
 

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