opening an exel file in a c# program

[arian]

Hi

I am getting the following error while opening the exel file. I am sure the path and the file name is correct.

'G:\myCodeProgram\swiming\beforeMatch\Files\Input\arrange.xlsx' could not be found. Check the spelling of the file name, and verify that the file location is correct.

If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted.

System.Runtime.InteropServices.COMException was unhandled
  HelpLink="C:\\Program Files (x86)\\Microsoft Office\\Office12\\1033\\XLMAIN11.CHM"
  Message="'G:\\myCodeProgram\\swiming\\beforeMatch\\Files\\Input\arrange.xlsx' could not be found. Check the spelling of the file name, and verify that the file location is correct.\n\nIf you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted."
  Source="Microsoft Office Excel"
  ErrorCode=-2146827284
  StackTrace:
       at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad)
       at matchProvider.mainInfo.button1_Click(Object sender, EventArgs e) in G:\myCodeProgram\swiming\beforeMatch\1\matchProvider\matchProvider\mainInfo.cs:line 116
       at System.Windows.Forms.Control.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ButtonBase.WndProc(Message& m)
       at System.Windows.Forms.Button.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
       at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
       at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
       at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
       at matchProvider.Program.Main() in G:\myCodeProgram\swiming\beforeMatch\1\matchProvider\matchProvider\Program.cs:line 18
       at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
       at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()
  InnerException:

I use visual Studio 2008 , win7 (86X)

and here is the code

object opt = System.Reflection.Missing.Value;
                Excel.Application excel = new Excel.ApplicationClass();
                Excel.Sheets Sheets;
                Excel.Workbook wArrange;

                wArrange = excel.Workbooks.Open(path+"\arrange.xlsx", opt, false, opt, opt, opt, true, opt, opt, opt, opt, opt, opt, opt, opt);
                Sheets = wArrange.Worksheets;
                teamNum = wArrange.Sheets.Count;

                wArrange.Close(true, opt, opt);

Can you plz tell me what is wrong?

Tnx
arian

[C_ntua]

path + "\\arrange.xlsx"

EDIT: Look at the original error message more closely. It has \\ except for the last one which has single.

[arian]

What a big/stupid mistake I have done!

Thanks a lot for your help

[VirtualAce]

What a big/stupid mistake I have done!

Nah. Just an oversight. It happens to all of us.

[indigo0086]

You can also use the @"path1\path2" syntax, which escapes characters within the string automatically. Or use Path.Combine()

[pianorain]

Or use Path.Combine()

QFT. I got tired of making the same error as the OP; I always use Path.Combine() now. The @"" syntax is fine if you have a hardcoded path, but if you've got to piece parts together, Path.Combine() is the way to go.