Export data

[venugqtp]

Try Below, In your code you are trying to export xls in 2 instance with same name so it over writes the 1st instance

Code:

Datatable.Value (1,1) = "Login"
Datatable.Value (2,1) = "Login Page - Calender View Page"
Datatable.Value (3,1) = TimeTakenA2
Datatable.Value (4,1) = TimeTakenA1
Datatable.Value (5,1) = Calender_Page
'Navigating to Customer Tab
StarttimeB1 =Timer
Browser("Browser").Page("Page").Link("Customers").Click
If Browser("Browser").Page("Page").WebElement("Find a Customer").Exist Then
Print "Customer Tab Clicked"
End If
EndtimeB1 = Timer
TimeTakenB1 = StarttimeB1 - EndtimeB1
Customer_Page = Browser("Browser").Page("Page").GetROProperty("URL")
Datatable.Value (1,2) = "Click Customer Tab"
Datatable.Value (2,2) = "Calender View Page - Search Customer"
Datatable.Value (3,2) = TimeTakenA2
Datatable.Value (4,2) = TimeTakenA1
Datatable.Value (5,2) = Customer_Page