Write and Read Excel(xlsx) , Unity3D

Unity Engine
1

Hello,

First of all apologize for my bad english. I used many libraries but unity3d did not accept those libraries.

lastly I used this library(JSON to Excel in C# | Convert JSON to Excel | Import JSON Data to Excel). Looks like a nice library but unity3d didn’t accept this library either.

When I write the code, it recognizes the library but when I try to run it, it suddenly loses the library(as in the picture)
=> htt1On.jpg

But when I look at NuGet, I see that the library is installed.(as in the picture)
=> TnbonR.jpg

Error Message : Assets\Scripts\SaveData.cs(3,7): error CS0246: The type or namespace name ‘Aspose’ could not be found (are you missing a using directive or an assembly reference?)


I want to use this library and I am waiting for your help
Regards,

2

It is unlikely you will get this to actually interoperate reliably, based on my own experience trying to integrate the XLSX libraries on the PC side in a very simple case.

I recommend you consider an open simple text-based format such as JSON for your data needs, otherwise you are almost certain to be fighting with Microsoft DLLs for the rest of your project’s life.

1 Like
3

Would CSV files satisfy your needs? They don’t have as many features as a full Excel spreadsheet, but they have spreadsheet-like organization, they are very easy to read and write, and Excel can save and load them.

You’re not likely to find someone here who is familiar with a specific third-party library unless that library is enormously popular. If you need help getting it to work, you should ask someplace associated with that library, rather than just associated with Unity in general.

1 Like
4

Hello,

I solved the problem with .txt file and i have successfully read the txt file I gave in excel :slight_smile: but i will try CSV files for it

thank you for your support

1 Like
5

If anyone is still interested in this topic, check out my open source project:
https://github.com/cathei/BakingSheet

You can easily read xlsx with Editor script into your own C# class and serialize/deserialize it with JSON for builds.
Sorry for commenting old thread but this is top search on google :slight_smile:

1 Like