Write to Separate Sheet in Excel?

[tomli]

Hi Everyone. I'm currently forward testing a bunch of EA's on a demo environment and I'm using a separate 'Archiver' EA using the 'write to file' function to store details of how the account is changing (balance, profit, relative drawdown etc) each hour and its updating the same spreadsheet in the way I want, no problem.

What I'd like to do additionally is capture details on when each EA is opening trades, how the profit of these trades changes, when they close etc, in an excel. I know I'd probably need to have an individual 'Archiver' EA for each trading EA and match the magic numbers so it could pull out the relevant trades, that's fine, but I'm wondering if the Archiver EA's could all update the same spreadsheet? I'd need a lot more than 10 columns for all the EA's and details so not sure I can do it with the standard write to file block. Is there a way to have data written to separate sheets in the same excel doc? Or maybe a way to configure which column each Archiver EA starts writing to? So Archiver no1 writes into columns 1 - 10, Archiver no2 writes in column 11 - 20?

Hope that all makes sense! Any help much appreciated.

[l'andorrà]

@tomli That is an interesting question. I never used more than 10 columns so I have no idea if that is possible. Has anyone tried?

[tomli]

Think I will have to have separate archiver EA's and just do something with macros in excel to combine all the data in one master excel