1.reading text file using read text activity
2.write text activity to save text file into.xls
3.in excel if company code contain 01234 it is displaying like 1234 but in text file I am able to see 01234.
4.value 0 is hiding / deleting from excel while trying to do manually also I am facing same thing
I need exact company code whatever I am reading from text file and same format should be in excel as well.
Go to that column in excel file and then go to Format cells option Number - > Custom and then type 0’s based on length of your company code. If it is five digit then enter five 0’s and apply it.
@Naveen.Ch Convert your column to string , as excel doesn’t show leading zero’s in any format including CSV, you have to convert that to string or as company code is mostly 4 digits you can do a padleft(“COCD”,“0000”) at run time to go with the process.