Hello everyone,
I unfortunately can not program and use the KatalonRecorder for testing. However, I need your support here and there.
I have managed to have data read from an excel spreadsheet and written to an online form and submit the form. Now I have to read a value from this excel table, enter it in the form and copy the result back into the excel table i.e. into the CSV file in a certain column in the corresponding row. Example:
File number | Case_ID
14323
66563
88787
and so on. The file number is available, the corresponding case ID is to be determined on the page using the search button and then copied into the corresponding line. Can you help me please?
Katalon Recorder includes the following script which shows you how to save data into a CSV file, but it wonât let you save it to a specific row or column, itâll just add it to the end of the file
To load the data it from the CSV file you have more controls by comparison.
âloadVarsâ allows you to open the CSV file and extract data (by row names) one line at a time.
âstoreCsvâ allows you to open the CSV file and fetch data from a specific line and specific row, by comparison (which you can then use with while / endwhile loops, to run through things).
If you search on the forum, or just use the built-in âReferenceâ tab in Katalon Recorder, it will show you how to use these commands, too.
