Transferring an excel row value to an array

[Sarav]

Can anyone please help me with the syntax to transfer an excel row values to an array?

I did not find this syntax in the help file. It shows how we can open it/ write output in excel but not more than that.

Say for example, i have an excel file "Sample.xls"

I have a row name [A1 = "Name"] which has values [b1 = "A", C1 = "B", D1 = "C"] in the excel sheet. Say i want to read those values into an array $name[$i] where i = 0 to 2

Please help me with this syntax. Thank You in advance

[foster74]

Isn't _ExcelReadArray what you are after? There is an example in the helpfile.