Open pipe delimited document for processing

Aspose.Cells Product Family
1

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.
2

Hi David,

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

Thanks,

3

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.