The file name or path doesn't exist or used by other program while writing Excel file [duplicate]

Question

I am trying to create an Excel file and write some data to it. Here is the code I am using.

using excel = Microsoft.Office.Interop.Excel;
excel.Application xlapp;
excel.Workbook xlworkbook;
excel.Worksheet xlworksheet;
object misvalue = System.Reflection.Missing.Value;

xlapp = new excel.ApplicationClass();
xlworkbook = xlapp.Workbooks.Add(misvalue);

xlworksheet = (excel.Worksheet)xlworkbook.Worksheets.get_Item(1);
xlworksheet.Cells[1, 1] = "Muneeb Hassan Soomro";
xlworkbook.SaveAs("csharp-excelwrite.xls",excel.XlFileFormat.xlWorkbookNormal,misvalue,misvalue,misvalue,misvalue,excel.XlSaveAsAccessMode.xlExclusive,misvalue,misvalue,misvalue,misvalue,misvalue);
//xlworkbook.SaveAs("csharp-Excel.xls", excel.XlFileFormat.xlWorkbookNormal);
xlworkbook.Close(true, misvalue, misvalue);
xlapp.Quit();

I get an exception on the xlworkbook.saveas() call. says:

The file name or path doesn't exist or used by other program

What i am doing wrong here?

yes i am getting exception on the function of saveas. I am actually learning how to write a file in excel! — Muneeb Hassan
– Muneeb Hassan, Commented Jul 11, 2013 at 6:45
@Meiyoki i have already exported the data to csv file. But want to learn excel file writing using interop library. — Muneeb Hassan
– Muneeb Hassan, Commented Jul 11, 2013 at 6:57

cremor · Accepted Answer · 2013-07-11 07:44:27Z

2

So from one of your comments on another answer I finally got the exception text (This information should have been included in the question!)

The file name or path doesn't exist or used by other program

The solution should be simple: Specify a full path in the SaveAs call, not only a file name. How should Excel know in which folder it should save the file otherwise?

answered Jul 11, 2013 at 7:44

cremor

6,9351 gold badge34 silver badges78 bronze badges

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

4 Comments

Rezoan Over a year ago

you are right @cremon

Muneeb Hassan Over a year ago

@cremor you are right, i gave the path and now it is making an excel file!

Rezoan Over a year ago

You should mark it as answer so that other having the same issue can find it helpful @Muneeb Hassan

Muneeb Hassan Over a year ago

i was about to mark it but went away! Although thanks for reminding!

dvjanm · Accepted Answer · 2013-07-11 07:02:54Z

1

Try to change this line

xlworkbook = xlapp.Workbooks.Add(misvalue);

to this line:

xlworkbook = xlapp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);

and the SaveAs:

workBook.SaveAs("csharp-excelwrite.xls", XlFileFormat.xlWorkbookNormal, Missing.Value, Missing.Value, Missing.Value, Missing.Value, XlSaveAsAccessMode.xlNoChange, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

answered Jul 11, 2013 at 7:02

dvjanm

2,3821 gold badge32 silver badges46 bronze badges

3 Comments

Muneeb Hassan Over a year ago

still getting exception The file name or path doesn't exist or used by other program

dvjanm Over a year ago

Maybe your file is open by Excel, in task panel in the processes tab close all of the open tasks and change this line: xlworkbook.Close(true, misvalue, misvalue); to this: workBook.Close(true, "csharp-excelwrite.xls", null);

sqladmin Over a year ago

this solution is working - tested just now

Community · Accepted Answer · 2017-05-23 10:32:08Z

0

So i suggest you to use excellibrary for Excel file writing

You can find a details on Create Excel (.XLS and .XLSX) file from C#

edited May 23, 2017 at 10:32

CommunityBot

11 silver badge

answered Jul 11, 2013 at 6:54

Rezoan

1,7973 gold badges23 silver badges54 bronze badges

2 Comments

Muneeb Hassan Over a year ago

i have to add this project to my project to use its functionality?

Rezoan Over a year ago

you just need to add the reference of this dll in your project.

sqladmin · Accepted Answer · 2013-07-11 07:26:39Z

0

try this

object format = excel.XlFileFormat.xlWorkbookNormal;
object sv = excel.XlSaveAsAccessMode.xlExclusive;
object filename = "csharp-excelwrite.xls";

xlworkbook.SaveAs(ref filename,ref format,
ref misvalue,ref misvalue,ref misvalue,
ref misvalue,ref sv,ref misvalue,ref misvalue,
ref misvalue,ref misvalue,ref misvalue);

it is working for me with Word application for example

object readOnly = isReadonly;
object isVisible = true;
object missing = WordConst.Missing;
wordDoc = wordApp.Documents.Open(ref fileName, ref missing,
                          ref readOnly, ref missing, ref missing, ref missing,
                          ref missing, ref missing, ref missing, ref missing,
                          ref missing, ref isVisible, ref missing, ref missing, 
                          ref missing, ref missing);

edited Jul 11, 2013 at 7:26

answered Jul 11, 2013 at 7:06

sqladmin

2,2092 gold badges17 silver badges12 bronze badges

2 Comments

Muneeb Hassan Over a year ago

giving error. Argument should not be passed with the ref key word.

sqladmin Over a year ago

well, it works with MS Word in my application

Collectives™ on Stack Overflow

The file name or path doesn't exist or used by other program while writing Excel file [duplicate]

4 Answers 4

4 Comments

3 Comments

2 Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

3 Comments

2 Comments

2 Comments

Linked

Related