How to get cell Length and send row to DataTable?

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)


Have you tried Excel - Append Range?

@Tana20 - Here you go.

2_Length.xaml (9.4 KB)
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.

1 Like

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


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)

1 Like

@Tana20 - Did that worked?

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:

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

Thanks for providing me such elegant solution! it worked :slight_smile: :partying_face:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.