We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Pipe Delimited text file.

Thread ID:





98949 Apr 11,2011 04:41 AM Aug 12,2011 01:06 AM ASP.NET Web Forms (Classic) 4
Tags: XlsIO
Alex Moran
Asked On April 11, 2011 04:41 AM


is it possible to load a pipe delimited text file using Xlsio?


Jawahar Jeevanandan J [Syncfusion]
Replied On April 12, 2011 07:25 AM

Hi Alex,

you have posted the similar incident in direct trac also. we have provided you with the necessary details and information. please follow the direct trac incident 79335.


Robert Miles
Replied On August 11, 2011 08:35 PM

Is there a solution to this? I can't see his Direct-Trac incident. I'd like to know if this is possible as well. Thanks!

Robert Miles
Replied On August 11, 2011 08:51 PM

Nevermind, I got it working by using...

ExcelEngine.Excel.CSVSeparator = "|";

and opening the pipe-delimited file with ExcelOpenType.CSV.

Jawahar Jeevanandan J [Syncfusion]
Replied On August 12, 2011 01:06 AM

Hi Robert,

Thanks for the update. We are glad to know that you have found the proper solution for the reported problem.

Kindly revert for any clarifications.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.