Thursday, 7 March 2013

Excel to Special Character Delimited Format(CSV file convertor)

The business sends data across to the developers mostly in Excel format. To load it in the code we always need to convert it into a flat file(a special character delimited file). The task is simple. The content can be taken from excel copied in NP++. And with a few Keyboard buttons, we have the file ready. This simple task is accompanied by various small tasks like opening the source file, copying its content, opening NotePad ++ applications, then pasting it there, etc. Imagine doing this for hundreds and thousands of files(depending on how big the project is). This would get insane, and waste a lot of valuable time of the developer.

I have developed a VB Script for doing all that, and made it even simpler. 
The user just needs to browse the source file, browse the destination file(if already exists, otherwise the software will create one on its own). Its accompanied by a few other functions.

No comments:

Post a Comment