How to read a large file txt or excel?

[hernan]

I'm trying to use the file management to get a txt but it has about 400k lines.

Is it possible to get it?

 

[amanbareilly]

Hi @hernan

As you stated, I used the Utility File management object "Read text from file" and was able to get 420674 lines into the data item. It also worked with "Get clipboard" object of the Utility Environment.


Let me know if this helps.

 

[hernan]

Thanks for your reply @amanbareilly !

The message I got is "Exception of type 'System.OutOfMemoryException' was thrown."

Could you copy the print of your action and of "Get Clipboard" object?

 

[amanbareilly]

Thanks for your reply @amanbareilly !

The message I got is "Exception of type 'System.OutOfMemoryException' was thrown."

Could you copy the print of your action and of "Get Clipboard" object?

Hi @hernan
I am attaching the screenshot of the action stage here. In case if it still doesn't works would mean that your text file has more characters as compared to my text file. Let me know if it helps.