Unity Excel Integration

Hi!

I have an Excel spreadsheet with a list of items I have in a scene. There are thousands of them, each with a different ID. Some of them are new, some of them are old. My task is to sort them in the hierarchy and to place them in 2 different game objects based on their status. The spreadsheet has the new ones. Is there a way to import the Excel file, read the first column with the ID, and based on that sort the items in there?
I could also export the Excel as a CSV and then use that, but how can I sort the hierarchy automatically?

Thank you!

 

ive seen some unity-excel plugins in github,
https://github.com/tsubaki/Unity-Excel-Importer-Maker
https://github.com/joexi/Excel4Unity
https://github.com/kimsama/Unity-QuickSheet
and some others too..

but probably easies to use .csv (sort first in excel, or sort manually in script)
can google for some c# solutions to sort csv data, like https://stackoverflow.com/questions/16763992/sorting-csv-data-by-column-c-sharp

 

@mgear thank you for the sources. Do you have any idea if the hierarchy can be sorted using my own algorithm?

 

can you give some example rows, and how it should look like (after sorting)?

 

Yes. In the spreadsheet the first column has 4 digit codes like {bibl, xida, t123, kg23}. In the scenes there are gameObjects with the name A4. All of them have the same name, none of them are parented to anything. All objects have a material attached that has the a code made of 4 digits, like I showed earlier. What I would like to do would be to go through all objects in the scene, get the material, check if the name is found in the sheet. If it is, nest it under object currentMaterials, if not then nest it under archivedMaterials.

Hmm.. writing this made me think of a possible solution. I'll get to it and come back with an update.

 

I found some documentation here. It might help
https://stackoverflow.com/questions/28975829/create-gameobject-and-save-in-hierarchy

 

I figured it out, I made a test project and it worked, I now need to try on the main data. Thank you!

 

Hi, @lordsterben. I think you should use ZetExcel.