topic Re: Data from excel to notepad in Product Forum

Data from excel to notepad

poojagupta83 — Wed, 20 Mar 2024 14:23:02 GMT

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.

Re: Data from excel to notepad

Daniel_Sanhueza — Wed, 20 Mar 2024 15:00:27 GMT

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!

Re: Data from excel to notepad

poojagupta83 — Thu, 21 Mar 2024 12:23:46 GMT

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

Re: Data from excel to notepad

Daniel_Sanhueza — Thu, 21 Mar 2024 12:39:13 GMT

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

Re: Data from excel to notepad

poojagupta83 — Thu, 21 Mar 2024 13:23:52 GMT

It worked. Data looks good. Appreciate your help.

Re: Data from excel to notepad

Daniel_Sanhueza — Thu, 21 Mar 2024 13:45:29 GMT

Glad it help!

Regards 🙂