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.
New
Bunch of documentation are updated (2017.01.29). See that on GitBook site, can be found on here.
Sorry to be such a newbie, but could you possibly provide a simple code example of how to retrieve data from the generated script files? Itās not clear from your howto docs, why the four files are generated (2 in the Editor folder and 2 in the Runtime folder), or how and when to use each one.
i.e. to populate a UI text object with data from my spreadsheet, which ScritableObject do I parse throughā¦ your-sheetpag-name.cs or your-sheetpage-nameData.cs ? And does this have to be done twice (the Runtime version and the Editor version, so that the data appears both at runtime and in the editor?)
A simple example project would be very much appreciated!
I assume youāve already know how to get data from excel and make it to an .asset file.
Let me show you the very simple and easiest way to retrieve data from the extracted asset file. As youāve mentioned, you have four generated files, two of them are under Editor folder and other of are any runtime folder youāve specified in the setting.
Letās say that you have Item worksheet in the excel file then you will get two generated script files, one is Item.cs and the other is ItemData.cs
public AssetLoader : MonoBehaviour { // It's ScriptableObject derived class which is generated under any runtime folder you've specified in the setting. // Drag .asset file onto 'item' member field from project view to Inspector view as any normal prefab file. public Item item void Start() { // Retrieves the first row ItemData itemData = item.dataArray[0]; Debug.LogFormat("Item Name: {0} Price: {1}", itemData.Name, itemData.Price); } }
Thatās all.
All of data are automatically loaded when AssetLoader class instance is created like the same way of what Unity does for a prefab. You donāt need to write even a line of code to load .asset data.
One more thing keep in mind that. Instead of directly accessing to the data as the above code snip, I highly recommend to use LINQ to query.
Looks cool! Any way to enter data for things like sprites or audio clips? I suppose you could just enter the Resource folder path where the asset is located.
Im not getting more than two columns of data from the spreadsheet, i created a test project and everything went fine. But itās not importing data of more than 2 columns, am I missing something?
Thanks for making thisā¦ Iām also testing this currently and getting missing cell contentā¦also I canāt see seem to get the array work. In the end I was hoping for that putting in text with line breaks into a cell would give me an arrayā¦something like āSentence on 1, Sentence 2ā¦ā but donāt know if that is supported behaviour?
I have also tried now using comma to separate, which actually do give me an arrayā¦although as my intended content is a sentenceā¦ there can be commas in it.
Yeah just noticed thatā¦as I got it to workā¦but yeah in my case I have to use commas I wont be able to use thisā¦unless I can modify it to support multiline text fields. Will try cleaning up and see if it populates all the fieldsā¦
If you want to new-line delimiter instead of comma, you need to modify code for yourself.
See the Assets\QuickSheet\GDataPlugin\Editor\GDataDB\GDataDB\Impl\Serializer.cs file and find Deserialze function.
public T Deserialize(ListEntry e) { var t = typeof (T); ... try { if (property.PropertyType.IsArray) { const char DELIMETER = ','; // '\n' // HERE!, changing ',' to '\n' is what you want. ...
Note that change of the above only valid on google spreadsheet not for excel file.
Got it working when I bypassed the processing of the cell content string a few lines down:
// remove whitespace between each of element string str = c.Value.ToString();//new string(c.Value.ToCharArray() // .Where(ch => !Char.IsWhiteSpace(ch)) // .ToArray()); // remove ',', if it is found at the end. char[] charToTrim = { ',', ' ' }; str = str.TrimEnd(charToTrim); // split by ',' object[] temp = str.Split(DELIMETER); Array array = (Array)Activator.CreateInstance(property.PropertyType, temp.Length); for (int i = 0; i < array.Length; i++) { array.SetValue(Convert.ChangeType(temp[i], property.PropertyType.GetElementType()), i); } property.SetValue(r, array, null);
So now the issue with missing field content is the only hurdleā¦
On OSX, not likely on Windows, you should check either carriage-return, ā\rā after ā\nā
So the line should be changed like the following:
const char DELIMETER = '\n\r';
Cheers,
ps. Some others prefer to use newline-breaker instead of using comma for array type. It may be better to set delimiter on somewhere in the configure file so the user determine and set the delimiter for their own. Iāll consider it later.
Yeah it would be nice if it would be possible to choose delimiter for each field, that would go nicely into the inspector where one declares type and if it is an array.
As the multiline fields workā¦there is only the issue with the missing content in the āField_IDā fieldā¦any ideas what could be causing this?
It could be the same issue as the previous user hasā¦as Iāve used it successfully with a table with only two columnsā¦and this one has more than 2ā¦ =O
