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.

You can also specify a range for the first record and a different range for the rest of the spreadsheet, then do your two imports by specifying different ranges for each.

However, given that this is just one field of just one record, you might also just import it all in one go and then go to the first record of the found set produced by the import and copy that first field's data to the place it needs to go before deleting this single first record.