Why does Unity fail to read CSV exported from Excel 2010?

Question

This is so frustrating. I have Excel 2010 where we are editing CSV data. But when I save this CSV from Excel, Unity cannot read it as Text Asset! But if I then just load with NotePad+ and save it -- then Unity can read as Text Asset.

I even took the CSV file saved from Excel and used Windows Explorer to Ctrl+C then Ctrl+V (copy/paste in place) -- and it created a copy just fine -- and Unity could read the COPIED file just fine. But not the original file.

We use SVN, it shows zero differences in the file for check-in. Yet somehow Unity seems to care how the file was last saved -- Text Editor (works fine), but Excel 2010 fails entirely.

This is not acceptable. It's like Unity is going out-of-its-way to do something that is very pointlessly frustrating, and even seems impossible.

Why would/should Unity care which program saved it? And why then would a Windows Explorer Copy/Paste then create a file that Unity can read just fine?

Yeesh.

Answer 1

Answer by MyUnitydream · Sep 12, 2018 at 05:12 AM

you can use Uni-Excel Package for Read, Write, and edit excel files

https://assetstore.unity.com/packages/tools/uni-excel-47540

Add comment · Share

Answer 2

Answer by maximilianahead · Oct 22, 2019 at 01:47 PM

Because you are opening csv by EXCEL so close it and free.

However, you can read open files by following.

 using (FileStream fs = new FileStream("test.csv", FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
 using (TextReader sr = new StreamReader(fs))
 {
     content = sr.ReadToEnd();
 }

Add comment · Share

Why does Unity fail to read CSV exported from Excel 2010?

2 Replies

Your answer

Follow this Question

Related Questions