Silverlight Excel Release process

How to release COM objects in Silverlight 4 這個網上有個例子

 

    private void Button_Click(object sender, RoutedEventArgs e)
    {
        using (dynamic app = AutomationFactory.CreateObject("Excel.Application"))
        {
            using (dynamic book = app.Workbooks.Add())
            {
                using (dynamic sheet = app.ActiveSheet())
                {

}
                book.Close();
            }
            app.Quit();
        }; 
        GC.Collect();
    }
這個是可以回收資源的. 但是如果把 dynamic book = app.Workbooks.Add() 該為 dynamic workBooks = excel.Workbooks._Open(@"D:\test.xls", Type.Missing,
                    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing)

這時名次運行完, 都會有一個Excel進程不能釋放.(勉強可以接受). 以後再試試其它方法.