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 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 setValue(string range, object[,] values) { var rg = worksheet.get("Range", range, Type.Missing); rg.set("Value", values); }