How to properly save excel file, which was generated using c#?

Question

So I use standard interface.

using Excel = Microsoft.Office.Interop.Excel;

// file save function

 xlWorkBook.SaveAs("Bar Charts.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
 xlWorkBook.Close(true, misValue, misValue);
 xlApp.Quit();

Everything is fine, but file appears here C:\Users\Dex\Documents. How can I change file destination true way? Don't want to move it after all.

Function described here http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.saveas.aspx, but there is no such parameter.

Provide the fully qualified path?

dreamlax
– dreamlax

2013-12-11 09:58:31 +00:00
Commented Dec 11, 2013 at 9:58 — dreamlax
– dreamlax, Commented Dec 11, 2013 at 9:58

dreamlax · Accepted Answer · 2013-12-11 10:05:14Z

5

The link you provided contains the answer:

Filename

The name of the file to be saved. You can include a full path; if you do not, Microsoft Office Excel saves the file in the current folder.

Use @"C:\Another\Folder\Bar Charts.xls" instead of just "Bar Charts.xls". You can also use the Path.Combine if you already have your folder in another string:

xlWorkBook.SaveAs(Path.Combine(folder, "Bar Charts.xls"), ...

edited Dec 11, 2013 at 10:05

answered Dec 11, 2013 at 10:00

dreamlax

95.7k31 gold badges166 silver badges211 bronze badges

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

Comments

I A Khan · Accepted Answer · 2013-12-16 15:22:03Z

2

Try This :

xlWorkBook.SaveAs(@"YourPath" + "\Bar Charts.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
 xlWorkBook.Close(true, misValue, misValue);
 xlApp.Quit();

edited Dec 16, 2013 at 15:22

answered Dec 11, 2013 at 10:02

I A Khan

8,92716 gold badges57 silver badges78 bronze badges

Comments

shabz · Accepted Answer · 2024-08-08 16:07:57Z

0

private static DateTime csvtime = DateTime.Now;
    private static string time = csvtime.ToString("dd-MM-yyyy");
private static string filename = @"C:\users\User\desktop\yourfolder_"+time+".xls";
xlWorkBook.SaveAs(filename, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
 xlWorkBook.Close(true, misValue, misValue);
 xlApp.Quit();

edited Aug 8, 2024 at 16:07

answered Aug 8, 2024 at 16:03

shabz

93 bronze badges

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

How to properly save excel file, which was generated using c#?

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related