I want to parse excel and save it in node | Community
Skip to main content
Level 6
December 8, 2021
Solved

I want to parse excel and save it in node

  • December 8, 2021
  • 1 reply
  • 517 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

aanchal-sikka
Community Advisor
aanchal-sikkaCommunity AdvisorAccepted solution
Community Advisor
October 22, 2023