Cant Seem To Read Cell Data From Another Google Spreadsheet In My Script

This is my script. It returns the url for each sheet in the folder 'My folder', but returns no cell value that I am asking for. Can anyone see what is wrong? I have checked the s

Solution 1:

It seems that you should check if a file is of a given type by doing this

if (file.getFileType()==DocsList.FileType.SPREADSHEET)

Also, you are reusing the variable sheet. Consider renaming the second usage of it to otherSheet.