Extracting data from excel file


#1

Prova.xlsx (9.6 KB)
HI,
I need to extract data from the Excel file attached to this topic.
For example I need to save in a variable the value associated to “Marca”, that is HONDA.
I should save all the pairs variables, values in the Excel file.
Can someone help me?
I tried to extract all the data in the datatable and it saves the variables in different columns.

Thank you so much.
Camilla


#2

@CamiCat

What if it is associated with multiple values, like in your excel at l last it’s having
2018
2017
2016
2015
2014
2013

Regards,
Mahesh


#3

Ye that’s a good question. I didn’t manage to solve the problem.
Is there anyone who can kindly help us?
Thank you.
Camilla.


#4

@CamiCat

We can do that if you tell what we have to do for the below case

What if it is associated with multiple values, like in your excel at l last it’s having
2018
2017
2016
2015
2014
2013

Regards,
Mahesh


#5

HI.
Corresponding to each of the 5 values of years, I should associate the five successive values of “Sinistri resp. principale” and “Sinistri resp. secondaria”.
2018 -->0
2017 -->0
2016 -->0
2015 -->0
2014 -->0
2013–> 0

I hope to have been clear,
thank you.