Skip to main content

Nintex for SharePoint 2019:

Looking to have an easy "drag and drop" tool to allow a user to place a xlsx file into a document library, and have it add all rows into a specified list. The xlsx file is always the same format, column format, etc..

I see where I can build a collection variable using Query Excel Services, but that appears to only be for a single column.  This list has 30 columns.

I do not want the client to have to convert to CSV and do some reg expression collections and "pop".  Just drag and drop.

Do I need to create a collection for each column prior to going into a "for each" process?

Could not find any tutorials, YouTube's etc. for a multi-column Excel.

Thanks!!

Be the first to reply!

Reply