Import 1st field of 1st record of an .XLS file
I am sure this is possible, but am not sure where to start. I have an .XLS spreadsheet and I wish to import the first field value (Field_1) from the first record (Record_1) in the .XLS spreadsheet into a field on my main layout, then import all the remaining fields values (Field_2, Field_3, Field_4...etc) from all the records (Records_1, Record 2, Record_3, Record_4...etc) from the spreadheet into a portal layout attached to my main layout.
The .XLS's first row is the tiitle of each colomn.
Any ideas for the script?