Read data from excel file or csv in Custom keyword

[Arnel]

Hi Mehran,

You can refer to this links:

Loading test data file programmatically (Dynamic Test Data)

Hi Guys, Just wanted to share some ideas about test data. If your test data changes upon running your test automation it seems impossible to load it again or refresh it when you use the standard process of loading your test data file. To give you a scenario, assuming that you already loaded your test data(.csv, .xlsx) in the data files or you have already bind it in your test suite. When you execute your suite the automation will load the test data first before running your test steps or code.…

(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…

Hope that helps. . .