473,503 Members | 1,834 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

asp.net and excel.application in interop

Neo
Hello All,

I would like to ask has anybody successfully used excel interop code
in asp.net?

I am getting following error.

Retrieving the COM class factory for component with CLSID
{00024500-0000-0000-C000-000000000046} failed due to the following
error: 80040154.

Error is given at the point where excel.application object is created.

I tried giving permission in DCOM but no luck.

Any help will be appreciated.

-Thanks
Pravin

Feb 16 '07 #1
8 7456
"Neo" <pr*********@gmail.comwrote in message
news:11*********************@j27g2000cwj.googlegro ups.com...
Any help will be appreciated.
This is one of the many errors that you are likely to encounter when trying
to automate Office apps server-side.

It simply isn't designed to be used like this - Microsoft themselves
strongly advise against it, and won't actually support any solution which
uses it:
http://support.microsoft.com/default...US;q257757#kb2

What are you actually trying to do...?
Feb 16 '07 #2
DCOM config is the way to go, as you knew, but perhaps you didn't get
it set right: http://www.devcity.net/Articles/239/2/article.aspx

Alternatively you have to allow the ASP.NET process to run under a
user context that already has permission to do so...

--scott

On Feb 16, 7:56 am, "Neo" <pravinsa...@gmail.comwrote:
Hello All,

I would like to ask has anybody successfully usedexcelinterop code
inasp.net?

I am getting following error.

Retrieving the COM class factory for component with CLSID
{00024500-0000-0000-C000-000000000046} failed due to the following
error: 80040154.

Error is given at the point whereexcel.application object is created.

I tried giving permission in DCOM but no luck.

Any help will be appreciated.

-Thanks
Pravin

Feb 16 '07 #3
Neo
I changed that setting already still it's giving problem.
On Feb 16, 12:26 pm, s...@rox.ca wrote:
DCOM config is the way to go, as you knew, but perhaps you didn't get
it set right: http://www.devcity.net/Articles/239/2/article.aspx

Alternatively you have to allow the ASP.NET process to run under a
user context that already has permission to do so...

--scott

On Feb 16, 7:56 am, "Neo" <pravinsa...@gmail.comwrote:
Hello All,
I would like to ask has anybody successfully usedexcelinterop code
inasp.net?
I am getting following error.
Retrieving the COM class factory for component with CLSID
{00024500-0000-0000-C000-000000000046} failed due to the following
error: 80040154.
Error is given at the point whereexcel.application object is created.
I tried giving permission in DCOM but no luck.
Any help will be appreciated.
-Thanks
Pravin

Feb 16 '07 #4
Neo
I am trying to read user uploaded excel file on server in asp.net.

On Feb 16, 11:05 am, "Mark Rae" <m...@markNOSPAMrae.comwrote:
"Neo" <pravinsa...@gmail.comwrote in message

news:11*********************@j27g2000cwj.googlegro ups.com...
Any help will be appreciated.

This is one of the many errors that you are likely to encounter when trying
to automate Office apps server-side.

It simply isn't designed to be used like this - Microsoft themselves
strongly advise against it, and won't actually support any solution which
uses it:http://support.microsoft.com/default...US;q257757#kb2

What are you actually trying to do...?

Feb 16 '07 #5
"Neo" <pr*********@gmail.comwrote in message
news:11********************@a75g2000cwd.googlegrou ps.com...
>I changed that setting already still it's giving problem.
Ignore the previous post. This will almost certainly not work - it's simply
not designed to work like this...
Feb 16 '07 #6
"Neo" <pr*********@gmail.comwrote in message
news:11**********************@l53g2000cwa.googlegr oups.com...
>I am trying to read user uploaded excel file on server in asp.net.
http://www.google.co.uk/search?sourc...2eNET%22+Excel

http://www.aspose.com/Products/Aspos...s/Default.aspx
Feb 16 '07 #7
Neo
On Feb 16, 4:25 pm, "Mark Rae" <m...@markNOSPAMrae.comwrote:
"Neo" <pravinsa...@gmail.comwrote in message

news:11**********************@l53g2000cwa.googlegr oups.com...
I am trying to read user uploaded excel file on server in asp.net.

http://www.google.co.uk/search?sourc...F-8&rls=GGLG,G...

http://www.aspose.com/Products/Aspos...s/Default.aspx

ADO.net is not of any help since it has problem of reading cell data
more than 255 char.

Feb 19 '07 #8
"Neo" <pr*********@gmail.comwrote in message
news:11**********************@p10g2000cwp.googlegr oups.com...
ADO.net is not of any help since it has problem of reading cell data
more than 255 char.
Well-documented issue - easily fixed:
http://support.microsoft.com/kb/189897/EN-US/
Feb 19 '07 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3015
by: Bernd Muent | last post by:
Hi together, I am using the following code in Visual Basic to open Word or Excel applications: Word: Dim w As Word.Application w = CType(CreateObject("Word.application"), Word.Application)...
4
3114
by: goonsquad | last post by:
I'm writing an Excel Automation app and I'm running to a problem early on with what should be a basic step. Dim oExcel As Object Dim oBook As Object Dim oSheet As Object Dim oRng As...
3
10699
by: James Wong | last post by:
Dear all, I have an old VB6 application which can create and access Excel object. The basic definition statements are as follows: Dim appExcel As Object Dim wkb1 As Excel.Workbook Dim wks1...
3
7415
by: Jennyfer Barco | last post by:
Hello, I have a question, how can I open Microsoft Excel from .NET. I only need to open a new file in Excel and paste some information and set the Microsoft Excel as the enabled aplication, so the...
0
1884
by: dleh | last post by:
I have been tasked with producing a server application that will convert excel files to html. I have no experience of developing under Windows, (but plenty of UNIX/C++ experience) but I picked...
5
25662
by: kewalmehra | last post by:
Hi All, I have a requirement of saving Excel files as HTML using C#. I have managed to write code for saving as HTLM file. however this seems to be not working in the once perticular case . ...
5
3134
by: Mike in Santa Rosa | last post by:
I'm trying to get a simple c# app built that can launch/manipulate an excel workbook, sheet. I've chased down several examples and can't any of them to work. So I must be doing somethnig obviouslt...
2
10336
by: Jacob.Bruxer | last post by:
Hi everyone, I'm having trouble opening space delimited textfiles in Excel from Visual Basic.net. I'm able to control, open and modify Excel files from Visual Basic, so my Excel reference seems...
2
4914
by: Nicholas Dreyer | last post by:
The following error Run-time exception thrown : System.Runtime.InteropServices.COMException - Error loading type library/DLL. happens while running the code listed at the bottom of this...
0
2677
by: jwmaiden | last post by:
Have an application that opens up a webbrowser control to display data in an Excel spreadsheet (using VB.NET in VS 2005). No problem with opening the spreadsheet or displaying the data, but I'm...
0
7274
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
6984
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7453
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5576
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5005
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4670
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3162
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
1
732
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
377
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.