How can I write to a custom log in an excel file?

[Sasha_R]

Hi,

Im trying to make a custom Log in an excel file.

Here are some of the columns of the stuff I’d like to log:

So my idea is to write to that file after every unsuccessful or successful transaction. (After it writes to a default log file).

For example, after I get one transaction data item, I want to add a message into the next free cell of a column under “LogMessage_GetTransactionData”.

How would I do that?

I’ve added the Excel Application Scope under the assign that gets the transaction data. I gave it the path to the log excel.

Then I think I need to read range and write to cell, but how do I write to the next free cell in a specific column?

Thanks in advance.

[Pablito (Pawel Wozniak)]

Hi @Sasha_R,
How about using Append Range activity?

[Sasha_R]

Oh thanks!