ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   asp.net Office Automation - in or out of process (https://www.excelbanter.com/excel-programming/296490-asp-net-office-automation-out-process.html)

David Laub

asp.net Office Automation - in or out of process
 
When I use Office Automation in an asp.net application, are the Office
libraries invoked in or out of process?

Thanks



Rob Bovey

asp.net Office Automation - in or out of process
 
"David Laub" wrote in message
...
When I use Office Automation in an asp.net application, are the Office
libraries invoked in or out of process?


When you automate any executible (as opposed to a DLL) it will always
run out of process.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *




David Laub

asp.net Office Automation - in or out of process
 
So, would I gain performance by accessing the Excel spreadsheet data using
ADO?

Thanks again

"Rob Bovey" wrote in message
...
"David Laub" wrote in message
...
When I use Office Automation in an asp.net application, are the Office
libraries invoked in or out of process?


When you automate any executible (as opposed to a DLL) it will always
run out of process.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *






Rob Bovey

asp.net Office Automation - in or out of process
 
"David Laub" wrote in message
...
So, would I gain performance by accessing the Excel spreadsheet data using
ADO?


Hi David,

For a server application my first reaction is definitely. You just can't
say for sure until you test it both ways, though.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Rob Bovey" wrote in message
...
"David Laub" wrote in message
...
When I use Office Automation in an asp.net application, are the Office
libraries invoked in or out of process?


When you automate any executible (as opposed to a DLL) it will

always
run out of process.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *








David Laub

asp.net Office Automation - in or out of process
 
Thanks! I'll try both ways...
"Rob Bovey" wrote in message
...
"David Laub" wrote in message
...
So, would I gain performance by accessing the Excel spreadsheet data

using
ADO?


Hi David,

For a server application my first reaction is definitely. You just

can't
say for sure until you test it both ways, though.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Rob Bovey" wrote in message
...
"David Laub" wrote in message
...
When I use Office Automation in an asp.net application, are the

Office
libraries invoked in or out of process?

When you automate any executible (as opposed to a DLL) it will

always
run out of process.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *











All times are GMT +1. The time now is 06:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com