Dynamic read range XLS

[Sathish_Kumar_S]

This “user” header will be in different row in each downloads. Hence we can’t use static range to read the XLS file.

How to get the values in the highlighted column ? and remove the empty after User row?
Save the file values to XLSX format ::
ulisthct.xls (334.0 KB)

Example :
Attached the input file for your reference

[mkankatala (Mahesh Kankatala)]

Hi @Sathish_Kumar_S

You can use the Find\Replace Value activity to find the User keyword in the Excel file.

Select the Find operation in the dropdown and create a variable in the FoundAt field to get the value where user found in the Excel.

Then seperate the row number from the output and use delete row activity to delete the next to the user column.

Hope it helps!!

[lrtetala (Lakshman Reddy)]

Hi @Sathish_Kumar_S

Try this

(Cint(System.Text.RegularExpressions.Regex.Match(ValueFound,"\d+").Value)+1).ToString

Regards,

Output:

Regards,

[Sathish_Kumar_S]

“User” Text is available in multiple places in the excel file… Will find text will find the correct “User” Text?

[lrtetala (Lakshman Reddy)]

@Sathish_Kumar_S

This will match exact value

[Sathish_Kumar_S]

Sorry , the solution is not working for me…

My expected output as per below screenshot… but it is deleting only the empty row below “User” text.

But my requirements is : just need to capture all the user ID under "User " Column and remove empty row below User column → save as XLSX format

[lrtetala (Lakshman Reddy)]

@Sathish_Kumar_S

Try this

Sequence12.xaml (16.8 KB)

Regards,

[lrtetala (Lakshman Reddy)]

@Sathish_Kumar_S

Try this

Sequence12.xaml (17.7 KB)

Output:

Users.xlsx (28.4 KB)

Regards,

[Sathish_Kumar_S]

This solution generating the destination file much quicker … Thank you