AnsweredAssumed Answered

Import 1st field of 1st record of an .XLS file

Question asked by Mitch on Jan 20, 2012
Latest reply on Jan 20, 2012 by philmodjunk

Title

Import 1st field of 1st record of an .XLS file

Post

Hi,

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?

Mitch

 

 

 

 

 

Outcomes