Data360 Analyze

 View Only

  • 1.  SharePoint Excel Filenames Not Available

    Posted 2 days ago

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

    Original Message


  • 3.  RE: SharePoint Excel Filenames Not Available

    Posted 23 hours ago

    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