public void TestFixtureSetUp() { Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US"); var type = Type.GetTypeFromProgID("Excel.Application"); var instance = Activator.CreateInstance(type); excel = new COM(instance); //_xl.set("Visible", true); workbooks = excel.get("Workbooks"); workbook = workbooks.invoke("Add", Type.Missing); worksheets = workbook.get("Sheets"); worksheet = workbook.get("ActiveSheet"); }
public void TestFixtureTearDown() { workbook.invoke("Close", false, Type.Missing, Type.Missing); excel.invoke("Quit"); worksheet.Dispose(); workbook.Dispose(); workbooks.Dispose(); excel.Dispose(); foreach (var p in System.Diagnostics.Process.GetProcessesByName("excel")) { p.Kill(); p.Dispose(); } }
public void addSheet() { worksheet = worksheets.invoke("Add", Type.Missing, Type.Missing, Type.Missing, Type.Missing); }