public static Object[][] GetTestData(String testName, String suiteFilePath)
{
string[][] resultData;
DataTable dt = new DataTable();
ExcelHelper eh = new ExcelHelper(suiteFilePath);
int rowId = eh.GetRowNumber("Data", 1, testName);
int colHeaderRowNumber = rowId + 1;
int dataStartRowNumber = rowId + 2;
int i = 0;
while (!eh.GetCellData("Data", 1, i + dataStartRowNumber).Equals(""))
{
i++;
}
int dataEndRowNumber = dataStartRowNumber + i - 1;
int j = 1;
while (!eh.GetCellData("Data", j, colHeaderRowNumber).Equals(""))
{
j++;
}
resultData = new string[i][];
Object[][] newResultData = new Object[i][];
int r = 0, c = 0;
int dataEndColNumber = j - 1;
for (i = dataStartRowNumber; i <= dataEndRowNumber; i++, r++)
{
c = 0;
resultData[r] = new string[j - 1];
newResultData[r] = new Object[1];
Dictionary <String, String> dict = new Dictionary <string, string>();
for (j = 1; j <= dataEndColNumber; j++, c++)
{
resultData[r][c] = eh.GetCellData("Data", j, i);
dict.Add(eh.GetCellData("Data", j, colHeaderRowNumber), eh.GetCellData("Data", j, i));
newResultData[r][0] = dict;
}
}
//return resultData;
return(newResultData);
}
public static Object[][] GetTestData(String testName, String suiteFilePath)
{
string[][] resultData;
DataTable dt = new DataTable();
ExcelHelper eh = new ExcelHelper(suiteFilePath);
int rowId = eh.GetRowNumber("Data", 1, testName);
int colHeaderRowNumber = rowId + 1;
int dataStartRowNumber = rowId + 2;
int i = 0;
while(!eh.GetCellData("Data", 1, i+dataStartRowNumber).Equals(""))
{
i++;
}
int dataEndRowNumber = dataStartRowNumber + i-1;
int j = 1;
while(!eh.GetCellData("Data", j, colHeaderRowNumber).Equals(""))
{
j++;
}
resultData = new string[i][];
Object[][] newResultData = new Object[i][];
int r=0, c=0;
int dataEndColNumber = j-1;
for(i=dataStartRowNumber;i<=dataEndRowNumber;i++, r++)
{
c = 0;
resultData[r] = new string[j - 1];
newResultData[r] = new Object[1];
Dictionary<String, String> dict = new Dictionary<string, string>();
for (j = 1; j <= dataEndColNumber; j++, c++)
{
resultData[r][c] = eh.GetCellData("Data", j, i);
dict.Add(eh.GetCellData("Data", j, colHeaderRowNumber), eh.GetCellData("Data", j, i));
newResultData[r][0] = dict;
}
}
//return resultData;
return newResultData;
}