hema2930
Forms Fledgling

fetch excel column data and show in nintex form text field

Hi All,

 

Is it possible to get the data from excel sheet on change of text box value.

Scenario is like i have a document library and folders and excel sheets inside folders.

The excel data is as shown below.

Exceldata.PNG

I have another list where i have the nintex form. Which has same 3 columns as above excel. On typing of host name it should give the role and application details from excel data.

 

can we achive this in nintex forms ? please post your idea or suggetions.

 

Regards,

Hema

0 Kudos
Reply
1 Reply
jpmhuls
Workflow Veteran

Re: fetch excel column data and show in nintex form text field

Hi @hema2930,

 

It is possible, however only by using JavaScript. The solution is based on jszip.js, xlsx.js, shim.js, moment.js, sp.js, sp.runtime.js and jquery-2.2.2.min.js.

A few years I intended to include it in a solution I was working on, but in the end the Excel file content needed to be added to a Nintex Form.

It's not a completely described solution, but hopelfully enough to put you on the right track.

If I'm not mistaken, you can find more info and latest version of xlsx.js on the following GitHub site: https://github.com/SheetJS/js-xlsx

0 Kudos
Reply