excel com component

[Vijay]

Hi,

I am using a com component Microsoft excel 11.0 liabry in asp.net appliction
and before using i have converted it into .NET component.

But when control comes to following statement:

excelworkbook = excelobject.workbooks.open("filepath")

it fails it is not giving any error but it fails.

Please assist

Vijay

 

[Mark Rae]

I am using a com component Microsoft excel 11.0 liabry in asp.net
appliction

Why are you doing this...?

Please assist

You cannot do server-side automation of Microsoft Office. It is not designed
to work this way, and Microsoft will not support you if you even try:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2

Luckily, there is no requirement whatsoever to do this.

What are your requirements...?

 

[Steve C. Orr [MCSD, MVP, CSM, ASP Insider]]

COM automation from ASP.NET is not recommended or supported.

Here are some other ways to create Excel output:
http://SteveOrr.net/articles/ExcelExport.aspx

Here's a free control that can help with Excel output (and Word, PowerPoint,
and WordPerfect output):
http://SteveOrr.net/articles/ExportPanel.aspx

Or You could open an existing Excel file and modify it as an ADO.NET data
source:
http://groups.google.com/group/micr...14d90e974e5/571439ff12d7473d#571439ff12d7473d

And here are a couple good 3rd party products that can make your chores
easy:
http://SteveOrr.net/reviews/AsposeExcel.aspx
http://SteveOrr.net/reviews/OfficeWriter.aspx

 

[Alvin Bruney [MVP]]

The usual reason for the error is that the com object is not registered, or
registered incorrectly on the target machine. Re-registering the object
fixes that problem. You should heed the warning from steve about server
interop though.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley