kimsama/unity-quicksheet

Unity-QuickSheet enables you to use spreadsheet file data within Unity editor.

unity-quicksheet's Issues

Detecting text cell as numeric cell in excel

I chose a field, in excel machine, which supposed to be string.

The field in excel containing just single numeric value. Eg : '1', '2'

It gives me an error message like: Cannot get text value from a numeric cell Row.

In some way I need the value to be string. So I need to make it a string instead of integer.

I tried to format particular column in excel to Text, but still getting same result, which the plugin recognize the cell as numeric value instead of text value even I choose import as string

Considering to put [CreateAssetMenu] within generated script file

Unity now support [CreateAssetMenu] attribute which can automatically create scriptableobject asset file into project view.

It can replace 'Reimport' action to generate scriptableobject asset file.

Support unit test

From over 5.3 unit test can run within editor.

AssetPostProcessor error CS1009: Unrecognized escape sequence

When generating code from an excel xlsx file using Unity 2018.3.6f1, I get "error CS1009: Unrecognized escape sequence" on the NAMEAssetPostProcessor.cs file.
Apparently the assetFilePath replacement uses Assets\ instead of Assets/
simple to edit and fix in VStudio, but shouldnt be necessary.

Support for Excelfile placed under StreamingAssets folder

I want to place Excel file under StreaamingAssets folder so that after creating exe I can edit the excel file from outside and live link will be established between dta and Unity objects.
I have successfully generated import settings But the moment I re-import it is generating blank scripted asset and throws following error
NullReferenceException
Sheet1AssetPostprocessor.OnPostprocessAllAssets (System.String[] importedAssets, System.String[] deletedAssets, System.String[] movedAssets, System.String[] movedFromAssetPaths) (at Assets/CC_PravinYadav/Excel/Editor/Sheet1AssetPostProcessor.cs:42)

[Google] 'Update' does not append only newly added column but do all columns

'Update' button on google machine setting file does not append only newly added column but do all columns.

Reflecting array type on Inspector

[ExposeProperty] attribute does not support to reflect array type on Inspector view.

Need replace of [ExposeProperty].

Some resources found on online:

• SerializedObjectEditor - most of all are well described.
  • Advanced SerializedProperties - similar with the above
• Display A List With A Custom Editor Script
• How can I recreate the Array Inspector element for a custom Inspector GUI?

Separating between array elements on google spreadsheet is different with excel.

Google:  1,2,3,4
Excel:  1,2,3,4, 

Excel needs last ',' to correctly import all array element but Google does not need that.

change repo to be 'subtree' friendly

Not with being a whole Unity project but with subtree(NOT submodule) is better for managing QuickSheet

See this post

Other References:

• sharing code between Unity projects
• Projeny

Underscore character in column name will break import

If a column name contains an underscore e.g. "Option_A" or "Item_Price" the download will silently fail and leave that field empty.

Error creating Array with Google Sheets

Hi there,

I'm getting an error creating an array. I've tried using strings and int dataTypes and I've used tabs, comma's and comma's with one space to seperate my data in my google sheet but nothing seems to work when I download the sheet.

Here's the error:

GDataDB Serialization Exception: Value is not a convertible object: System.String to System.String[] ListEntry LocalName: arraytest
UnityEngine.Debug:LogError(Object)
GDataDB.Impl.Serializer1:Deserialize(ListEntry) (at Assets/QuickSheet/GDataPlugin/Editor/GDataDB/GDataDB/Impl/Serializer.cs:71) GDataDB.Impl.Table1:Find(FeedQuery) (at Assets/QuickSheet/GDataPlugin/Editor/GDataDB/GDataDB/Impl/Table.cs:99)
GDataDB.Impl.Table1:FindAll() (at Assets/QuickSheet/GDataPlugin/Editor/GDataDB/GDataDB/Impl/Table.cs:52) testEditor:Load() (at Assets/Editor/Data/testEditor.cs:67) UnityQuickSheet.BaseGoogleEditor1:OnInspectorGUI() (at Assets/QuickSheet/GDataPlugin/Editor/BaseGoogleEditor.cs:97)
testEditor:OnInspectorGUI() (at Assets/Editor/Data/testEditor.cs:35)
UnityEditor.DockArea:OnGUI()

nunit.framework.dll causes conflicts with unit tests

If you use Unity's built-in NUnit to write your own tests, nunit.framework.dll in the following folder causes a conflict at compile-time:

https://github.com/kimsama/Unity-QuickSheet/tree/master/Assets/QuickSheet/GDataPlugin/Editor/Google

I do not believe this dll is necessary to ship anymore and can be removed. Related to #23.

