Read Text File
For reading a Text file, you may refer here: (lots of suggestions)
What's the fastest way to read a text file line-by-line?[
^]
For splitting the records:
You may refer this:
http://www.dotnetperls.com/split[
^]
For more advance, you may use Regular Expression:
The 30 Minute Regex Tutorial[
^]
Create Excel Document
Another simple option:
Just create a HTML table and name the file extension as "
.xls
".
Microsoft Excel (regardless or any version) will open and convert it as usual Excel Document.
All the styles and colouring (formatting) will be handled too.