Forum Discussion
A_Roskoshnyi
5 years agoContributor
Take a look at this example (C#Script):
var fileName = "Y:\\Automation\\Automation\\Testscenario's\\Timings.xlsx";
var excel = Sys["OleObject"]("Excel.Application");
excel["Workbooks"]["Open"](fileName);
excel["Sheets"]("YOUR_SHEET_NAME")["Select"]();
excel["Cells"](1,1)["Font"]["Color"] = dotNET["System_Drawing"]["ColorTranslator"]["ToOle"](dotNET["System_Drawing"]["Color"]["Red"]);
excel["Cells"](1,1)["Value"] = feature["Tags"]["Item"](0);
excel["Cells"](1,2)["Font"]["Color"] = dotNET["System_Drawing"]["ColorTranslator"]["ToOle"](dotNET["System_Drawing"]["Color"]["DarkOrange"]);
excel["Cells"](1,2)["Value"] = aqDateTime["Today"]();
excel["ActiveWorkbook"]["Save"]();
excel["Quit"]();sonya_m
Alumni
5 years agoThanks a lot, everyone! What a great discussion.
hannecroonen how did you solve this in the end? Please share🙂