cancel
Showing results for 
Search instead for 
Did you mean: 

Data from excel to notepad

poojagupta83
Level 3

I have an excel file. All of its data needs to be pasted in Notepad. The data is comprised of around 1200 rows. I tried to use Save as & extension as .txt. The data copied in notepad is all distorted. Please advice.

5 REPLIES 5

Hello!

Could you try this secuence of steps?

  • MS Excel VBO:Select
  • MS Excel VBO:Copy
  • Utility - Environment: Get Clipboard or use a Calc stage with GetClipboard() function
  • Utility - File Management:Write text file (sending data item text that previously got the clipboard)
  • Utility - Environment:Clear Clipboard

Not sure if this is going to keep the formatting, perhaps someone have another approach, lets see

Regards!

 

Daniel Sanhueza
RPA Professional Developer
Deloitte

poojagupta83
Level 3

Thanks Daniel for providing response. When I do copy, it seems nothing is getting copied. I am doing following steps:

1. Create Instance

2. Open Workbook

3. Copy

4. get Clipboard

5. Write text file

6. clear clipboard

 

Hi!

You are missing the Select step before copy, where you need to use MS Excel VBO:Select and send the range, For Example; "A1:Z1900" and then Copy, try that and let see what brings

Regards

Daniel Sanhueza
RPA Professional Developer
Deloitte

poojagupta83
Level 3

It worked. Data looks good. Appreciate your help.

Glad it help!

Regards 🙂

Daniel Sanhueza
RPA Professional Developer
Deloitte