Is it possible to automate the excel activities (such as read cell data, write to cell, etc.) in AE where the format and the file path of the input excel keeps changing for every automation, also the header names of the excel keeps changing, column count changes etc.
Please guide, if there is any way we could achieve the above scenario.
Using Excel recorder you can achieve mentioned . For dynamic file path, File path can be passed via argument also. Format has no impact.