How to preserve Format while copying from an excel file

Help
2

Hi
preserve format is meant to get same format of the COLUMNS in the source file, i.e.,if the column is of type general or number the same format would be retained …but that doesn’t mean that it would take filter with it…and when we use read range activity we have a property called add filters, that would take applied filter to the data…take only the filtered data…but it is unchecked by default that means it will take all records even though you have applied filter to it… @sujoy_mukherjee
So if you are trying to write a excel with filter applied, we have to open the file with start process, and then use click activity to apply filter on it…
or for your case you can use MOVE FILE activity or COPY FILE activity
Or to make even better you can use the custom activity been developed by one of our …with this

Hope this would help you buddy
Cheers @sujoy_mukherjee

3 Likes