search

aspose-cells / Aspose.Cells-for-.NET

Aspose.Cells for .NET examples, plugins and showcases
https://products.aspose.com/cells/net
MIT License
218 stars 103 forks source link

Fails to open CSV delimited with comma and newline #62

Open knyipab opened 2 years ago

knyipab commented 2 years ago

Aspose.Cells fails to open the csv link below which could be opened by Office withotu any issue. https://www.federalreserve.gov/econres/notes/feds-notes/FEDS-Note-2873-cie-data.csv

amjad-sahi commented 2 years ago

I tested your scenario/case using the following sample code with our recent versions (e.g., Aspose.Cells for .NET v21.12) and it works fine: e.g. Sample code:

Aspose.Cells.TxtLoadOptions opts = new TxtLoadOptions(Aspose.Cells.LoadFormat.Csv);
Aspose.Cells.Workbook workbook = new Workbook("e:\\test2\\FEDS-Note-2873-cie-data.csv", opts);
Console.WriteLine("ok");

Please try our latest version if you are not already using it. If you still find any issue with latest version, kindly do share your sample code (runnable) to reproduce the issue on our end. We will check it soon.

PS. we also recommend you to kindly do post your queries/issue in dedicated Aspose.Cells forums.

knyipab commented 2 years ago

Oh oh, apologize for not stating clearly. I'm using the online service https://products.aspose.app/cells/viewer/, which has a GitHub link to here.

atirtahirgroupdocs commented 2 years ago

@knyipab

We still cannot reproduce this issue using https://products.aspose.app/cells/viewer/. Please have a look at this screenshot. screenshot

knyipab commented 2 years ago

@atirtahirgroupdocs You may need to enter URL, instead of uploading CSV file. Screenshot_20211209-133915_Chrome

atirtahirgroupdocs commented 2 years ago

@knyipab

We are investigating this issue. Please always post Aspose apps related issues on this forum.

atirtahirgroupdocs commented 2 years ago

@knyipab This issue is now fixed. Please try the web app again.