Find Dynamic Excel Read & Write into sheet

[anh.nguyen]

Hi,

I have dynamic data Excel, how can I get numbers CONTAINE, and write another sheet. Thank all

TCNU6087868 → TCNU 608786-8
TCNU 651584-2
SKHU 810400-5
SKHU 931013-0
SKHU 820737-0
SEGU 444143-0

[anh.nguyen]

Hi,

Anyone can help me?

I use Excel Application Scope and LookUp Range, get only A26 can’t get number CONTAINER

[Anil_G (Anil Gorthi)]

@anh.nguyen

Can you please explain a little more…like you want to check if cell contains container? And do something when you find it?

Cheers

[anh.nguyen]

hi,
I want get the number of containers and paste another sheet
ex: find CONTAINER / SEAL NO.: TCNU6087868/HAS 1482677 get TCNU6087868 → TCNU 608786-8
paste sheet2: TCNU 608786-8

I just get A26 and don’t know get TCNU 608786-8

[Anil_G (Anil Gorthi)]

@anh.nguyen

After the lookup value…use a read cell activity and pass Athe output of lookup range and then get the value from it as output

Alternately you can read the data and then use the below linq query in assign activity to get all the rows containing container and can move them to different sheet

Read the data into datatable dt

Dt = dt.AsEnumerable.Where(function(x) x(0).ToString.ToLower.Contains("container")).CopyToDataTable

Now use dt and use a write range and write to a different sheet

Hope this helps

Cheers

[anh.nguyen]

Hi,

1. Only can get first number Container, how can get all num Container ?
   

2.How can get as: CONTAINER / SEAL NO.: TCNU6087868/HAS 1482677 → TCNU 608786-8

Main.xaml (8.3 KB)

Thank you

[LAKSHMI_NARAYANA_PEMMASAN (LAKSHMI NARAYANA)]

Hi

You can use assign activity to get

try as below
System.text.RegularExpressions.Regex.match(ContainerNo,“(?<=NO.:\s)\w+(?=/)”).Value
to extract Only container value
next to add space
system.text.RegularExpressions.Regex.replace(PContNo,“(?<=[A-Za-z])(?=\d+)”," ")

finally to add “-” before last character
ResultString.Substring(0,ResultString.length-1)+“-”+ResultString.Substring(ResultString.length-1)

Hope this helps
Regards

[Ankit_Chand]

Hello @anh.nguyen , you can use the read range workbook to read the excel file which gives the output in the variable of dataTable . Use for each row in dataTable , and add the variable (read range excel output) in the loop and inside in it use write cell activity to write the data in the excel sheet , and dont forget to click on the check auto increment check box.

[anh.nguyen]

Thank all, now I can get first num Con: TCNU 608786-8.

@Ankit_Chand Can you explain more to get all num Con in file Main I send
Main.xaml (9.6 KB)

[Ankit_Chand]

Yes , @anh.nguyen try this one
Main.xaml (13.9 KB)

[anh.nguyen]

Error open file

[Ankit_Chand]

did you tried my code ?

[anh.nguyen]

yes, I open your file Main.xaml

[Ankit_Chand]

show me your code

[anh.nguyen]

I don’t understand ? Just open your file xaml you send me but error