how to read a text file and write a excel file using a gembox.preadsheet library

Question

I need to read a text file with the following structure:
"2^7^N^2160.000000
2^8^C^US "
where the first value is the line, the second the column, the third data type and the quarter
the value to generate a excel file usign the gembox.preadsheet library