Yes, it's possible.
I have a queston though, are your StudentIDs the same in each excel file? (1,2,3n4 and so?) or each student will have his unique name?
1) Let's assume your Excel files are all under the same folder/path and that all the titles are in the same format:
ABC School Period 1 Year 2016 (1 is school name, 6th word in the year)
here's is how we do to bring up the title and the year:
let vDir='D:\ExcelFiles\'; //your directory
for each vF in filelist (vDir & '\*.xls' )
let SchoolName= SubField('$(vF)', ' ',1) ;
let vSchoolName= '$(SchoolName)' ;
let Year=SubField('$(vF)', ' ',6);
let vYear='$(Year)' ;
It begins as follow..
Can you please, provide me 2 excel samples from 2 schools, to work with and continue with my script?
Thanks a lot
The StudentID is unique (it's their Social Security Number).
I attached an example with 4 sheets representing the excel data i receive .
Each school sends a separate sheet for each period (1, 2), and each class grade (A, B, C) = a total of 6 spreadsheets per school per year.
Students can change teachers between semesters (See studentID 3)
school scores example.xlsx 13.2 K