Excel Activites - read all the filled values from one csv file to excel file

[Nithyakavitharan_T]

From the downloaded file how to read only the filled values and copy to another excel file

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @Nithyakavitharan_T
Read CSV file and store it in datatable and then

DataTable filtering with expressions

Hi All, Use below code to remove empty row from the table. DataTable name->DataTableName Use assign activity DataTableName=DataTableName.Rows.Cast(Of DataRow)().Where(Function(row) Not row.ItemArray.All(Function(field) field Is DBNull.Value Or field.Equals(""))).CopyToDataTable() Re-usable Component pass Parameter as datatable you will get the answer. RemoveEmptyRows.xaml (8.5 KB) Remove rows based on particular column is empty. DataTableName.Select("Convert(column3, System.String)< >''"…

Delete the empty rows using above code and write it in excel

[Nithyakavitharan_T]

Hi Sangeethaneelavaana, Thanks for the quick reply. Is it possible to find the end of file values and the assign the range to copy the data from one excel file to another using ‘paste values’ only.

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @Nithyakavitharan_T
You could give empty range value,the read CSV file activity automatically picks the range of filled values in the sheet.

[Nithyakavitharan_T]

I am using a template csv, if I use copy function to the template file, will it override my template. Manually I do paste values only option.