Using C#, I need help to design a simple utility that will parse data from a text file and write the data to a new Excel file. The text file contains fixed width fields which need to be extracted and then placed in specific cells in the Excel file. All data in Excel must be formatted as Text datatype. Some data in the text file will not be migrated so I need to parse the text lines based on the start position and character count for each field - there are five fields. The UI will be basic, but will require a file explorer to locate the text file and must be able to create and save the resulting Excel file. I am a novice at programming and need as much detail on how to build this application as possible. I am trying to learn while at the same time accomplish a task. Thanks to all who might respond.
Start Free Trial
