Data360 Analyze

 View Only

  • 1.  SharePoint Excel Filenames Not Available

    Posted 02-01-2026 19:44

    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
    ------------------------------


  • 2.  RE: SharePoint Excel Filenames Not Available

    Employee
    Posted 02-02-2026 10:13
      |   view attached

    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
    ------------------------------



  • 3.  RE: SharePoint Excel Filenames Not Available

    Posted 02-02-2026 16:34

    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


  • 4.  RE: SharePoint Excel Filenames Not Available

    Posted 04-01-2026 19:21

    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


  • 5.  RE: SharePoint Excel Filenames Not Available

    Employee
    Posted 04-02-2026 11:10

    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?



    ------------------------------
    Ernest Jones
    *Precisely Software Inc.
    PEARL RIVER NY
    ------------------------------

    Original Message