Writing the data to a specific cell to an Excel file

[naren292000]

I am able to write the values to the excel on each tick

using 

int A = FileOpen(FileName,FILE_WRITE);

FileWrite(A, Bid);

FileWrite(A, Ask);

---------------------------------------------

I would like to know how to write this data to a specified cell in an Excel.

For example I want to write some text to the Cell "B3" of Sheet1.

I am aware of DDE excel where we use the formula in the cell to retrieve the Ask or Bid Price.

But I am trying get a text message to a specific cell in Excel when a new signal is generated from the chart .

Thanks in Advance

Naren

[Carl Schreiber]

Would DDE be an option - but I do't know whether it is still working!

May be you can try: https://www.mql5.com/en/code/1246

[naren292000]

Carl Schreiber:

Would DDE be an option - but I do't know whether it is still working!

May be you can try: https://www.mql5.com/en/code/1246

Hi Thank you for your response.

I am aware of DDE excel where we use the formula in the cell to retrieve the Ask or Bid Price.

But I am trying get a text message to a specific cell in Excel when a new signal is generated from the chart .

[naren292000]

Anyone who is aware of writing data to a specific cell in an Excel!!!!

[Marco vd Heijden]

Hello please see https://www.mql5.com/en/docs/constants/io_constants/fileflags

[nicholish en]

You cannot write data (using only MQL) to an excel spreadsheet. You can write a CSV file which can be opened by excel in CSV mode, but it is not a workbook. You could, however, use this open source library which can put values directly to an excel workbook. 

https://github.com/Nondisclosure/MT4toExcel

[Anton Nel]

naren292000:
Anyone who is aware of writing data to a specific cell in an Excel!!!!

Example please.