Still fairly new to StudioX so please be nice
I built an automation, opening an Excel file, picking a number, entering it in another system, get a couple of fields from there and compare the fields with entries in the original Excel file. Works so far.
In case the values do not match, I want to create another Excel file with some error protocol, containing the number, and the two not matching values.
However, I did not manage to get this done, meaning to open the output Excel file, and then write information to fields. My challenge is that with Write Cell I can only provide exact fields such as Sheet1!A2 which is fine for the first row, but what I need is to detect the first empty row and then to add the data there. Maybe clean the file before adding the first row, so it will not endlessly grow.
Any ideas? Really stuck here.