search

saucepleez / taskt

taskt (pronounced 'tasked' and formely sharpRPA) is free and open-source robotic process automation (rpa) built in C# powered by the .NET Framework
http://www.taskt.net/
1.09k stars 350 forks source link

Text Extraction #243

Open Changzs2000 opened 3 years ago

Changzs2000 commented 3 years ago

Anyone know how to convert content of text file to excel file?

onvickirk commented 3 years ago

I know of a couple ways to do this: 1) If your text is in good form, you can use the Excel commands to open a workbook, then 'record' to have Excel import the file. Take a bit of effort to make it work in Office365 with the 'Transform' window but it does work. 2) Use Commands to read the text file into a variable, then parse it for the data your want. You can then use the Excel commands to open a workbook and append rows.

Variations on one of those approaches should get you going.