Creating Excel file in Windows service.

Question

0.00/5 (No votes)

See more:

Win2008-R2

, +

Hi all
Im fairly new to Programming ,Im developing a windows service that gets data from MS SQL database into a Datatable and then I create an excel file and adds the data from the Datatable into the excel file and then sends an email with the excel file as an attachment,I install the service on a Windows Server 2008 and I get this error from the Windows Service

System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
   at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache)
   at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache)
   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at System.Activator.CreateInstance(Type type)

Please help,Thanks in advance

Posted 9-Nov-12 6:18am

PaulaM

Updated 9-Nov-12 6:35am

fjdiewornncalwe

v2

Add a Solution

Comments

Maciej Los 9-Nov-12 12:36pm

Show us your code and mark a line with this error. Debug your program.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jason Gleim · Accepted Answer · 2012-11-09T06:37:00

You have built your service directly against the Excel libraries and you don't have excel installed on your server. ...at least not the same version you built your app against.

Generally, you don't want to do that anyway. Besides burning an expensive Office license, it will have scaling issues and probably security issues depending on how the service endpoint is deployed. If you want to do this, I suggest you either use the Tools For Office (which provides an interop layer that isolates your app from the Office libraries) or, better yet, use the OpenXML libraries that MS provides to create and manage the Excel file directly... without relying on actual Excel.

You didn't mention problems with the mailing part of it either, but I'm guessing you might have used the Outlook libraries since you use the Excel ones. If you run into issues there, I recommend the Redemption library. It makes e-mailing from code a breeze on Windows and bypasses all of the security roadblocks that Outlook puts in the way to sending e-mail from code.