long value overflow when check unity inspector

long 값들 인스펙터에서 확인시에 값이 오버플로우 나는거 같습니다.

환경은 Unity 2019.2.2f1 입니다.

Step 3) Importing Spreadsheet Data 관련 질문이 있습니다

doc에서 보면 Step 3) Importing Spreadsheet Data에서 다운로드를 유니티에디터상에서 버튼을 눌러야 하는데 이부분을 앱에서 실행하고싶은데 가능한가요?

Warning on Unity 2018 and above

After imported the plugin into my project, a warning message always appears when I open my Unity Editor (version 2019):

There are menu items registered under Edit/Project Settings: QuickSheet/Select Excel Setting, QuickSheet/Select Google Data Setting
Consider using [SettingsProvider] attribute to register in the Unified Settings Window.

UnityEditor.EditorApplication:Internal_CallUpdateFunctions()

Seems that since version 2018, Unity don't want us to put any menu items under "Edit/Project Settings" anymore. Therefore, I suggest to change

[MenuItem("Edit/Project Settings/QuickSheet/Select Google Data Setting")]

and

[MenuItem("Edit/Project Settings/QuickSheet/Select Excel Setting")]

to

[MenuItem("Edit/QuickSheet/Select Google Data Setting")]

and

[MenuItem("Edit/QuickSheet/Select Excel Setting")]

unused column

What about unused column?

For example there are 5 columns in "Character" sheet.
"name", "_desc", "ap", "dp", "maxhp"

But I do not want to import "_desc" column into scriptableobject.

Error while importing Excel file data

This error message is appearing while I'm trying to import from an Excel sheet. There are no empty cell in my sheet. Tried debugging with deleting some rows and columns. Always having an error saying empty cell at LAST column.

Even an older version of the excel sheet is working fine which has lower rows and columns. My excel sheet is multilingual btw.

Gathering data as Goolgle Sheet API python does?

It is more question than an issue.

I first made the GoogleSheetAPI integration from Maya with python to manage assets for 3D artists in my team.

GoogleSheetAPI reference :

• https://developers.google.com/sheets/api/quickstart/python

Now using the same GoogleSheet to build an interface to check and test assets.

1st I made a parser from a local file with set classes, etc.... (from the *.tsv file downloaded via the GoogleSheet interface).

2nd with the GoogleSheetAPI it return value from the cell range value : (rangeName = 'Class Data!A2:E')
It let me get the value in an array. (values = result.get('values', [])
Which I can use the same parser as the local file.

3nd now from Unity, every ready and working the same way as the Maya python script.
But my very last step would be to catch the GoogleSheet data as plain text from an array as the Python API does...

Since you probably gather the data this way at some point, is there a way to access to it?
I actually do not need anything else...

Also would like to access the online data at anytime from C#...

Thank you by advance! :)

Default value

Is there a way to set default value to a variable if it's an empty cell when import from Excel?

Not to reset already defined types when reimporting

Whenever reimport a spreadsheet all types are reset, even the changes are adding a few columns or change of column name.

Always int row error

it always show to me this error wwhen i try to set up my xlsx table.
here : Invalid column header name {0}. Any c# keyword should not be used for column header. Note it is not case sensitive.
https://image.ibb.co/dRctt6/Cattura.png

and here the table sample

Using UnityEditor.IMGUI.Controls to display column header on a Import Setting.

There is a new API set, added on Unity 5.6.x, still it is beta stage though, under the UnityEditor.IMGUI.

• MultiColumnHeader

UnityEditor.IMGUI.Controls seems to be one can replace current column-header setting.

The problem of the current column-header setting is that it works fine but got a bit nasty in the code side.

So, it can be better to change with MultiColumnHeader when it is available after releasing final version of Unity 5.6.x.

Support inheritance

Support inheritance for the created ScriptableObject derived class.

Already done on my work side, need to port to the github project page.

구글 스프레드시트에 접근이 되지 않는 문제

안녕하세요?
어제부터 구글스프레드시트에서 데이터를 받아오지 못하고 있습니다.
https://code.google.com/p/google-gdata/issues/detail?id=716
위와 관련된 이슈인 것 같습니다.

Always need to Select Google Data Settings to update/Reimport.

Hi,
When i try to re import data it will show this error. "Failed to get google data settings. See the google data setting if it has correct path."
After i go to folder and select this file and try again, then only it re imports data.
Doing this always is pain.

[minor issue] prevent to generate script files without specifying any spreadsheet file and its worksheet.

Even default script files are generated without specifying any spreadsheet file and its worksheet.

