Excel data fetch in katalon

[rakesh.gohel]

How to fetch excel data and store in web site.

[Arnel]

Hi Rakesh,

See this link below. This may help you.

(TEST DATA) Define specific Excel Sheets to get Excel Values

Hi there, I’m going to share something that might help you when it comes to automation which involves excel file as your test data and defining the “SHEETS” you prefer to make your test data even more dynamic. We have a class named ExcelData but it doesn’t allow us to define what sheet the automation will penetrate. See this link for the ExcelData class for your reference: Index (Katalon Studio API Specification) Meaning the ExcelData is only good for one sheet which is the default sheet. And…

Try the code. It gets the data from the excel file, and you can pass or compare the returned data to your website.

Hope that helps. . .