Jump to content
Sign in to follow this  
Sarav

Transferring an excel row value to an array

Recommended Posts

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

Share this post


Link to post
Share on other sites
foster74

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×