Unity-QuickSheet enables you to use google and excel spreadsheet data within Unity editor. With Unity-QuickSheet, you can retrieve data from a spreadsheet and save it as an asset file with a scriptableobject format even without writing single line of code.
It can retrieve data from excel file. (both of xls and xlsx format are supported.)
It can retrieve data from google spreadsheet.
No need to write a parser to retrieve data, it automatically serializes retrieved data into Unity3D’s ScriptableObject, the binary format and so it is fast than to use XML which is usually ASCII format.
Say again, you don’t need to write even single line of code!
I was looking for an easy way to import (export also would be nice) excel spreadsheet data into unity and I came across this, however after following the instructions in the readme I am still unable to import any data.
Does anyone know of an an alternative (possibly free) to this asset?
Nice to see you have replied and still keep an eye on your topic.
I’m sure it must be a silly mistake on my end but I’m determined to get this working.
Firstly when I import my spreadsheet I get this warning:
Secondly when I press the generate button, I get these errors:
And then when I reimport my .xls file it does not automatically create an asset file, I assume it’s because of these errors?
Okay quick fix, I took a wild guess looking at the error messages, I removed the space in the column “unit cost” and changed it to “unitcost.” Now it has successfully generated the asset, time to play around with this cool asset and see what I can do with it!
I do get this warning though, anything important?
P.S. I did try to import another spreadsheet and immediately after selecting the file all buttons/textboxes were minimised in the ExcelMachine Inspector window except the "File: " textbox, thus not allowing me to continue. Any idea why that was the case?
P.S.S. How would I obtain to get a value of any cell from the scriptable object?
Kimsama, thank you so much for such a useful tool !! And I really appreciate the sample attached. I am new to both Unity and C#, so it has been invaluable to have a sample. The first time I installed the tool, I quickly found a way to break it, since I don’t really know what I’m doing. I’ve reinstalled it and started modifying it bit by bit to make sure I don’t create any errors, and it’s working like a charm. For example, I’ve learned how to alter your spreadsheet and re-initialize the data to turn the integers into strings, and call that data in game.
But, I’m still very weak on the process of calling the data back, probably to my lack of knowledge of C# (I know some python but am a modder, not a true coder). Could you post a line or two of code here using your Enemy sample - for example, what if I just want to know how much damage bullet 3 does, how would I do that? I know I could call it with the ForEach and check all the data for a match, but I presume there’s a much easier way to do it, especially if I knew I wanted a certain cell/result.
