Forum Discussion

rashmi's avatar
rashmi
New Contributor III
3 years ago

Dynamically parse the excel without having sheet index or sheet name

Hi, Anyone aware of how do we parse the excel with multisheet without even knowing sheet index / sheet name with having certain number of records in each sheet. I am having requirement to remove ...
koryknick's avatar
koryknick
Employee
2 years ago
Copy LinkReport

jfpelletier - it looks like you need to change your Multipart Form "Key" names into static strings by disabling the expression button and removing the $.  So it would look like this:

Hope this helps!

 

jfpelletier's avatar
jfpelletier
Contributor
2 years ago
Copy LinkReport

Hello koryknick,

Thanks for your reply!

I'm unfortunately getting the same error, please see screenshot below. I'm also wondering how I can dynamically get the project name if I remove the expression button, isn't it how I can get the field values?

Thanks,

JF

  • alchemiz's avatar
    alchemiz
    Contributor III
    3 years ago
    Copy LinkReport

    $.keys().sort().reverse().toObject((k,i)=> k, (k,i)=> $.get(k))