newbie, simple script to check excel file to dispaly object

Questions & Answers
1

hey, im very new to this it will become quite aparent in my post but would appriate any help

basically i have a virtual warehouse type game i made and i want my game.exe to check a excel file in the same directory as the exe

and my excel file will have first column Pallet1, pallet2, pallet3, etc and in second column have 1 or 0

in the game i will place pallets all over the place and if the value in excel is 1 i want to display the pallet if its 0 i don’t want to display the pallet, i will need to be able to call the pallets different names

also have some minor additions to this request if anyone is willing to help

will pay for a simple plugin if needed

2

Copy you exported CSV file to a Resources folder in your project.

Load it like this:

      var textAsset : TextAsset = Resources.Load("NameOfFileWithoutTxt", TextAsset);

The you can get the lines and sub elements like this:

    import System.Linq;
    import System.Collections.Generic;

    ...

    var textAsset : TextAsset = Resources.Load("NameOfFileWithoutTxt", TextAsset);
    var data = textAsset.text.Split("

“[0]).Select(function(line) { return line.Split(”,"[0]); }).ToArray();

And now you can do:

     //Get line 4 column 3
      var d = data[4][3];
3

thanks heaps Mike ill give it ago after work