Batch Import Macro - Excel sheet with cell ranges

Hi,

I am trying to import several data tables that are located on different sheets and in different locations. Each table is slightly different and needs to be manipulated in a separate workflow differently before being joined.

I am trying to use a batch import macro to input the data based on a formula from a text input. However, only the default input table within the macro is being imported.

The macro attempts to take the input in the format "C:\\...\Documents\BatchImportData.xlsx"+[SheetName]+"|||$"+[CellRange] to update the file - value dependant on which table is required for the workflow. I have attached a simplified version of the workflow, macro and data template.

Please let me know if there is a simpler alternative or how to correctly input the updated value in the macro.

Many thanks,

Tom

Batch Import Macro_Example.yxmc

ImportCellRanges.yxmc

BatchImportData.xlsx

Batch Macro

Accepted answers

SPetrie

Your action tool is trying to update the wrong item. Highlight the File -Value instead of the @outputfilename

ImportCellRanges.yxzp

All comments

jdminton

You're very close. I finished off the outputs from the macro. It is likely how you were trying to read in the information. I just used a directory tool. See attached package.

Batch Tables.yxzp

SPetrie

Your action tool is trying to update the wrong item. Highlight the File -Value instead of the @outputfilename

ImportCellRanges.yxzp

jdminton

@SPetrie actually, if you look at the other macro, the batchimportdata macro is configured correctly. The workflow I added included the data coming in. Since we can't see how that is connected for @tmrwall , I'm assuming that was at least a portion of the issue. Also, there were no outputs on the macro.

tmrwall

Ah, I knew it was going to be something simple. Thank you!

tmrwall

Sorry, this was me trying to focus on the area that was causing the issue. I have tested each of the "Workflow" containers but as @SPetrie pointed out I was not updating the correct parameter and so it was retaining the default input. Thanks for your help!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335