How to read particular columns from an excel file and save it to a Data Table?

With an excel with over 500K rows, selected columns are to be read in order to reduce the execution time. What is the way to read few columns rather than the whole excel file and save it to a Data Table?

1 Like

Hello @kumar.varun2 ,

You can try using Filter Data Table activity,

Cheers

Hi @kumar.varun2 ,

For reading a specific column, you could use the Read Column activities (available for both Excel Scope and Workbook).

Here you can find more details documentation

Best regards,
Marius