XlsxWriter: Excel .xlsx files from MQL5 without DLL - MetaTrader 5용 라이브러리

XlsxWriter.mqh writes real Excel workbooks (.xlsx) from MQL5. It needs no DLL and no Excel on the computer: the file is a zip of Office Open XML parts, stored without compression, with a CRC-32 for each part.

Features

• Several sheets in one workbook
• Text, numbers and dates; dates are real Excel dates, so they sort and filter correctly
• Bold header row, frozen, with filters on every sheet
• Column widths
• 8 number formats: date-time, date, month, money, integer, price (5 decimals), percent, 2 decimals
• Unicode text (UTF-8)
• Works in scripts, Expert Advisors and in the Strategy Tester (write to FILE_COMMON in OnTester)

Usage

#include <XlsxWriter.mqh>

CXlsxSheet sheets[1];
string headers[] = {"Time", "Symbol", "Profit"};
double widths[]  = {19, 12, 12};
sheets[0].Init("Trades", headers, widths);

sheets[0].BeginRow();
sheets[0].Time(TimeCurrent());
sheets[0].Text("EURUSD");
sheets[0].Number(12.5, XS_MONEY);
sheets[0].EndRow();

CXlsx book;
book.Save("trades.xlsx", 0, sheets);   // MQL5\Files\trades.xlsx

Example

The script ExportDealsToXlsx.mq5 writes the deals of the account history to the sheet Deals and the result of each trading day to the sheet Daily. Put XlsxWriter.mqh in MQL5\Include and the script in MQL5\Scripts.

The files were checked by opening them in Microsoft Excel.