Import XLS file into MT5

To add comments, please log in or register
Daniel Weckhuyzen
258
Daniel Weckhuyzen  

Hi,

Does anybody knows how to import an XLS file into MT5, or how to convert an XLS file to a CSV file from out of MT5 ?

All help welcome !

Danny

whroeder1
17942
whroeder1  
Daniel Weckhuyzen: r how to convert an XLS file to a CSV file

In Open office, save as and select the output type.

Daniel Weckhuyzen
258
Daniel Weckhuyzen  

Thx for your reply, but I would like to do it automatically to be able to download a file using "WebRequest" and import it in a readable format

Stanislav Korotky
24588
Stanislav Korotky  

Modern MS Office uses XLSX format, which is actually a zip archive (can be read by MQL natively), which in turn contains xml-document (and other styling files, but they are unimportant), so you will need to find XML parser - I think there are some in the code base.

If you deliberetly want to read old XLS format, you will need to deal with 3-d party DLLs.

To add comments, please log in or register