Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application and Java (J2SE and J2EE) application.

Thu Nov 02, 2017 2:11 pm

I have run into an issue importing a csv file into Excel using EIceBlue. I have a csv file that has """" which according to https://tools.ietf.org/html/rfc4180 should be a valid way of importing hard quoted quotes. Could you please investigate and determine if this is a bug or is Eiceblue expecting something else?

I am including the 2 csvs that I have run. One that is fine and the other that has the problem and the excels that it created.

Code: Select all
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"CSVfilename", ",", 1, 1, ExcelVersion.Version2016);
            Worksheet sheet = workbook.Worksheets[0];
            workbook.SaveToFile(@"ExcelFileName");
Attachments
testcsv.zip
(6.89 KiB) Downloaded 117 times

Talsbard
 
Posts: 14
Joined: Wed Oct 12, 2016 9:27 pm

Fri Nov 03, 2017 2:34 am

Hello Eric,

Thanks for your post. I have noticed the issue and logged it in our bug tracking system. Sorry for the inconvenience caused. If there is any update, we will let you know.

Best regards,
Simon
E-iceblue support team
User avatar

Simon.yang
 
Posts: 620
Joined: Wed Jan 11, 2017 2:03 am

Tue Dec 19, 2017 9:14 am

Hello,

Glad to inform you that issue has been fixed. Welcome to download it.
http://www.e-iceblue.com/downloads/Temp ... .16.25.zip

Best regards,
Simon
E-iceblue support team
User avatar

Simon.yang
 
Posts: 620
Joined: Wed Jan 11, 2017 2:03 am

Thu Dec 21, 2017 8:48 am

Hello,

Greeting from E-iceblue.
Has the temporary version resolved your issue?
Your feedback will be greatly appreciated.

Best regards,
Simon
E-iceblue support team
User avatar

Simon.yang
 
Posts: 620
Joined: Wed Jan 11, 2017 2:03 am

Return to Spire.XLS