Hi there. I'm wondering if you ever solved the issue you posted about here:
http://bytes.com/topic/c-sharp/answe...called-service
If so, I'd love to hear how you fixed it up...I'm really struggling with this....
rusidoitu4
Last Activity: Feb 24 '09, 06:37 PM
Joined: Jan 15 '09
Location:
-
rusidoitu4 replied to C#-SERVICE: ...Excel.Application.Workbooks.Open fails when called from a Servicein C SharpI switched to OLEDB to get the job done. I extract the Excel contents to a tabbed file per worksheet then read those files. Here are the connection strings for any interested-
...Code:switch ( Path.GetExtension( Filename ).ToLower() ) { case ".xlsx": connString = "Provider=Microsoft.ACE.OLEDB.12.0;" +Last edited by Frinavale; Feb 24 '09, 07:21 PM. Reason: Added [code] tags: Please post code between [code] [/code] tags -
rusidoitu4 replied to C#-SERVICE: ...Excel.Application.Workbooks.Open fails when called from a Servicein C SharpHaving the same issue. If the code is run from a desktop app it works fine. It can't open the file in the windows service. Procmon doesn't show any errors or anything. I've tinkered with the Microsoft Excel Application DCOM permissions and identity and nothing has worked (or changed). The OS is Server 2008 64 bit. Excel is 2007. I've also tinkered with all the params to the Workbooks.Open call to no avail.
This is a showstopper...Leave a comment:
No activity results to display
Leave a comment: