Data from excel to notepad

[poojagupta83]

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.

[Daniel_Sanhueza]

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!

[poojagupta83]

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

[Daniel_Sanhueza]

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

[poojagupta83]

It worked. Data looks good. Appreciate your help.

[Daniel_Sanhueza]

Glad it help!

Regards 🙂