Problems in LoadTextFile

[dbellazzi]

Hi everyone,

I'm having trouble translating an .xlsx file into text using the LoadTextFile function. I also tried using the "Read All Text from File" task in the "File Management" object.
What I get is 17753 characters but if I try to retrieve the "Current Value" I only get "PK".
Instead for an eml file I get this for example
"Received: from exc16tmpmr18.sede.corp.sanpaoloimi.com (10.49.75.7) by
And
...
PR85MB0251NAMP_--"
Can you give me support?

Thank you,
Daniel

[harish.mogulluri]

Hi Daniel,

I dont recall I tried to convert xlsx file to text file.

If  you encountered the issue with conversion, I probably would suggest to convert in to csv and then to text file

https://community.blueprism.com/t5/Product-Forum/Converting-Excel-file-to-Csv-file/td-p/62584

[MichealCharron]

@dbellazzi 

Both the LoadTextFile function and the "Read All Text from File" actions are for reading files that are in a text format.

A ".xlsx" file is essentually a ZIP compressed file that contains all the data from the workbook. That is why you are getting a ZIP file signature of "PK" (Phil Katz the co-creator of the ZIP format) and all the compressed binary data put in the data item. The "Multiline Edit" dialog is encountering a control character that is cutting off the display of the data.

An EML file is always a text file that uses Base64 to store binary data within it so it would never encounter control characters.

[harish.mogulluri]

Hi @MichealCharron,

That is very good info. Thanks for sharing.

[Daniel_Sanhueza]

Hello @dbellazzi 

What I have use in the past to "convert" an xlsx file into a txt file is the following secuence of steps;

• MS Excel VBO:Create Instance
• MS Excel VBO:Open Workbook
• MS Excel VBO:Select (Give the range of the table, i.e. "A1;Z100")
• MS Excel VBO:Copy
• Utility - Environment: Get Clipboard or use a Calc stage with GetClipboard() function, save the data in a text dataitem.
• Utility - File Management:Write text file (sending data item text that previously got the clipboard)
• Utility - Environment:Clear Clipboard
• MS Excel VBO:Close Instance

Not sure if this is the correct approach in your case but perhaps help you in some way.

Regards.