Working with excel spreadsheets?

[Alpha_Player]

Hi. I have this Spreadsheet in my project. I need to access the file to read and write to this spreadsheet (the data is of course the most important part), plus reading and writing the formatting options for cells (mainly colour, border and text style) and adding / removing rows. I tried googling a bit but couldn’t find much, all C# libraries for excel files seem to either be discontinued or incomplete; is there anything like openpyxl that works with C#?

Also is there a way to work directly with Unity and the Google Sheets API? I need to upload any changes I make to the spreadsheets, but I checked the Google API and it doesn’t seem to support C# so I don’t think there’s any direct way of interacting unity → google sheets. It’s not a problem right now as I have a python script that can upload/download the file, but maybe there’s an easier solution and I missed something.

[Kurt-Dekker]

@Alpha_Player

Also is there a way to work directly with Unity and the Google Sheets API?

Yes. It’s just a web call with some kind of auth token.

@Alpha_Player

but I checked the Google API and it doesn’t seem to support C# so I don’t think there’s any direct way of interacting unity → google sheets.

It’s a web API call, it has nothing to do with any programming language and also has nothing to do with Unity.

Networking, UnityWebRequest, WWW, Postman, curl, WebAPI, etc:

Using Unity for subscription lists

As with all network code, get it working with Postman or curl first. That makes it NOT a Unity problem. Solve the networking first. You must solve that or anything else is irrelevant. Once you have that working, then try and port it to UnityWebRequest. If it still doesn't work, one handy debug solution is to hook up a proxy like Charles and compare the functioning output from Postman / curl to the output from Unity, and from that reason about where your issues are.

Unity web request acting stupid.

Always get network stuff working outside of Unity in either curl or PostMan, then connect a proxy such as Charles and start trying to replicate the traffic shape with UnityWebRequest. Any other way risks wasting a lot of your time for trivial issues that only the above way will instantly reveal.

And setting up a proxy can be very helpful too, in order to compare traffic:

Using Charles Proxy with Unity

[Alpha_Player]

Hey, thanks for the reply.
I’m not very experienced in these things, I was reading the tutorial on the Google Developers website:

Google Sheets API Overview  |  Google for Developers

Here, when I look at the quickstart guide it talks about a few different languages and installing the Google Sheets library.

Also, do you know anything about my other question? That’s my main concern.

Thanks again for the reply

[Alpha_Player]

I found this page:

Google Sheets API  |  Google for Developers

is this what you’re talking about?

[Kurt-Dekker]

@Alpha_Player

do you know anything about my other question?

Do you mean about the formatting and coloring? I know that’s not portable. It might be exposed in the API somehow. Probably best to start with the docs. I have only used google sheets for localized text.

Ideally keep all your data IN Unity, perhaps in a CSV file you parse, or else in ScriptableObjects or JSON.

Adding an extra external step is only justifiable when your workflow benefits from it.

If you just need lightweight runtime configuration changes, Unity offers a remote configuration package, and others do it too such as Firebase and Leanplum.

[SeerSucker69]

Have you checked the Unity Assets store for addons?

[Laicasaane]

@Alpha_Player

Also is there a way to work directly with Unity and the Google Sheets API? I need to upload any changes I make to the spreadsheets

You should install the localization package and see how Unity has done this, given that it’s for the Editor only.
https://docs.unity3d.com/Packages/com.unity.localization@1.4/manual/Google-Sheets.html