Open Excel from C# Application

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am exporting data to excel using ISAM Jet Database. and then invoking excel
using
Process.Start(fileName);

This works fine but if the excel file to which we are exporting is open then
the Excel does not open properly. Only the Title bar is loaded. and no sheets
are loaded. After that even if u close the application and try to reopen any
other file it will not open. I have to go to Task manager and then Kill
EXCEL.EXE Process then only excel will open again.
 
For these and other reasons, Excel should not be automated from the server.
You may try softartisans excel writer which is more suited for server-side
work at a grand or so a pop. Alternatively, the microsoft office web
components are *free and provide an excel object.

--
Regards,
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc
_________________________
 
Back
Top