I have an Excel file that I’ve converted to Datatable and I want to add data to a certain column - according to a specific date (rows) and specific company code (columns).
Date (row) = Yesterday’s date
Once we verify this condition, it needs to paste the data from a variableA to the column related with the argument that gives us the company code.
[Check the screenshot above]:
So, for example, if in_argument is “1000” it needs to paste the data on 06/01/2022 (yesterday’s date) and then paste on column “1000 Mail”. If the in_argument was “2200” it would need to paste on “2200 Mail” and so on…
In the end, it needs to save the Excel file (so I believe an “assign” won’t solve this problem, but maybe a “write cell” does?)
Can anyone help with a solution for this?
Thank you so much in advance,