fetch the data in previous row

[Shirley]

I am creating a test with coded steps using C#.

1. In coded step, I need to fetch the data in certain row which is before the current row, I want to  know how to get the data.
2. The time stored in Exel is type of String, how to convert it to the type of Date which is needed in the Application .

Thank you ver much!

[Plamen]

Hi Shirley,

If I understand correctly your scenario, you need to get the data from a specific row of an Excel data source and convert it to type DateTime. 
 
Here is one way to do this by using Microsoft.Office.Interop.Excel namespace. First you need to create a method in the code behind to read the Excel file:

public string ReadingExcel(int certainRowNumber)
{
    string input = @"C:\Users\peykov\Desktop\foo.xlsx";
    Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
    Microsoft.Office.Interop.Excel.Workbook inputBook = app.Workbooks.Open(input, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
    Microsoft.Office.Interop.Excel.Worksheet inputSheet = (Microsoft.Office.Interop.Excel.Worksheet)((inputBook.Worksheets).get_Item(1));

    string value = ((Microsoft.Office.Interop.Excel.Range)inputSheet.Cells[certainRowNumber, 1]).Text as string;
    app.Quit();
    app = null;

    return value;
}

Now, in a Coded step you need to call this method and pass as parameter the number of the row you want. When the value of the row is returned, you can convert it to type DateTime and use it in your application.

[CodedStep(@"MyCodedStep")]
public void WebTest_CodedStep()
{
    string str = ReadingExcel(5);
    DateTime dt = Convert.ToDateTime(str);
}

Hope this helps!
 

Best wishes,
Plamen
the Telerik team