Reading and using Excel

This is puzzling the heck out of me.

I'm looking for a way to read an Excel spreadsheet and convert that data into a list (or similar). In theory, I'm looking for something similar to the methodology of reading a .txt file to generate a list. Everything I have found so far (maybe 20 or so different threads, pages, answers etc) involves using Excel to generate code, create objects, etc....

Or worse, is specific to writing to Excel, which I don't need to do. Is what I'm trying to do not feasible?

 

you could save your xl file as a .csv file. This is a simple text file where each line contains a row of the spreadsheet
with the values separated by commas. This would be simple to read into unity using string operations.

 

https://docs.microsoft.com/it-it/do.../interop/how-to-access-office-onterop-objects
https://stackoverflow.com/questions...ple-way-to-convert-xls-file-to-csv-file-excel

I suggest you to use database istaed of excel (mongoDB it's a good option) , csv files are a lot easier to handle c:
C# have a lot of library to convert from excel.

 

Hello, try this:

Code (CSharp):

1. public TextAsset narrativeTextFile;
2.  
3.  
4. string[] linesFromfile = narrativeTextFile.text.Split ("\n" [0]);
5. string currentTxt = linesFromfile [index];

The "TextAsset" file should be a .csv file.

 

For converting your excel file you can use converter. There have some reliable converter on the Internet. Search for them.