Does anyone know if you can transform an object based on excel data? Basically I have 20 XYZ values in excel, and I was wondering if you could animate an object in a scene using those values over time.
Excel files - at least since 2007 - are just zipped I think. So if you open one with, for example, WinRAR the excel worksheets are saved in xl/worksheets/sheet1.xml, sheet2.xml and so on. Parsing these xml files you can get the values of every cell. Just google something like “csharp read excel file” for details.
Then you can use these values to animate your object.
Howabout exporting the data out as a comma-separated-value file, import that into Unity as a text asset. You can then read this text asset and mine out the values.
It can be done, I’ve done it. Since we haven’t decided what to do with the code, maybe sell on Asset store, I can’t give it to you. But it’s not all that difficult.