Yade Sheet

Yade is a spreadsheets based data tool, it provides easy to use spreadsheet editor and data access runtime.

Documents | Forum | Email

● Easy to Use Spreadsheet Editor

Yade provides Excel or Google Sheets like spreadsheet editor. We can easily to EDIT, SEARCHING, IMPORT, or EXPORT data inside Unity Editor. The editor aslo has cool features like Formula, Bulk Import, Column Header Settings, Code Generator and Dark Theme Support etc.

● Easy to Use Data Access Runtime

Yade provides Directly Sheet Access, Sheet Data Deserialize to C# Objects and Fast Binary Serialization APIs. Deserialize to C# objects supports custom data types which are implemented ICellParser interface. More details about Runtime APIs visit online document.

Yade also provides Online Sheet Data Access APIs at runtime for reading online csv files and Google Sheets public share link. So that it's possible update existing data in application at runtime. See more detail in online document.

● Yade is Extendable

Yade Runtime and Spreadsheet Editor can be extended. Like add new formula or importing data from JSON files. More details about how to extend, please visit online document.

● Compatibilty

Spreadsheet Editor supports Unity Editor 2019.3.0+.

Yade Runtime supports almost all platforms that support ScriptableObject.

● Third-Party Supports

Playmaker, FlowCanvas

Release Notes

## Version 1.5.5

**NEW**

- Able to hide customized exporter/importer/conextmenu by override the `IsAvailable()` method

**IMPROVE**

- Improve Copy&Paste logic to support Copy from/To Excel or Goggle Sheets

**FIX**

- Fix bug that keyboard are not repsonse after tab switch many times

- Fix bug that column settings are not changed accordingly after inserting or deleting a column

- Fix bug that content of top cell editor are not updated accordingly after copying content to cell

- Fix bug that column index are not update when there are many columns in some cases

## Version 1.5.1

**NEW**

- Add context menu for headers that supports:

- Insert rows or columns

- Delete rows or columns

- Clear contents of selected rows or columns

## Version 1.5.0

**IMPROVE**

- 'ALT' + `ENTER` also support in top cell editor

- Unity 2022 compatiblity

**FIX**

- Fix height of a row in spreadsheet editor is missing when there are no cells in row

- Fix sometimes cannot edit cell in top cell editor

- Fix use `ENTER` key to move to down cell will enter into edit mode

## Version 1.4.8

**NEW**

- Spreadsheet editor supports `Alt`+ `Enter` to break a new line in cell

**FIX**

- Cannot input form keyboard on Unity 2022.1

- YadeDB Query failed after yade sheet is renamed

## Version 1.4.7

**FIX**

- Fix YadeDatabase get old data after copyto in some cases

- Fix Yade Sheet reference missing in Unity Editor

## Version 1.4.6

**NEW**

- Add Online Sheet Data support. Current support Google Sheets (public share link) and online CSV file. More details see online documents

- Add Online Sheet Data Demo

- Add CopyTo method to YadeSheetData class that can copy all sheet data from one Yade Sheet to anther Yade Sheet.

**FIX**

- Fix bug the CSV Exporter export empty data sometimes

- Fix bug that Bulk Import Edit failed to import Google Sheets in some cases

## Version 1.4.5

**NEW**

- Add ASSETS function to support assets array. We can drag and drop assets to one cell in spreadsheet editor and data of the cell will deserilize to array or list of Unity Objects

- Auto Fill supports fill number series now

**FIX**

- Fix cell contains access will show as not available after enter and then exit Play Mode

## Version 1.4.3

NEW: Add bulk importer which supports import data from multiple data sources in one click, see the online doucment about bulk importer.

## Version 1.4.2

NEW:

- Add Sort Sheet By Column feature

- Add ability to add context menu item to Spreadsheet Editor by inherit abstract class `ContextMenuItem`

IMPROVED:

- Spreadsheet editor can remember last open folder when importing/exporting from files

- Reduce Yade sheet file size by remove duplicate values stored

- Improve Spreadsheet editor performance

FIXED:

- Fix YadeDatabase is not reset when Reload Domain is disabled in Enter Play Mode Setting of Unity Editor

- Fix click on header will show context menu of cells instead of context menu of headers when selecting whole columns

- Fix cell text alignment are not align to upper left

## Version 1.4.1

NEW:

- Invalid formulas or invalid value of formulas will show as `#N/A`

- FlowCanvasIntegration.unitypackage included in package instead of downloading from web

- Add Help icon button on toolbar of spreadsheet editor

IMPROVED:

- Update help url for YadeSheetData and YadeDatabase class

- Combine Import and Export drop down to one

FIXED:

- Update BinarySerializationTest demo to make it works on WebGL

## Version 1.4.0

NEW:

- Add Binary Serialization support for YadeSheetData and YadeDatabase. These APIs are working when `BinarySerializerEnabled` property is set to true [Experimental]

- Add `Ctrl + S` on Windows and `Cmd + S` on macOS to save data manually

IMPROVED:

- Improve alpha based cell index to cell index performance by caching

- Improve that arrows keys and copy&paste shortcuts are works for for cell text input when editing cell data

FIXED:

- Fix bug that after cell updated, `YadeDB.Q<T>()` method return list that contains old data

- Fix bug that top cell edit not update value when data revert from version control software

- Fix bug that data added by SetRawValue methods keep exits after exiting play mode in Unity Editor

Access full chage logs at https://www.amlovey.com/YadeDocs/#/ChangeLog?id=change-log