When creating new excel files using the Microsoft Excel Writer step we can use a template file. However, when creating new sheets we are stuck with using the existing sheets in the file; there is no option to use a new template design/sheet.
In AE Plugin R3.11, there is an enhancement to provide template sheet when creating new sheets. A user can add a new sheet in an existing, excel file using a different templates sheet in a single step.
Is there anyway to extract only required columns from excel??
Yes. In the excel writer step on the Contents tab-Fields region, retain the required columns only.