Could you guide me if it is possible to copy the text HTML-generated report to paste into an excel spreadsheet? I’ve already created a template but I need to paste this data and save the spreadsheet.
I really appreciate the help you’ve given
@flavio.macielr you can use Excel Writer step to write to a xls and xlsx file.
Can you tell me, how do I select and copy the spreadsheet data?
you can read an excel sheet using Excel input step, later on you select the information you want and afterwards you can use the excel writer to do so.
If you just want to copy the sheet, read the number of columns with the identification you consider, unselect header and read until end of data. Then write to a new sheet and/or file.
You may select auto adjust column width.