Saving Excel File

[DPK]

Hello friends!!!

I made a prog. to make the excel. It is running well but when it saves the excel file it open the save dialog box to save the file becasue I am using SAVE function here instead of SAVE AS. So pls can anyone tell me how to use SAVE AS function in it so that i could give File name from my Programe. If I am using "Save As" Function then I am getting Error.

My be I am not giving appropriate parameters.

ERROR IS :

[ No overload for method 'SaveAs' takes '1' argument]

so pls help me here: My code is below:

protected void Button1_Click(object sender, EventArgs e)
{
Excel.Application xapp;
Excel.Workbook xwb;
Excel.Worksheet xws;
xapp = new Excel.Application();
xapp.Visible = true;
xwb = (Excel.Workbook)(xapp.Workbooks.Add(1));
xws = (Excel.Worksheet)xwb.ActiveSheet;
xws.Cells[1, 1] = "deepak";
xapp.Visible = true;
xapp.UserControl = true;
//xapp.Save(0); //this is working fine but showing save as DIALOG BOX
xws.SaveAs("c:\\temp\\MyFile.xls"); //this is giving me error
}

Thanks in advance!!!!!!!!!!

[predsedateli]

Hello!!
The problem is that SaveAs function, unlike the vb.net, in c# has more parameters.
Here is a piece of code that is working on my machine.

Excel.Application app;
            Excel.Workbook book;
            Excel.Worksheet  sheet;
            Excel.Range range;
 
            System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
            app = new Excel.Application();
            app.DisplayAlerts = false;
            app.Visible = true;
 
            book  = app.Workbooks.Add(@"C:\template.xlt");
            sheet = (Excel.Worksheet)book.Worksheets[1];
            app.Visible = true;
            sheet.Name = "1245";
            range = sheet.get_Range("A1","J100");
            range.Value2 = "test";
 
 
 
            while(Marshal.ReleaseComObject(sheet)>0);
            sheet = null;
             book.SaveAs(@"C:\rezult.xls",Excel.XlFileFormat.xlExcel9795, System.Reflection.Missing.Value, System.Reflection.Missing.Value, false, false, Excel.XlSaveAsAccessMode.xlNoChange , Excel.XlSaveConflictResolution.xlLocalSessionChanges, false, System.Reflection.Missing.Value, System.Reflection.Missing.Value, false);
            book.Close(false,System.Type.Missing, System.Type.Missing);
            while(Marshal.ReleaseComObject(book)>0); book = null;
 
            app.Quit();
            while(Marshal.ReleaseComObject(app)>0);   app=null;
 
            System.GC.Collect();
            System.GC.WaitForPendingFinalizers();

Hope this wil hepl.

[DPK]

Ofcourse Friend It did very much help.....
thank you very very much...!!!!!!!
:-)

Hello!!
The problem is that SaveAs function, unlike the vb.net, in c# has more parameters.
Here is a piece of code that is working on my machine.

Excel.Application app;
            Excel.Workbook book;
            Excel.Worksheet  sheet;
            Excel.Range range;
 
            System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
            app = new Excel.Application();
            app.DisplayAlerts = false;
            app.Visible = true;
 
            book  = app.Workbooks.Add(@"C:\template.xlt");
            sheet = (Excel.Worksheet)book.Worksheets[1];
            app.Visible = true;
            sheet.Name = "1245";
            range = sheet.get_Range("A1","J100");
            range.Value2 = "test";
 
 
 
            while(Marshal.ReleaseComObject(sheet)>0);
            sheet = null;
             book.SaveAs(@"C:\rezult.xls",Excel.XlFileFormat.xlExcel9795, System.Reflection.Missing.Value, System.Reflection.Missing.Value, false, false, Excel.XlSaveAsAccessMode.xlNoChange , Excel.XlSaveConflictResolution.xlLocalSessionChanges, false, System.Reflection.Missing.Value, System.Reflection.Missing.Value, false);
            book.Close(false,System.Type.Missing, System.Type.Missing);
            while(Marshal.ReleaseComObject(book)>0); book = null;
 
            app.Quit();
            while(Marshal.ReleaseComObject(app)>0);   app=null;
 
            System.GC.Collect();
            System.GC.WaitForPendingFinalizers();

Hope this wil hepl.