Microsoft Excel Writer step

[nidhi.saraiya]

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.

[Jane]

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.

[harshitha28]

Is there anyway to extract only required columns from excel??

[Jane]

Hi! Harshita,

Yes. In the excel writer step on the Contents tab-Fields region, retain the required columns only.

[Jane]

Hi! Harshita,

In the case of Excel Input step on the fields tab retain the required fields only.

[harshitha28]

Thank you!!