Extract data from different sheets within the same file

Dear All, Could some one suggest me how to extract the data from different sheets within the same file.

Currently I am using Directory tool ->Formula tool (sheet name) -> Batch Macro to extract the data.

But getting error when I save the Workflow into Gallery since files used in Macro cant able to access from local folder.

Regards

Mahadev

Developer

Input

Download

Accepted answers

Paulomi

Here you go! This is a very basic workflow that inputs data from different sheets within the same Excel file into one Alteryx workflow, without the use of a macro. Hope this helps!

ExtractDataFromDifferentSheetsWithinSameFile.yxzp

All comments

bensilv

Hi @mahadevaswab , is the issue with the macro itself? You will need to either have the Macro stored in a location that Alteryx Server can access, or package it up as an asset in the workflow.

Paulomi

Hi @mahadevaswab Not sure if I understand correctly, but do you want to get data from different sheets within one single Excel file into Alteryx? If that is the case, you could use a normal input tool to get a list of the sheet names, then use a filter tool to select individual sheets and then read in the data using a Dynamic input tool. Ideally, you would not need a macro for that. Does that help?

mahadevaswab

@Paulomi could you please share the sample workflow

Steven_Luo

It is helpful, thanks!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703