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.
Baca Juga
- How Can I Create Batch In Javascript Loop To Select X Rows Then Next X Rows Until All Rows Are Done?
- How To Find The Last Cell With A Value At The End Of A Column That Is Shorter Than Other Columns In Google Sheets?
- How Can I Create Batch In Javascript Loop To Select X Rows Then Next X Rows Until All Rows Are Done?
Post a Comment for "Cant Seem To Read Cell Data From Another Google Spreadsheet In My Script"