If you’re doing game development there is a high chance that you will use some sort of data management software. And if you are then there is also a high chance that software is Google Sheets.
Introducing Sheet Codes: The first tool that takes the user friendliness from Google Sheets and combines it with Unity Editor’s functionality. All your data in 1 place without any coding required.
Support for ALL Unity data types such as Texture, GameObject, Animation, Scene. Support for ALL base types such as int, string, double. Support for ALL Enums that exist within your project. Support for ALL Scripts that inherit from Unity.Object within your project. Support for Arrays of any type mentioned above. Recently added support for Colors too.
All of this combined in an easy to use fully custom editor window.
Resize your columns and rows.
Reorder your columns or rows**.** Custom built-in editor display to edit your Arrays. Reorder/insert/remove Arrayelements with ease.
Create multiple Sheets.
Automatic code generation for easy data access andno casting.
Sheet codes free has been updated to v1.1: Features: 1: Added a new datatype: Color
Bugfixes 1: using ‘/’ characters in row names or sheet names no longer causes weird dropdowns 2: Creating a sheet named ‘BaseClasses’ could cause problems so it’s no longer possible. 3: Changing a property name no longer causes that column’s data to disappear 4: Insert left/Insert right was mistakenly called Edit left/right 5: Creating a reference column no longer crashed the tool when referencing a sheet that also needs to be generated.
Misc: 1: Warning comments added to generated scripts 2: Removed code insert /Location/ from generated scripts 3: Increased size of sheet selection dropdown 4: Increased max width of cells 5: Decreased max height of cells
All of these changes are already in the full version.
Sheet codes Free and Sheet Codes have been updated to v1.2: Features: 1: Added load/unload operations to ModelManager 2: Added Async load operations to ModelManager 3: Sheets are now individually loaded instead of all together.
Bugfix: 1: Models are now no longer regenerated after making changes to your data.
Misc: 1: ModelManager is now no longer a ScriptableObject.
When updating to v1.2 please refer to the updated documentation.
@Skulltager , this almost looks to good to be true! Just to check now - can you add to and delete (get as well as set cells, rows, tables) in runtime too?
[edit] Also, what about scriptable objects as a data type?
All data is read only during runtime. ScriptableObject data is saved when edited during runtime so I’ve intentionally prevented that from happening by accident.
Since all data is determined in the editor and all data is read only the features from lists aren’t needed. That’s why all data is currently stored as arrays.
I do have plans to add the ability to edit data during runtime. However I need to make sure it doesn’t change the data from the scriptableobjects. At that point I’ll also add the option to have your data be stored as a List or an Array.
@Skulltager - excellent - thanks for coming back to me so quickly on this on both the forums and discord. Nice to see that, a week in, this asset is already being enhanced and is already on v1.2. I have purchased.
V1.3 of SheetCodes is now live. Safely edit your record’s data at runtime without your scriptableobjects getting messed up. All getter & setter code automatically generated and documented.
Features: 1: Model Records can now be edited and saved at runtime. Create an editable copy of the record you can adjust without changing the ScriptableObject. Apply your changes with a single function call.
Bugfix: 1: Window location no longer changes slightly when opening/closing the arrayedit panel. 2: Fixed a nullreference that could occur when changing from 1 component type to another
Misc: 1: Documentation for editing records added. 2: Documentation for updating to version 1.3 added
