I have successfully uploaded the BalaReva CSV Activities in UiPath Go.
This activity converts the CSV file to an excel file. The activity has the options [Input-format]. It helps to convert the column which the user desires. While doing the conversion, the user will face zero omission issues when converting to string. Date format can be fixed by user. It was especially developed for @CamiCat and it has been changed for generic usage.
Hi, i am new of uipath. I love your Activities inculding easy excel and this time i try to use csv to excel. As the result in excel there are “xxxxx” in each cell. Is it related to the input format? What i should input??
I am converting a .csv file to .xls file using this activity. After conversion, I have observed that Date present in .csv file gets converted into text format in excel file and date (for e.g. 05/28/2020) gets changed to (05/28/20). Could you please help me into this? Am I missing anything here?
Hi @balupad14, Sorry for the late reply. Please find below my .csv file. my_latest_test_xl.xls (7.9 KB)
As upload wizard on this page does not support .csv file upload, I have uploaded converted .xls file.
Hi @balupad14, I have identified the issue. Problem is that after conversion of .csv file into .xls file, column containing Date is getting formatted as Text in .xls file. Is there any way we can keep the format of the destination file same as the source file while converting it?