Hi
@Sudersan Rao S,
You only can change the format to CSV files. Excel file are not formatted as such because it is not a plain text file.
To change this you can use some code, cause I think there is no specific VBO for this.
I modify a little bit the VBO "Utility - File Management" to add new action called "Change encoding to Ascii". You only need to give as input parameter the file path.
The code behind is simple:
Dim text = File.ReadAllText(strFileName, Encoding.Default)
File.WriteAllText(strFileName, text, Encoding.ASCII)
Hope this helps you!
See you in the Community, bye :)
------------------------------
Pablo Sarabia
Solution Manager & Architect
Altamira Assets Management
Madrid
------------------------------
