We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Open pipe delimited document for processing

I currently have C# code, as follows, that opens a pipe delimited text file:


  • asposeWorkbook.Open(_EODPositionFile, Convert.ToChar("|"));

After implementing the latest version of Aspose Cells, I have a warning in my code that this construct is now obsolete, and to use the Workbook(string, LoadOptions) constructor method instead.

How do I do this? I have seen one other post from 2005 about opening a pipe delimited file and the response to that person was to first convert the pipe symbols to commas and open as a CSV–this is something that is not feasible for my project.

While this is only a warning and not a compile-time exception, I want to change these before my existing code, which currently works just fine, ceases to do so.

Thank You,

David.

Hi David,

You may please continuoue using your code. We will update you soon about the details.

Thanks,

Hi,

In the latest version, you need to use “Workbook(string,TxtLoadOptions)” constructor. See the following example for your reference:
//Instantiate LoadOptions
TxtLoadOptions txtLoadOptions = new TxtLoadOptions();
//Specify the separator.
txtLoadOptions.Separator = Convert.ToChar("|");
//Create a Workbook object and opening the file from its path
Workbook wb = new Workbook(“e:\test\abc.txt”, txtLoadOptions);


Hope, this will help you.

Thank you.