Exctracting information from Excel DataTable


#1

Hello friends,
I should extract some information from the Excel File that I’m attaching here.
EC_1021756_formato_Excel.xls (107.5 KB)

I need to extract from the Excel sheet “pag 2” the data inserted in the column highlighted.
image; in particular I should extract all the data in the rows “Nro contratot”, “Assicurato”, “Compagnia” and “Premio”.
Can you please help me in extracting these values and exposing them in Message Boxes?
Thank you so much,
Camilla :slight_smile:


#2

Can anyone please try to help me in resolving this issue?
Thank you so much for your kind help,
Camilla :smile:


#3

Hi @CamiCat,
Have tried to read the data into datatable by using the Read Range activity by specifying the range “E12:AH16”.

Regards
Balamurugan


#4

Yes that’s the simplest way which I have tried.
Is there a way to extract these data when they will be placed in a different position?
Also the number of rows will not be fixed.
Thank you so much @balupad14.
Camilla :slight_smile:


#5

Hi @CamiCat,
Here i have attached the soure .

File : Main.zip (1.8 KB)

Regards
Balamurugan


#6

Thank you so much @balupad14.
The one thing that I should obtain is to extract the data only from particular columns, which are located not always in the same place in the Excel File.
Thank you.
Camilla


#7

When i read the total rows with out Read Range . It reads 24 rows count.

For example the Nro contratot is now in E12.
You are saying that it will be in Same Row position and different column.Right

It will increase above the SINISTRI

Regards
Balamurugan


#8

Hi @CamiCat,
Let me assume that first we have to search the column name and then have to read the data. Right ?

Regards
Balamurugan


#9

Yes @balupad14.
That’s correct. It’s what I was trying to say before :slight_smile:
Thank you so much,
Camilla.


#10

Hi @CamiCat,
Give me some more minutes. I will send the file.

Regards
Balamurugan


#11

Hi @CamiCat,
Initially you have 2 blank column. Can i remove it. and do the process.

Regards
Balamurugan.


#12

Yes, @balupad14, sure :slight_smile:
Thank you so much.
Camilla :slight_smile:


#13

Hi @CamiCat,

Here I have attached the source. It searches the column Range for “Nro contratot”

Where ever you change position of the column name . it will find the starting Row column and ending row .

File : Camicate.zip (60.3 KB)

Regards
Balamurugan


#14

Thank you so much @balupad14.
Tomorrow I’ll try it and let you know.
Thank you.
Camilla :blush::blush:


#15

Hi @CamiCat,
Ok. WelCome. I have done it for only “Nro contratot”. further you can able to add more columns.

Regards
Balamurugan


#16

Hello @balupad14.
Can you please tell me which activity should be inserted where I get the error?


Thank you so much,
Camilla. :slight_smile:


#17

Hi @CamiCat,
It is “Invoke workflow file” Activity.

Regards
Balamruugan


#18

Hi @CamiCat,
If you open the xml file in notepad , you can able to see the arguments like below.

Regards
Balamurugan


#19

Thank you so much @balupad14.
The problem is that I don’t find the variable which must be associated to in_Search_Text


Can you please help me?
Camilla.


#20

Hi @CamiCat
It is like below.

Regards
Balamurugan