How to copy text to paste in excel spreadsheet

Get Help & Discuss Process Studio
1

Hello guys

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

2

@flavio.macielr you can use Excel Writer step to write to a xls and xlsx file.

2 Likes
3

Can you tell me, how do I select and copy the spreadsheet data?

4

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.

5

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.

1 Like