Write in excel using katalon studio

Archive
,
1

I’m new with katalon, but I have a problem i hop some can help with,
i want write in excel using katalon studio i created a simple testcase:

WebUI.openBrowser(‘’)

WebUI.navigateToUrl(‘https://katalon-demo-cura.herokuapp.com/’)
String result = WebUI.getText(findTestObject(‘Object Repository/Page_CURA Healthcare Service/a_Make Appointment’))

CustomKeywords.‘excel.myPack.demoKey’(result)

WebUI.closeBrowser()

and i also create a keyword:

package excel

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 com.kms.katalon.core.annotation.Keyword
import com.kms.katalon.core.checkpoint.Checkpoint
import com.kms.katalon.core.checkpoint.CheckpointFactory
import com.kms.katalon.core.mobile.keyword.MobileBuiltInKeywords
import com.kms.katalon.core.model.FailureHandling
import com.kms.katalon.core.testcase.TestCase
import com.kms.katalon.core.testcase.TestCaseFactory
import com.kms.katalon.core.testdata.TestData
import com.kms.katalon.core.testdata.TestDataFactory
import com.kms.katalon.core.testobject.ObjectRepository
import com.kms.katalon.core.testobject.TestObject
import com.kms.katalon.core.webservice.keyword.WSBuiltInKeywords
import com.kms.katalon.core.webui.keyword.WebUiBuiltInKeywords
import internal.GlobalVariable
import MobileBuiltInKeywords as Mobile
import WSBuiltInKeywords as WS
import WebUiBuiltInKeywords as WebUI
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFCell
import org.apache.poi.xssf.usermodel.XSSFCellStyle
import org.apache.poi.xssf.usermodel.XSSFRow
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class myPack{

private  static int i=0;

@Keyword
public static void demoKey(String name,String Column_Name) throws IOException{
	FileInputStream fis = new FileInputStream("D:\\Testdata.xlsx");
	XSSFWorkbook workbook = new XSSFWorkbook(fis);
	XSSFSheet sheet = workbook.getSheet("Sheet1");
	int rowCount = i;
	if (Column_Name=='Credential1'){
		Row row = sheet.getRow(rowCount+1);
		Cell cell = row.createCell(2,0);
		cell.setCellType(cell.CELL_TYPE_STRING);
		cell.setCellValue(name);
	}



	FileOutputStream fos = new FileOutputStream("D:\\Testdata.xlsx");
	workbook.write(fos);
	fos.close();
}

}

When i run the testcase, But i get these error :

No signature of method: excel.myPack.demoKey() is applicable for argument types: (java.lang.String) values: [Make Appointment]
Possible solutions: demoKey(java.lang.String, java.lang.String)

What could be the problem?

2

You miss one parameter

3

thanks !

i modified keyword code
public class myPack{

		@Keyword
		public void demoKey(String name) throws IOException{
			
		  FileInputStream fis = new FileInputStream("D:\\Testdata.xlsx");
		  XSSFWorkbook workbook = new XSSFWorkbook(fis);
		   
		  XSSFSheet sheet = workbook.getSheet("Sheet1");
		  int rowCount = sheet.getLastRowNum()-sheet.getFirstRowNum();
		  Row row = sheet.createRow(rowCount+1);
		  Cell cell = row.createCell(0);
		  cell.setCellType(cell.CELL_TYPE_STRING);
		  cell.setCellValue(name);
		  FileOutputStream fos = new FileOutputStream("D:\\Testdata.xlsx");
		  workbook.write(fos);
		  fos.close();
		
	
		
		
	}

}

but still have this error:
Cannot invoke method getLastRowNum() on null object

4

Your sheet Sheet1 seems not to exist

5

problem solved ,the test case run successfuly thank you so much for your help i really appreciate it