|
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 | Windows Forms | XlsIO |
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.
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 ;-)
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.
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 ;-))
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.
Hi
I would just like to find out what the resolution to this problem was?
Regards
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.