Import XLS file into MT5

[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

[William Roeder]

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]

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]

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.