Expand my Community achievements bar.

SOLVED

I want to parse excel and save it in node

Avatar

Level 7

I have one excel which I need to parse and get data and put into the nodes. Excel to be included in dam

There are 5 column. 

SRC  Key    Value       Type         Score

ABC  011    Thanks    Gratitude    10

 

I want to store all these in nodes, I didn't know how to proceed and even if I input data in node how can I extract by matching key.

 

Example

If data is stored in node (NEED TO KNOW HOW TO DO)

If Key==011

Then Display Its type, Score etc.

 

Can I do via workflow or while rendering the page .. excel to be loaded everytime and parsed and perform the procedure.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor
1 Reply

Avatar

Correct answer by
Community Advisor