From the downloaded file how to read only the filled values and copy to another excel file
Read CSV file and store it in datatable and then
Delete the empty rows using above code and write it in excel
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.
You could give empty range value,the read CSV file activity automatically picks the range of filled values in the sheet.
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.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.