嗨,这是一个关于C语言如何处理COM互操作资源管理的示例。orginal source:
Excel.Application app = null;
Excel.Workbooks books = null;
Excel.Workbook book = null;
Excel.Sheets sheets = null;
Excel.Worksheet sheet = null;
Excel.Range range = null;
try
{
app = new Excel.Application();
books = app.Workbooks;
book = books.Add();
sheets = book.Sheets;
sheet = sheets.Add();
range = sheet.Range["A1"];
range.Value = "Lorem Ipsum";
book.SaveAs(@"C:\Temp\ExcelBook" + DateTime.Now.Millisecond + ".xlsx");
book.Close();
app.Quit();
}
finally
{
if (range != null) Marshal.ReleaseComObject(range);
if (sheet != null) Marshal.ReleaseComObject(sheet);
if (sheets != null) Marshal.ReleaseComObject(sheets);
if (book != null) Marshal.ReleaseComObject(book);
if (books != null) Marshal.ReleaseComObject(books);
if (app != null) Marshal.ReleaseComObject(app);
}
就我个人而言,我认为上述规定是合理和必要的。但它不是功能性的,也不是F型的。我最终在嵌套的try的不同级别定义了所有这些com变量…最后,尝试和…因为变量必须在尝试阻止之前定义,在最后和块中都存在清理代码。很乱。
我怎样才能在f中正确地实现同样的功能呢?有点讽刺的是,互联网上有很多例子解释了如何将f与interop结合使用,以此来展示f的威力。但是,它们都无法转换如何管理COM资源清理。
任何关于好的模式的建议都会得到评价。
最佳答案
您可以创建一个计算表达式,调用try/catch中的每个步骤,并在finally中释放。我们可以为create/finalize创建一个带有插件函数的生成器,这样我们就可以看到发生了什么。
type FinalizationBuilder(oncreate, onfinal) =
member __.Bind(m, f) =
oncreate(box m)
try
try
f m
with ex ->
Choice2Of2 ex.Message
finally
onfinal(box m)
member __.Return(m) = Choice1Of2 m
member __.Zero() = Choice1Of2()
然后,您需要一个COM工作流,它只在COM组件完成时释放它。
let com = new FinalizationBuilder(ignore, System.Runtime.InteropServices.Marshal.ReleaseComObject >> ignore)
你这样使用它:
[<EntryPoint>]
let main _ =
com {
let! app = new Excel.Application()
let! books = app.Workbooks
let! book = books.Add()
// ...
app.Quit()
} |> ignore
0
我没有安装excel,但我可以模拟它的异常和printfn。
let demo = new FinalizationBuilder(printfn "Created %A", printfn "Released %A")
[<EntryPoint>]
let main _ =
demo {
let! x = 1
let! y = 2
let! z = 3
return x + y + z
} |> printfn "Result: %A"
0
// Created 1
// Created 2
// Created 3
// Released 3
// Released 2
// Released 1
// Result: Choice1Of2 6
或例外情况:
[<EntryPoint>]
let main _ =
demo {
let! x = 1
let! y = 2
let! z = failwith "boom"
return x + y + z
} |> printfn "Result: %A"
0
// Created 1
// Created 2
// Released 2
// Released 1
// Result: Choice2Of2 "boom"
尽管如此,看起来这些都不是必要的。一个简单的
GC.Collect(); GC.WaitForPendingFinalizers()
可以解决这个问题,而不需要这些:https://stackoverflow.com/a/25135685/171121