How to retrive Data in Number format from excel

Feedback & Reviews Feature Requests
1

I am using Data FIles to get data from Excel.

image
image727×320 2.82 KB

I have some values that are in Numbers format, I need to retrive it as Integer format, but all I am getting is String format.
Type casting is not an option in my scenario. I have already use that variable value in numerous places. I cannot just go every where and add type casting.

2

You have the options of importing data from Excel as either string or double:

Row row = sheet.getRow(1);
Cell cell = row.getCell(0);
GlobalVariable.gLastName = cell.getStringCellValue();

or

Row row = sheet.getRow(1);
Cell cell = row.getCell(0);
double money = cell.getNumericCellValue();

You can use the double version and implicitly downcast the value to an int, like below.

Row row = sheet.getRow(1);
Cell cell = row.getCell(0);
int shortTimeOut = cell.getNumericCellValue();

If you want to get to Integer format (the object not the primitive), then you will have to type cast.

3

Hello helpdesk,
Can you please provide the answer that uses Katalon Recorder commands?
Thank you.

4

Hi, check this: Please help on Katalon Recorder Data-Driven using CSV