Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.
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 242 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
-
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
-
Simon.yang
-
- Posts: 620
- Joined: Wed Jan 11, 2017 2:03 am