Dynamic path to generated Excel File

See more:

C#

hi friends,

i generate excel file using code given below but it's generate file in "c:\\" drive but i want to change location of file where it was generated so how can i change location where file is generated i use code given below.

Microsoft.Office.Interop.Excel.Application xlApp;

Microsoft.Office.Interop.Excel.Workbook xlWorkBook;

Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;

object misValue = System.Reflection.Missing.Value;



xlApp = new Microsoft.Office.Interop.Excel.ApplicationClass();

xlWorkBook = xlApp.Workbooks.Add(misValue);



xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

xlWorkSheet.Cells[1, 1] = "c:\\csharp-Excel.xls";



xlWorkBook.SaveAs("c:\\csharp-Excel.xls", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);

xlWorkBook.Close(true, misValue, misValue);

xlApp.Quit();



releaseObject(xlWorkSheet);

releaseObject(xlWorkBook);

releaseObject(xlApp);