Posibble to store all data under one excel sheet?

Product Forums Katalon Studio
,
21

hi,

NO, this is only made for my project :slight_smile: , excel plugin in Katalon Plugin Store is something else
differences, don’t know not used Plugin at all

22

alright, me too, try not to use katalon built in to avoid limited support. java/apache library easier for me to get info from internet.

23

Here is my solution finally works.

////Keyword///
package test

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.cucumber.keyword.CucumberBuiltinKeywords as CucumberKW
import com.kms.katalon.core.mobile.keyword.MobileBuiltInKeywords as Mobile
import com.kms.katalon.core.model.FailureHandling
import com.kms.katalon.core.testcase.TestCase
import com.kms.katalon.core.testdata.TestData
import com.kms.katalon.core.testobject.TestObject
import com.kms.katalon.core.webservice.keyword.WSBuiltInKeywords as WS
import com.kms.katalon.core.webui.keyword.WebUiBuiltInKeywords as WebUI

import internal.GlobalVariable

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import com.kms.katalon.core.configuration.RunConfiguration
import java.io.File


public class readexcel {


	//method defined for reading a cell
	@Keyword
	public String ReadCellData(int vRow, int vColumn)
	{
		String value=null;          //variable for storing the cell value
		Workbook wb=null;           //initialize Workbook null
		try
		{
			//reading data from a file in the form of bytes
			FileInputStream fis=new FileInputStream(RunConfiguration.getProjectDir() + "/Data Files/testmatrix.xlsx");
			//constructs an XSSFWorkbook object, by buffering the whole stream into the memory
			wb=new XSSFWorkbook(fis);
		}
		catch(FileNotFoundException e)
		{
			e.printStackTrace();
		}
		catch(IOException e1)
		{
			e1.printStackTrace();
		}
		Sheet sheet=wb.getSheetAt(0);   //getting the XSSFSheet object at given index
		Row row=sheet.getRow(vRow); //returns the logical row
		Cell cell=row.getCell(vColumn); //getting the cell representing the given column
		//value=cell.getStringCellValue();    //getting cell value
		//return value;               //returns the cell value
	}
}

/////test case////
import com.kms.katalon.core.webservice.keyword.WSBuiltInKeywords as WS
import internal.GlobalVariable
import com.kms.katalon.core.util.KeywordUtil
import static com.kms.katalon.core.testobject.ObjectRepository.findTestObject
import static org.assertj.core.api.Assertions.*
import com.kms.katalon.core.testobject.RequestObject as RequestObject
import com.kms.katalon.core.testobject.impl.HttpTextBodyContent as HttpTextBodyContent
import com.kms.katalon.core.webservice.keyword.WSBuiltInKeywords as WS
import com.kms.katalon.core.webui.keyword.WebUiBuiltInKeywords as WebUI
import groovy.json.JsonOutput as JsonOutput


//read excel cell C9, ignore first row column A1. (int vRow, int vColumn)
def exceldata = CustomKeywords.'test.readexcel.ReadCellData'(9, 2)

String jsondata = JsonOutput.prettyPrint(exceldata.toString())

println(jsondata)

WebUI.delay(1)

//call the object and post the above data as API HTTP request body
def post= ((findTestObject('Object Repository/Web Service Request/test-service')) as RequestObject)

post.setBodyContent(new HttpTextBodyContent(jsondata))

WebUI.delay(2)

//POST and verification
def response = WS.sendRequestAndVerify(post)

println(response.statusCode)

assert response.getStatusCode() == 201
1 Like