I’ve been working on a little project where I need a 2D array of strings. I thought a good way of storing those would be an Excel file. Its easy to edit and everyone knows how to use it. Only then I discovered that reading Excel files isn’t a standard thing you can do in Unity. I did find something called NPOI but it wasn’t clear to me how I could use it in unity.
So my question is :
Is there a way to read Excel files through C# in Unity?
I’m also open for other ways that make it possible to make a file that stores a 2D array of strings that can then be read with C#.
Excel files are using an xml structure, so, in theory, you could use an xml parser to read it.
Although, if you want to edit it outside of Unity, you can still use Excel (or Apple Numbers) and export a CSV file. It’s quite easy to parse.
Otherwise, you can also create your own structure, edit it in the Editor and save it.
Here’s some information on [xml parsing].
You could also save it as a [ScriptableObject], and use an [EditorWindow] to display it.