I believe the Excel node does this by default, assumingyouare not using the WorkbookSpec property. So I am guessing you are using the WorkbookSpec property. So looking at the options for the WorkbookSpec I am seeing <sheet index="3"> as meaning to read the 3rd sheet. Have you tried using <sheet index="1"> to indicate the first sheet regardless of name?
*Precisely Software Inc.
Original Message:
Sent: 04-01-2026 15:41
From: Mark Umbaugh
Subject: SharePoint Excel Filenames Not Available
Ernest, How would you get multiple Excel files with different worksheet 1 tab names to output into the same output pin, out1? I am able to collect the filenames using Directory List and connect it to the Excel node. I can get the records from all the Excel files if I create an output pin for each of the files and then use a concatenate node to bring them all together into one. I would much prefer to do it all in the Excel node. Is there an XML that would do this?
------------------------------
Mark Umbaugh
Billing Application & Process Support Specialist IV
Cox Communications, Inc.
Original Message:
Sent: 02-02-2026 16:33
From: andrew darnell
Subject: SharePoint Excel Filenames Not Available
Thank You Ernest, that has worked!!
I tried using the excel node help, but I didn't see this
------------------------------
andrew darnell
Knowledge Community Shared Account
Original Message:
Sent: 02-02-2026 10:12
From: Ernest Jones
Subject: SharePoint Excel Filenames Not Available
Hi Andrew,
In the node properties under optional, find the property named WorkbookSpec. This property contains XML that gives you a lot of control of how spreadsheets are read.
Put this in that property. You set the filename here however you like. I'm attaching a screen shot.
<workbook> <generatedFields> <field type="filename" name="MyFileName"/> <field type="sheet" name="SheetInFile" /> <field type="row" name="RecordNumber"/> </generatedFields></workbook>
------------------------------
Ernest Jones
*Precisely Software Inc.
PEARL RIVER NY
Original Message:
Sent: 02-01-2026 19:43
From: andrew darnell
Subject: SharePoint Excel Filenames Not Available
Hi Support
I am having issues with the Excel node in not populating the multiple filenames that the transactions are being read from.
In the CSV and Delimited nodes there is an option (Filename Output Field) to populate the filenames, but in Excel node there doesn't seem to be that option.
Is there a way to get this option working for Excel node?
------------------------------
andrew darnell
Knowledge Community Shared Account
------------------------------