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 addSheet() { worksheet = worksheets.invoke("Add", Type.Missing, Type.Missing, Type.Missing, Type.Missing); }