Need a hotfix.

Already done on Pro side.

Google DLL Version Mismatch

The Google.GData.Client.dll has not been updated for 2 years while all the other dlls have been updated 11 months ago. Downloading and using this project in its current state creates a version mismatch error between the Client.dll and the Spreadsheets.dll. The Client.dll is Version 2.1 while the others are 2.2+

support xslx file

need to read not only .xsl but also .xslx file.

Put the project classes in a namespace

Hi,

Some of the project classes conflict with our own ones (eg Singleton).
Therefore it should be nice if you put them in a namespace.

Thank you,

All spaces are ignored for string type when Generating asset file from excel sheet.

Title says it all. Can't find where the ignoring code is written.

Update NPOI with the latest version

The version of NPOI is quite old, need to be updated.

Currently installed version is 2.1.1 and the latest stable version on CodePlex site is 2.2.1.

If column name is `value`, the import value will not get assigned

Say I got a excel sheet like

key	value
A	B
AA	BB

The code generated for the value row would be

[SerializeField]
  string value;
  public string Value { get {return value; } set { value = value;} }

Making that value never get assigned. I would suggest adding changing setter to this.value = value to avoid ambiguity.

Remove pdf doc under the 'Doc' folder and make a new one

Remove those .pdf files which are old.

Considering to make pdf documents files with gitbook-cli, seems to be nice option for that job.

Enables 'DELIMITER' to set on the setting file.

Enables 'DILIMITER' which is used to separate each of array element in the cell to set on the setting file.

Someone prefer to use new-line separator than a comma so it may be better to make a user to choose the delimiter on the setting file.

Cannot import Google Sheet

It gives me this error after I click import button. I didn't set Google two-stage verification on.

GDataRequestException: Execution of authentication request returned unexpected result: 404
Google.GData.Client.Utilities.getAuthException (Google.GData.Client.TokenCollection tokens, System.Net.HttpWebResponse response)
Google.GData.Client.Utilities.QueryClientLoginToken (Google.GData.Client.GDataCredentials gc, System.String serviceName, System.String applicationName, Boolean fUseKeepAlive, IWebProxy proxyServer, System.Uri clientLoginHandler)
Google.GData.Client.GDataGAuthRequest.QueryAuthToken (Google.GData.Client.GDataCredentials gc)
Google.GData.Client.GDataGAuthRequest.EnsureCredentials ()
Google.GData.Client.GDataRequest.EnsureWebRequest ()
Google.GData.Client.GDataGAuthRequest.EnsureWebRequest ()
Google.GData.Client.GDataRequest.Execute ()
Google.GData.Client.GDataGAuthRequest.Execute (Int32 retryCounter)
UnityEditor.DockArea:OnGUI()

Inspector display issue in excel with mutiple sheets.

Undefine values come back after switch among sheets.

A large number of imports slow down

When the number of rows in the excel table exceeds one thousand, the import will become very slow and slow.

Load data exception

When i use your tool to load my xlsx file, this issue happens

NPOI.POIXMLException: ---> NPOI.OpenXml4Net.Exceptions.InvalidFormatException: Can't read content types part !
at NPOI.OpenXml4Net.OPC.Internal.ContentTypeManager..ctor (System.IO.Stream in1, NPOI.OpenXml4Net.OPC.OPCPackage pkg) [0x00000] in :0
at NPOI.OpenXml4Net.OPC.Internal.ZipContentTypeManager..ctor (System.IO.Stream in1, NPOI.OpenXml4Net.OPC.OPCPackage pkg) [0x00000] in :0
at NPOI.OpenXml4Net.OPC.ZipPackage.GetPartsImpl () [0x00000] in :0
at NPOI.OpenXml4Net.OPC.OPCPackage.GetParts () [0x00000] in :0
at NPOI.OpenXml4Net.OPC.OPCPackage.Open (System.IO.Stream in1) [0x00000] in :0
at NPOI.Util.PackageHelper.Open (System.IO.Stream is1) [0x00000] in :0
--- End of inner exception stack trace ---
at NPOI.Util.PackageHelper.Open (System.IO.Stream is1) [0x00000] in :0
at NPOI.XSSF.UserModel.XSSFWorkbook..ctor (System.IO.Stream is1) [0x00000] in :0
at ExcelQuery..ctor (System.String path, System.String sheetName) [0x00047] in /Users/huytran/Documents/workspace/sumTrack/Assets/Extensions/QuickSheet/ExcelPlugin/Editor/ExcelQuery.cs:41
UnityEngine.Debug:LogError(Object)
ExcelQuery:.ctor(String, String) (at Assets/Extensions/QuickSheet/ExcelPlugin/Editor/ExcelQuery.cs:53)
ExcelMachineEditor:OnInspectorGUI() (at Assets/Extensions/QuickSheet/ExcelPlugin/Editor/ExcelMachineEditor.cs:50)
UnityEditor.DockArea:OnGUI()

