public override DataTransactionResponse Run() { var dataTransactionResponse = new DataTransactionResponse(); using (var reader = new StreamReader(Url)) { var counter = 0; while (!reader.EndOfStream) { var line = reader.ReadLine(); if (counter > 0 && line != null) { var response = CheckAndInsertData(line.Split(';'), counter); dataTransactionResponse.Messages.Add(response); } counter++; } } return dataTransactionResponse; }
public override DataTransactionResponse Run() { var dataTransactionResponse = new DataTransactionResponse(); XSSFWorkbook xssfWorkbook; using (var file = new FileStream(Url, FileMode.Open, FileAccess.Read)) { xssfWorkbook = new XSSFWorkbook(file); } var sheet = xssfWorkbook.GetSheetAt(0); var rows = sheet.GetRowEnumerator(); rows.MoveNext(); while (rows.MoveNext()) { IRow row = (XSSFRow) rows.Current; var response = CheckAndInsertData(row); dataTransactionResponse.Messages.Add(response); } xssfWorkbook = null; sheet = null; return dataTransactionResponse; }