I have a set of data that I am having to read from one excel file split it up by certain filter criteria and then write it into smaller excel files. One of these data columns is zip codes and I am having issues with leading 0s from zip codes in some states. When I try to write back to excel I lose the leading 0 if I just use the write range feature.
The main solution I can find in the UIPath forums is to add an ’ to force excel to ignore the leading 0. This is not really feasible for my process as it would require to loop over the entire excel file which can be very large (last week’s file was 10k rows) and would add considerable amount of time to the process. Unless I have missed a method to easily append a ’ to every cell in a specified column that would be faster than a for each loop.
I remember reading somewhere that using csv was supposed to also fix the problem but it definitely does not unless there is a special encoding that is needed (when I tried csv I lost leading and trailing 0s actually as well as - in 9 digit zip code formats).
Does anyone know of any solution that would fix this problem?
If only it was possible to have a check box to tell excel to not change my data.