How to know total records of test data?

Hi Everyone,

I am new in using Katalon Studio. I need to write request and response data of SOAP API into excel at the same time. Request data is supplied by excel file. Anyone know how to count total request data from excel file?
My Scenario is I want to collect every request and response data into list (collection) and then if all of the processes (all records data) are done I will write it into excel file?

Thanks in advance.