public static DataTable ReadExcellSheet(QATestSetup testSetup) { try { DataTable dataSheet = new DataTable(); //OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + "; Jet OLEDB:Engine Type=5;Extended Properties=\"Excel 8.0;HDR=NO\""); OleDbConnection connection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + testSetup.fileName + ";Extended Properties=\"Excel 12.0;HDR=NO\""); connection.Open(); DataTable schema = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" }); string sheetName = schema.Rows[0].Field <string>("TABLE_NAME"); string select = "select * from [" + sheetName + "A" + testSetup.minRow.ToString() + ":D" + testSetup.maxRow.ToString() + "]"; OleDbDataAdapter sheetAdapter = new OleDbDataAdapter(select, connection); sheetAdapter.Fill(dataSheet); connection.Close(); return(dataSheet); } catch (Exception e) { MessageBox.Show("Can't read this file. Try using *.csv file. Exception:\r\n" + e.ToString()); return(null); } }
public static DataTable ReadCsv(QATestSetup testSetup) { DataTable dataTable = new DataTable(); StreamReader streamReader = new StreamReader(testSetup.fileName); int lineReads = 0; string[] columns = streamReader.ReadLine().Split(','); lineReads++; foreach (string s in columns) { dataTable.Columns.Add(s); } if (dataTable.Columns.Count != 4) { return(null); } while (!streamReader.EndOfStream) { string[] cells = Regex.Split(streamReader.ReadLine(), ",(?=(?:[^\"]*\"[^\"]*\")*[^\"]*$)"); if (cells.Count() != 4) { return(null); } lineReads++; DataRow row = dataTable.NewRow(); for (int i = 0; i < cells.Length; i++) { row[i] = cells[i]; } if ((lineReads >= testSetup.minRow) && (lineReads <= testSetup.maxRow)) { dataTable.Rows.Add(row); } } streamReader.Close(); return(dataTable); }
public QATest(Structs.TestPlan testPlan1, QATestSetup testSetup1) { testPlan = testPlan1;//new Structs.TestPlan(testPlan1.testSteps); testSetup = testSetup1; }
public OpActions(QATestSetup testSetup1) { testSetup = testSetup1; }
public Operations(QATestSetup testSetup1) { testSetup = testSetup1; //wskaźnik, bez kopiowania blurp hrpfr opActions = new OpActions(testSetup1); }