Copy only table values to another DT

Help Studio
,
3

Hi @Sathish_Kumar_S

Workflow Steps:

  1. Use Excel Application Scope

Input: your Excel file path.

  1. Use ‘Read Range’ (Workbook or Excel)

Read the entire sheet into a DataTable (e.g., dtRaw).

Set preserve format to false.

Leave the range blank to read the whole sheet.

  1. Identify Header Row (Start of Table)

Use a For Each Row (Index Enabled) activity to scan for a known header.

If row(“Column1”).ToString.Contains(“Name”) AndAlso row(“Column2”).ToString.Contains(“Amount”)

When matched, store the index as startIndex.

  1. Extract Table Rows

Now filter all rows from startIndex to end.

Use an Assign activity:

dtTable = dtRaw.AsEnumerable().Skip(startIndex).CopyToDataTable()

This gives you the red-highlighted table into a new DataTable.
Try this one!