c# - 动态加载程序集

Question

我需要动态加载一个程序集。目前我正在使用“Microsoft.Office.Microsoft.Office.Interop.dll”。我需要打开一个 excel 文件并从中获取工作表和数据。谁能告诉我该怎么做？

Assembly SampleAssembly = Assembly
          .Load("Microsoft.Office.Interop.Excel, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c");

if (SampleAssembly != null)
{
    Type type = SampleAssembly.GetType("Microsoft.Office.Interop.Excel.ApplicationClass");
    Object AppClass = Activator.CreateInstance(type);

   //How will I get ApplicationClass object and Workbooks objects here?
}

Answer 1

利用动态:

 Type type = SampleAssembly.GetTypes().Single(t => t.Name == "ApplicationClass");
 dynamic appClass = Activator.CreateInstance(type);

 var workbook = appClass.Workbooks.Open("C:\\test.csv");
 var worksheet = workbook.Worksheets[1];