Working environment: Mac OSX 10.10.1; Unity 4.5 Pro
Input data is attached as this below link
https://dl.dropboxusercontent.com/u/63045417/map_test.xlsx

Access public google spreadsheet without login

This post explains the way access google spreadsheet without login.

http://www.blog.radiator.debacle.us/2013/12/reading-public-google-drive.html

Interesting but not sure it especially useful though.

Consider to use Reorderlist for type setting menu.

Consider to use Reorderlist for type setting menu. It seems to be more intuitive way.

create .asset file when it generates code and set excel path and sheet to that

Setting excel path separately is tedious job.

Error to parse oauth2 json file for google drive from Alberto Sánchez

See the original post below:

Hi again, thank you for helping me out before!

I have another question, I hope you can help!

I am getting an error when I am trying to load a JSON file from console.developers.google.com.

I made GoogleDataSettings.asset, then loaded the JSON file I downloaded, but I can't see the Client ID and the Client Secret on the Inspector, because I get this error:

NullReferenceException: Object reference not set to an instance of an object
UnityQuickSheet.GoogleDataSettingsEditor.OnInspectorGUI () (at Assets/QuickSheet/GDataPlugin/Editor/GoogleDataSettingsEditor.cs:107)
UnityEditor.InspectorWindow.DrawEditor (UnityEditor.Editor editor, Int32 editorIndex, Boolean rebuildOptimizedGUIBlock, System.Boolean& showImportedObjectBarNext, UnityEngine.Rect& importedObjectBarRect) (at /Users/builduser/buildslave/unity/build/Editor/Mono/Inspector/InspectorWindow.cs:1231)
UnityEditor.DockArea:OnGUI()

Apparently because of this line on GoogleDataSettingsEditor.cs.

var oauthData = JObject.Parse(jsonData).SelectToken("installed").ToString();

I think it is trying to load the data from the token "installed", but it doesn't exist on the JSON file!

Do you know how to solve this so I can verify my account and load data from Google Drive?

Thank you!!

excel - should check header column has empty string.

an header column which has an empty string for its value is imported. Check and it should be fixed.

GoogleDataSettings reports an error if repository used as SubModule.

If I subModule the repository in an empty project and clone it in a folder "Assets/__submodules/Unity-QuickSheet", it always callback the error as shown on the following screenshot.

If the repository is cloned and then open the project with Unity, there is no error at all.

Would be better if I can submodule then can work from my project then always keep your project up to date :).

Mistype

Is:
Create->QuickSheet->Tools->Goolgle
Must be:
Create->QuickSheet->Tools->Google

consider querying and updating inspector view with running other thread

See

http://answers.unity3d.com/questions/305882/how-do-i-invoke-functions-on-the-main-thread.html

Also can be accessed on here: https://gist.github.com/kimsama/a0cf529f5e9f97bfa5a0

Out of range error while importing array of enum values

I'm using QuickSheet to import data from google sheets. I've tryed to import array of enum alues. QuickSheet imports data correctly (it whould be much better if you mention about flags ability of enums in documentation... i was expecting an array of enums though flags enum is more correctly). But watching on data scriptable object in Inspector leads to massive oet of range error messages spam. They appear because enumValueIndex in GUIHelper class can't handle whith multivalue enum. If enum property is multivalue the enumValueIndex returns -1 which leads to error message.

I've added some code to solve the problem my way, but i'm not experienced enouth to find professional solution of this problem.

string text = "";

if (prop.enumValueIndex >= 0)
    EditorGUILayout.PropertyField(prop); 
else
{
    EditorGUILayout.TextField(prop.name + " (int value)", prop.intValue.ToString()); 
    text = " => outofrange error";
}

    EditorGUI.indentLevel++;
    EditorGUILayout.LabelField("enumValueIndex = " + prop.enumValueIndex.ToString() + text);

Sorry if doublig...

Support array type.

Support array type which is a string with comma separated form in a cell.

Change 'enum' type setting to use textfield control.

Let a user to force type name of an enum type in the textfield. It is better for an error proof way.

Refactoring ExcelMachinEditor and GoogleMachineEditor classes.

write some common virtual methods on BaseMachineEditor class and remove redundant methods from both of ExcelMachinEditor and GoogleMachineEditor class.

Done on Pro side.