Import array indices from Excel

Question

In an Excel file, I have some numbers which I will use as the indices of arrays. I want to read those numbers and assign them as the array indices in Mathematica.

For instance, in Excel I have

and I want the rows to be imported as follows in Mathematica:

{{x[[1]], x[[1]], x[[10]], x[[12]], x[[1]], x[[2]], x[[11]], x[[3]]},
 {x[[1]], x[[1]], x[[12]], x[[14]], x[[1]], x[[3]], x[[13]], x[[4]]},
 ... }

Link to download the excel file: http://www.datafilehost.com/d/477a157f

Answer 1

Here's another version:

Import["~/Downloads/NodeNumbers.xlsx"] /. ind_Real :> x[[Floor@ind]]

Answer 2

Given your data in the link, e.g.:

arrayList = 
 Map[x[[#]] &, 
  First@Round[Import["c:\\users\\rasher\\downloads\\nodenumbers.xlsx"]], {2}];

will give you the symbol arrayList containing the list of lists of x indexed using the values in the spreadsheet.

Note that if x does not already exist with enough values, you'll get error messages. You can append //Quiet to the above if you just want a list of lists of indexed x - if/when you create and fill x, arrayList entries will take on the appropriate values. The messages (if x does not exist in proper form) are from attempting to reference something non-existent. You could also Hold the entries to avoid this, but I'm not clear what the end result you're after is...

If there's something else you had in mind, you'll need to further clarify your question.