excel com component

  • Thread starter Thread starter Vijay
  • Start date Start date
V

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
 
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
 
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
 
Back
Top