Splitting Excel workbook into multiple files by sheet name

[jms2510]

Once I add the dynamic input tool to read the sheet names, how do I output an Excel file for each one? 

[gawa]

hi @jms2510 

In general, we utilize "Take File/Table Name from Field" option of Output tool to dynamically change file path.

[Deano478]

Hey @jms2510 to add to @gawa point if you don't have it already you should create a field with the Full File Path if its not already there

[jms2510]

The field "Sheet Names" is what I put into the dynamic input tool, but it is not showing up in the "Take File/Table Name from Field" option of the Output tool. (F4 is a column within the workbook)

 

[jms2510]

---

Hi  @gawa 

The field "Sheet Names" is what I put into the dynamic input tool, but it is not showing up in the "Take File/Table Name from Field" option of the Output tool. (F4 is a column within the workbook)

---

[Deano478]

Why not just read the Excel workbook in using the directory tool? and then bring in the sheet names separately and join them up before outputting?