Search Unity

Retrieve information from certain columns and rows from a spreadsheet?

Discussion in 'Formats & External Tools' started by bigpawh, Apr 17, 2018.

  1. bigpawh

    bigpawh

    Joined:
    Apr 17, 2018
    Posts:
    3
    So I have a spreadsheet with hundreds of cells of data. I can't imagine how painful it would be to hardcode all of that. So let me tell you my situation:

    I have a ParameterManager script (and an empty object with it) which has a bunch of bool values representing two columns each. I also have two integers, a minimum and a maximum, representing the first and last rows (including everything in between). If the bool value foo is true, I would want columns one and two to be included into my random data selector. If the bool value for bar is false, I do not want columns three and four to be included.

    Similarly (and this is perhaps a different question altogether, so tell me if I should make a separate thread), if the minimum value is 5, and the maximum is 13, I only want those columns to include rows 5-13 (inclusive).

    Thank you for reading! I don't need a bin of code, just some guidance :)