Hi @MOSMASDAMSEK
Try this overall approach:
1) Before loop iterations, you have to 'Launch Excel' with a blank document. This will give you default %ExcelInstance% variable
2) Inside each loop iteration:
2a) 'Extract data from web page' to capture your data. In 'Store data mode', select 'Variable'. This will result in default %DataFromWebPage% variable
2b) Use 'Get first free row on column from Excel worksheet' action to do exactly that on the previous launched Excel instance. This will give you 2 variables by default: %FirstFreeColumn% and %FirstFreeRow%
2c) Then use 'Write to Excel worksheet' with these parameters:
- Excel instance = %ExcelInstance%
- Value to write = %DataFromWebPage%
- Write Mode = On specific cell
- Column = 1
- Row = %FirstFreeRow%
Doing that data extracted from web will be stored in just one sheet instead of several.
