How can I get data from upload file(.xlsx , .xls) via form submission ? It give only file name not give data . Help me!

[yurvish]

I am creating workflow to analyze data from submission how can i get data of uploaded file via form , I get only file name and mineType but not get the data .

[Parintele_Damaskin]

Use a node Extract from file.

In the Extract from File node, select the appropriate operation based on your file type (e.g., “Extract from CSV” for CSV files, “Extract from XLS” for Excel files).

Make sure the Input Binary Field matches the field name of your uploaded file (commonly data or the name you set in the form).

P.S I think if you have pinned data , it won t work since binary isn’t saved in that.

[yurvish]

in extract from xlsx node

what should be the input binary field in above image ?

[alperen]

Hi. Schema - Table - JSON - Binary > Click ‘Binary’ and you will see an orange color title text. (probably data). Use it for ‘Input Binary Field’

[yurvish]

thanks man @alperen

[alperen]

you’re welcome.

[Parintele_Damaskin]

Glad that you made it.

Please mark the answer that solved your question, so when other people search here or in the docs chat , can get help as well.