I have an Excel file, and one pf the sheets is read and converted into a csv. The empty rows are auto filled and I would like to remove these by adding conditional formatting to the Excel file so that the cells are always blank - that way when I convert to csv they remain blank. But I am unsure how to configure Excel to do this?
This would mean that you are having the Data in the form of a Datatable. We could Filter/Remove the rows which are not needed and then update the Datatable, so that the CSV will not have those rows which are not required.
Could you let us know the Configurations done on Read Range activity and Write To CSV activity ?
Is it the case that you are Reading the Excel sheet without Add Headers enabled and Writing to the CSV using Add Headers enabled ? If so, Could you uncheck Add Headers when using Write CSV activity and check ?
In that case, could you try to provide us with a Test data, a Sample Excel data which reflects the same format as the original but with Dummy data, where the same issue occurs when tested in your environment.
So that we can check with that data in our Environment and let you know if there is any change in the methods needed.
Do note that no screenshots of the Implementation were shares, so it is a bit hard for Debugging.
Although, you could also do the Debugging yourself and identify the point of Error :
Please would you be able to share the xaml file - also I can see the auto filled column names in the immediate panels were they removed afterwards as the removal of these is what I am trying to achieve
Also should mention that when I put a delete range activity after the read range the data table doesn’t have those auto filled columns but when I convert to csv the auto filled columns return