I have a csv file where 1 line is pipe delimited with not double quotes and another line is pipe delimited but with double quotes.
Thanks for your posting and using Aspose.Cells.
Please download and use the latest version: Aspose.Cells for .NET 8.1.1 it is working fine with your text file.
I have tested it with the following code and attached the output xls file generated by it for your reference.
Dim txtLoadOptions As TxtLoadOptions = New TxtLoadOptions()
txtLoadOptions.Separator = Convert.ToChar("|")
Dim workbook As Workbook = New Workbook(“test.txt”, txtLoadOptions)