Hi, I created a workflow that reads multiple Excel files, merges them into one DataTable, applies a filter, and writes the result to an output file. Problem: The output Excel only contains the column headers, but no data rows. Using Read Range Workbook with AddHeaders=True and blank range. Merg…

Hi @Keerthana06 It can be the case that during the merge/filter, data is getting lost/filtered. I would suggest to run process in debug mode, put breakpoints at different merge activity and filter activity. And then review the datatable variable in each of those activity from locals panel. That …

Output Excel only shows headers after merging and filtering DataTable

Help Studio

Anil_G (Anil Gorthi) July 27, 2025, 7:39am 11

@Keerthana06

Glad it helped

Happy Automation

cheers

Topic		Replies	Views
Merge 3 excels files Help datatable , excel , activities , question	33	1292	February 16, 2020
Extract Data from excel after Apply Filter Help datatable , excel	3	3662	October 29, 2018
Filter datatable in excel Activities excel	3	740	April 21, 2021
Merge Datatable - Unnecessary column displayed Help	11	3941	August 4, 2019
Excel DataTable doesn't conserve the headers Studio datatable , excel , studio	5	798	December 2, 2020

Output Excel only shows headers after merging and filtering DataTable

Related topics