Excel with C# connection

Question

I have this code

exapplication = new Excel.Application();
Excel.Workbook WB = exapplication.ThisWorkbook;
WB.Connections.AddFromFile("C:\test.odc");

and when I trying to compile it, it gives me the following exception:

Exception from HRESULT: 0x800A03EC

Your string literal doesn't escape the backslash character - is this a typo, or could that be your problem? — Bradley Smith
– Bradley Smith, Commented Jan 25, 2011 at 6:37

Oscar Mederos · Accepted Answer · 2011-01-25 06:53:20Z

1

You should replace

WB.Connections.AddFromFile("C:\test.odc");

by

WB.Connections.AddFromFile(@"C:\test.odc");

although I don't really think that exception is because of this.

answered Jan 25, 2011 at 6:53

Oscar Mederos

30k25 gold badges91 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Or without the literal, escape like this: WB.Connections.AddFromFile("C:\\test.odc");