//package Utilityfunction;
import java.io.File;
import java.io.IOException;
import java.text.SimpleDateFormat;
import java.util.Locale;
import javax.swing.JOptionPane;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.firefox.FirefoxDriver;
import jxl.*;
import jxl.write.*;
import jxl.write.Number;
import jxl.write.biff.RowsExceededException;
import jxl.read.biff.BiffException;
import jxl.write.*;
import Utilityfunction.File_StringCheck;
import java.util.Date;
public class Test
{
public static void main(String[] args) throws BiffException, IOException, WriteException
{
//
String sSrc="D:\\Selenium\\test\\test.xls";
String sDest="D:\\Selenium\\test\\test_"+Time_stamp()+".xls";
int iRows,i,j,iCols;
String[] aRes;
Label Llabel;
Workbook workbook1 = Workbook.getWorkbook(new File(sSrc));
iRows=workbook1.getSheet(0).getRows();//-1;
iCols=workbook1.getSheet(0).getColumns();//-1; //getRows()-1;
String[][] App_data=new String[iRows][iCols];
Sheet oSheet1=workbook1.getSheet(0);
for ( i=0 ; i<=oSheet1.getRows()-1;i++)
{
for ( j=0 ; j<=oSheet1.getColumns()-1;j++)
{
App_data[i][j]=oSheet1.getCell(j, i).getContents();
}
}
workbook1.close();
WebDriver driver= new FirefoxDriver();
driver.get("https://play.google.com/store");
for ( i=1 ; i<=iRows-1 ;i++)
{
driver.findElement(By.id("search-text")).sendKeys(App_data[i][0]);//("nfs");
driver.findElement(By.id("search-button")).click();
aRes=(mData(driver)).split(";");
for (j=0 ; j<=aRes.length-1 ; j++)
{
App_data[i][j+1]=aRes[j];
}
driver.findElement(By.id("search-text")).clear();
}
WritableWorkbook workbook2 = Workbook.createWorkbook(new File(sDest));//, workbook1);
WritableSheet oSheet2 = workbook2.createSheet("First Sheet", 0);
for ( i=0 ; i<=App_data.length-1;i++)
{
for ( j=0 ; j<=App_data[0].length-1;j++)
{
Llabel = new Label(j, i, App_data[i][j]);
oSheet2.addCell(Llabel);
}
}
workbook2.write();
workbook2.close();
System.out.println("over");
driver.quit();
System.exit(0);
}
public static String Time_stamp() //TimeSatmp
{
//java.util.Date date = new java.util.Date();
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd HH:mm:ss");
Date date = new Date();
return (((dateFormat.format(date)).replace("/", "_")).replace(":", "_")).replace(" ", "_");
}
public static String mData(WebDriver oBrowser)
{
if (oBrowser.getCurrentUrl().contains("https://play.google.com/store/search") == false)
{
System.out.println("Not in the website");
return "0";
}
String sApp_name=oBrowser.findElement(By.xpath("//li[1]/div/div[2]/a")).getText();
String sStars=oBrowser.findElement(By.xpath("//li[1]/div/div/div/div/div")).getAttribute("title");
String sDownloads=oBrowser.findElement(By.xpath("//li[1]/div/div[2]/div[2]//span")).getText();
return (sApp_name+";"+sStars+";"+sDownloads);
}
}