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

Hi,

Did you mean something like this:

var excel = new ExcelFile();
var sheet = excel.Worksheets.Add("Sheet 1");
 
foreach (var line in File.ReadLines("Data.txt"))
{
    string[] lineValues = line.Split('^');
 
    int rowIndex = Convert.ToInt32(lineValues[0]);
    int columnIndex = Convert.ToInt32(lineValues[1]);
 
    if (lineValues[2] == "N")
        sheet.Cells[rowIndex, columnIndex].Value = Convert.ToDouble(lineValues[3]);
    else
        sheet.Cells[rowIndex, columnIndex].Value = lineValues[3];
}
 
excel.Save("Sample.xlsx");

Also check these demonstration samples for reading and writing excel files in C#.