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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Does XlsIO support CSV file format?

Yes, XlsIO supports opening and saving of CSV files.


By default, the CSV files are opened in Excel 2003 format. If the file has more that 65536 rows of data, it is recommended to set the default version to Excel 2007 or above.

C#

 

VB

 

Article ID: Published Date: Last Revised Date: Platform: Control:
1875 04/30/2011 02/01/2018 WinForms XlsIO
Did you find this information helpful?
Comments
Michael Baas Aug 21, 2017

Thank you. That "," used as second argument in the Open-Command, does that have a different effect than using ExcelOpenType.CSV and wouldn't the latter be cleaner?

Also, when I try to execute it, I get "EXCEPTION: Das angegebene Argument liegt außerhalb des gültigen Wertebereichs." ("Specified argument outside permitted range") Admittedly I am challenging the library because I'm attempting to import a file with 1.000.000 rows, but I think since even Excel can handle that, it shouldn't be a problem for XlsIO ;-)

Reply
Sridhar Sukumar [Syncfusion] Aug 23, 2017

Hi Michael,

 

There is no difference between opening a CSV document in XlsIO with comma separator and ExcelOpenType as CSV. We suspect that the exception might be raised due to opening the CSV document with 10,00,000 rows in XlsIO when application version earlier to MS Excel 2007. We request you to set the IApplication.DefaultVersion as Excel.2007 or above before open a file to overcome the issue. Please refer the following code example to achieve this.

 

Code snippet:

Application.DefaultVersion = ExcelVersion.Excel2007;

 

Regards,

Sridhar.

Michael Baas Aug 25, 2017

Thank you for your suggestion. Did that - and then I get a message "PPPPPP is not valid named range".  I'm pretty sure the 1,000,000 rows are the problem - a smaller version of that file with just 50,000 rows went in just fine.

Oh, and just looking at ExcelOPenType, I was wondering why the .CSV is required if there also is a .Automatic - but that did not recognize the file as CSV. (I was hoping I might be able to avoid special casing .CSV with "Automatic", but if that doesn't work, I'll have to do ugly IF's ;-))

Reply
Sridhar Sukumar [Syncfusion] Aug 28, 2017

Hi Michael,

 

A support incident to track the status of this query has been created under your account. Please log on to our support website to check for further updates

 

https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents

 

Please let me know if you have any questions.

 

Regards,

Sridhar.

Adriaan Aug 22, 2018

Hi 

I would just like to find out what the resolution to this problem was?


Regards

Reply
Mohan Chandran [Syncfusion] Aug 23, 2018

Hi Adriaan,

 

We had confirmed this as an issue and it was already fixed in our release v15.3.0.33 which was rolled out in end of September 2017. So, we request you to upgrade to our latest product version v16.2.0.46 to get this issue resolved.

 

Regards,

Mohan.

Reply
Add Comment
You must log in to leave a comment

Warning Icon 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.Close Icon