Katalon writing data to excel

Web Testing
30

@grylion54
I revised the code you edited. Finally, It worked. but there is a vacant row in my excel. How can I fix it?

image
image667×624 23.2 KB

import static com.kms.katalon.core.checkpoint.CheckpointFactory.findCheckpoint
import static com.kms.katalon.core.testcase.TestCaseFactory.findTestCase
import static com.kms.katalon.core.testdata.TestDataFactory.findTestData
import static com.kms.katalon.core.testobject.ObjectRepository.findTestObject
import static com.kms.katalon.core.testobject.ObjectRepository.findWindowsObject
import com.kms.katalon.core.checkpoint.Checkpoint as Checkpoint
import com.kms.katalon.core.cucumber.keyword.CucumberBuiltinKeywords as CucumberKW
import com.kms.katalon.core.mobile.keyword.MobileBuiltInKeywords as Mobile
import com.kms.katalon.core.model.FailureHandling as FailureHandling
import com.kms.katalon.core.testcase.TestCase as TestCase
import com.kms.katalon.core.testdata.TestData as TestData
import com.kms.katalon.core.testng.keyword.TestNGBuiltinKeywords as TestNGKW
import com.kms.katalon.core.testobject.TestObject as TestObject
import com.kms.katalon.core.webservice.keyword.WSBuiltInKeywords as WS
import com.kms.katalon.core.webui.keyword.WebUiBuiltInKeywords as WebUI
import com.kms.katalon.core.windows.keyword.WindowsBuiltinKeywords as Windows
import internal.GlobalVariable as GlobalVariable
import org.openqa.selenium.Keys as Keys

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
"and any others you may need"

WebUI.openBrowser('')

'Stick to this page(for Download + Upload)'
WebUI.navigateToUrl('https://kusa89.jp/ss/index_comb_ss.html')

'ID'
WebUI.setText(findTestObject('Object Repository/Page_SSCSVNumatcheck/input__f_itcu'), 'hojun.lee')

'PASSWORD'
WebUI.setEncryptedText(findTestObject('Object Repository/Page_SSCSVNumatcheck/input__f_itcp'), '90Dp6xqc0oO/YegCFWVM4w==')

WebUI.sendKeys(findTestObject('Object Repository/Page_SSCSVNumatcheck/input__f_itcp'), Keys.chord(Keys.ENTER))

WebUI.click(findTestObject('Object Repository/Page_SSCSVNumatcheck/a_KICS'))

WebUI.click(findTestObject('Object Repository/Page_SSCSVNumatcheck/a_'))

WebUI.click(findTestObject('Object Repository/Page_SSCSVNumatcheck/a_PonyoPonyo on KICS V2'))

int newRow = 1
gTestIdPathWay =  "C:\\Users\\hojun.lee\\Katalon Studio\\excel.xlsx"

for (def row = 1; row <= findTestData('New').getRowNumbers(); row++) {
	
	WebUI.click(findTestObject('Page_SSCSVNumatcheck/input_SS_SSnum'))

	WebUI.setText(findTestObject('Object Repository/Page_SSCSVNumatcheck/input_SS_SSnum'), findTestData('NEW').getValue(
			'a', row))

	WebUI.uploadFile(findTestObject('Object Repository/Page_SSCSVNumatcheck/input_SSCSV_csvFileSS'), findTestData('NEW').getValue(
			'c', row))

	WebUI.waitForAlert(5)

	WebUI.uploadFile(findTestObject('uploadObject/Page_SSCSVNumatcheck/input_CSV_csvFileNP'), findTestData('NEW').getValue(
			'd', row))

	WebUI.waitForAlert(5)

	WebUI.click(findTestObject('Object Repository/Page_SSCSVNumatcheck/input_SS_button'))

	WebUI.waitForPageLoad(60)

/*①From now new page will be open*/

	WebUI.switchToWindowIndex(1) //switches to 2nd window
	secondUrl = WebUI.getUrl()
	println("secondUrl: " + secondUrl)

	WebUI.waitForAlert(5)

	FileInputStream fis = new FileInputStream (gTestIdPathWay);
	XSSFWorkbook workbook = new XSSFWorkbook (fis);

	XSSFSheet sheet = workbook.getSheet("Sheet1");
	
	Row excelRow = sheet.createRow(newRow );
	Cell cell = excelRow.createCell(0);
	cell.setCellValue(secondUrl);

	FileOutputStream fos = new FileOutputStream(gTestIdPathWay);
	workbook.write(fos);
	fos.close();
	fis.close();

	newRow += 3
	/*Turn to the First page, then loop ①～③ process */
	WebUI.switchToWindowIndex(0) //switches to 2nd window
	println("secondUrl: " + secondUrl)
	

	WebUI.closeWindowIndex(1)
	WebUI.waitForAlert(5)
}