static void Main(string[] args) { if (args.Length != 1) { return; } var sttms = new List <RPAStatement>(); sttms = readXls(args[0]); foreach (var itm in sttms) { itm.exec(); } Console.WriteLine("処理が完了しました。"); Console.ReadLine(); RPAStatement.MyDispose(); }
static List <RPAStatement> readXls(string pasu) { var ret = new List <RPAStatement>(); //wbよみこみ using (var wb = new XLWorkbook(pasu)) { var ws = wb.Worksheets.Where(s => s.Name == "Sheet1").FirstOrDefault(); //一行目はヘッダ for (int idx = 2; idx < ws.RowCount(); idx++) { var row = ws.Row(idx); var itm = new RPAStatement(); itm.id = row.Cell(1).Value.ToString();//id if (itm.id.Equals("")) { break; } itm.line = row.RowNumber();// itm.operation1 = row.Cell(2).Value.ToString(); itm.operation2 = row.Cell(3).Value.ToString(); itm.operation3 = row.Cell(4).Value.ToString(); itm.argument1 = row.Cell(5).Value.ToString(); itm.argument2 = row.Cell(6).Value.ToString(); itm.argument3 = row.Cell(7).Value.ToString(); itm.variable = row.Cell(8).Value.ToString(); itm.memo = row.Cell(9).Value.ToString(); ret.Add(itm); } return(ret); } }