I am trying to list the filenames of a directory containing aprox 2000 spreadsheets. This part is not so difficult, but as I go through I want to pull out a title from each spreadsheet, held in cell B1 and place this in a file along with the filenames.

At the moment I have the following code as a java script but would like to know how to extract data from inside each of the files whilst iterating as well.


Andy