Multiple excel input to a specific sheet names in the template.

Question

Hi All,

I have been trying to do this in many ways but nothing worked.

I have 17 csv files named differently, I need to input them to a template where the sheet name and the range to be pasted are predefined. for example. If I have a sheet name as Anu.csv then I need to call that excel and paste the content of the excel excluding the heading  till are column AE till the last row of data in the tab called agent 21 in the template.

All the 17 csv are of different schema. I have imported the excel by dynamic input but stuck in where to link the output sheet names to get the correct data pasted.

Please help.

Regards

Rohini

MattBSlalom · Answer

This article has a good write up:  Getting Started with Batch Macros - Alteryx Community

rohini · Answer

Thanks for the below, I am stuck in few places, as I am creating macros for the first time.

is there some link or a workflow that has a step by step sample of the same procedure so that i can try doing that

Regards

Rohini

MattBSlalom · Answer

If you have the predefined target sheet names & cell range, you should be able to update the Output Data filepath to point to that location.  For example:  "C:\TEMP\New Microsoft Excel Worksheet.xlsx|||Sheet1$A1:D5".

This sounds like you'll want a Batch Macro where you pass in those 17 CSV filepaths & their target sheet names and cell ranges.

Here's a similar Batch Macro solution for reference:  Re: How to build iterative process - Alteryx Community