How to get cell Length and send row to DataTable?

[Tana20]

Hi All,

Can someone please help me find the best way to accomplish this?

1. In sheet “CL” detect all cells in column “Invoice-Number” that have more than 16 characters. ----DONE
2. Send the entire row to another sheet called “FollowUp” in the same workbook. ----- ???

I don’t know how to send the information to a data table in order to update the workbook with a “Write Range” activity.

Any help will be appreciated.

2_Length.xaml (8.4 KB)

Thanks

[MichaelL]

Have you tried Excel - Append Range?

[prasath17 (Guru)]

@Tana20 - Here you go.

2_Length.xaml (9.4 KB)
Output:
Test.xlsx (9.2 KB)

Idea is : During the processing , if the length is > 16 writing that row to another datable. At the end of the processing , write the Output Datatable to a different sheet.

Please mark this as Solution, if it solves your query.

[Tana20]

Thanks @prasath17 but I got an error trying to open your file:

[prasath17 (Guru)]

hmm…I have another effective solution, this way you don’t have to write each row…

Can you please try this. 2_Length.xaml (11.5 KB) Test.xlsx (10.0 KB)

Save this xaml to the different folder and try.

New Solution (Screen Shot)

[prasath17 (Guru)]

@Tana20 - Did that worked?

[Tana20]

Well, I’m still unable to open your activities:

I tried to reproduce it but I’m not sure what variable type should I use:

[prasath17 (Guru)]

@karen.delgado.navarro…Please try this…Main.xaml (11.1 KB)

[Tana20]

Thanks for providing me such elegant solution! it worked