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);
}
