将数据写入Excel

[imhongbo]

         Excel.Application app = new Excel.ApplicationClass();  
        app.Application.Workbooks.Add(true); 
        app.Cells[2, 1] = yhm;
        app.Cells[2,2] = time;
        Excel.Worksheet worksheet = (Excel.Worksheet) app.ActiveSheet;

        worksheet.SaveAs("D:\\My Documents\\Visual Studio 2008\\WebSites\\WebSite3\\myexcel.xlsx", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);

        worksheet._SaveAs();

        app.Quit();   
        

这个功能每次运行都会另外创建一个excel ，怎么可以每次运行都能让数据追加到指定的excel中呢？

[cwp9868cws]

呵没用过，帮你顶顶

[deppon001]

应该 worksheet.SaveAs有很多方法，可以用