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

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

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()

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

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

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.

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")]

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!!

Remove those .pdf files which are old.

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

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

[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?

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.

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

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.

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.

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

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

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

Done on Pro side.

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

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,

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.

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 :).

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 inheritance for the created ScriptableObject derived class.

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

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

환경은 Unity 2019.2.2f1 입니다.

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.

Undefine values come back after switch among sheets.

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)

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

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! :)

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

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.

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()

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

Say I got a excel sheet like

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.

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

Need a hotfix.

Already done on Pro side.

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.

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

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

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 which is a string with comma separated form in a cell.

Setting excel path separately is tedious job.

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.

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

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

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

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.

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

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.

From over 5.3 unit test can run within editor.