Read from a Multi Sheet Excel file, and display all Field column names

[alex_Intellese]

How can I take a Excell FIle that has multiple tabs / sheets and read ONLY the field names and organized them into a single column?

Attached is a sample file

[apathetichell]

Hi - I noticed that the sample file you posted is an older excel file (.xls) can you confirm that the files you are trying to do this for are vintage excel files (.xls) - not .xlsx?

[apathetichell]

I'm 95% sure that if these are .xls files you'll need an R or Python solution. I have something that will work with .xls files but it will require R and it will require the readxl package. I really (really) like managing my R packages via R studio with a join path between R Studio and Alteryx. If you don't have that can you try running the following commands in an R tool:

install.packages("readxl", repos='http //cran.us.r-project.org')

library(readxl)

If it runs - let me know and I can then shoot over a workflow which will get you all of your sheets for .xls files.

FYI - my R Tool package installs won't execute like that because my native Alteryx R library path points to a write-protected location, so check to see if yours download and run... So if you get a "can't install packages xxx is write protected" error - then it's either R studio or wait for the python peeps to respond..

[christine_assaad]

Hi @alex_Intellese 

Is the below what you are looking for?

I used the solution provided in this post https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Listing-the-list-of-sheet-names-from-X... with a macro that would transpose the fields. Hope this helps. Cheers!

[apathetichell]

@christine_assaadthe magic of R/Python solutions... I was looking at this post:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Read-XLS-files-with-several-...

But the macro seemed to be incomplete - as noted in my comment R version is pretty straight forward but perhaps this post should be edited or taken down?