Reading xls files with varying sheet name

Hi,

I want to use the dynamic tool to input an xls file that has different sheet names daily. The option i used to use had me type the sheet name to the Full name to get the dynamic tool to read the file and the sheet, however it doesnt work if the sheet name change often. Please help thanks

Help

Accepted answers

soccertil1108

You haven't posted if you had solved your problem. I took the liberty of creating a workflow that converts an XLS to XLSX and reads all tables. For you to run the workflow you will need to find where Office has stored the excelcnv executable.

convert XLS to XLSX input all tabs.yxmd

All comments

apathetichell

Are you talking about .xlsx or .xls? .xls requires using R or Python. .xlsx you would use a batch macro with an input data tool. The Dynamic Input tool will not work with schematically different sheets.

SoccerTil

If the filename is the same from day to day and only the sheet names change, then you can change the sheet name in the Dynamic Input from a stream of sheet names.

dynamicInput.xlsx

dynamicInput xlsx.yxmd

clarrock

@SoccerTil @apathetichell its an .xls file (not .xlsx) with sheet names that change daily that i want to dynamically input into my canvas. Please help

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703