Google Apps Script – MimeType.MICROSOFT_WORD Lists Only .docx

google-apps-scriptgoogle-drive

I am using a Google Apps Script to list Word files in a folder, however this will work only for .docx files, not .doc.
Any idea?

 var folderID = "ID#"
  var sourceFolder = DriveApp.getFolderById(folderID);
  var files = sourceFolder.getFilesByType(MimeType.MICROSOFT_WORD);
  // will list only .docx

Best Answer

How about this answer?

Pattern 1:

If you want to retrieve files with the extension of .doc, please modify as follows.

From:

MimeType.MICROSOFT_WORD

To:

MimeType.MICROSOFT_WORD_LEGACY

Pattern 2:

If you want to retrieve files with the extensions of .doc and .docx, please modify as follows.

From:

var files = sourceFolder.getFilesByType(MimeType.MICROSOFT_WORD);

To:

var files = sourceFolder.searchFiles("mimeType='" + MimeType.MICROSOFT_WORD_LEGACY + "' or mimeType='" + MimeType.MICROSOFT_WORD + "'");

References:

If I misunderstood your question and this was not the result you want, I apologize.

Related Solutions

Google-apps-script – Create help pop-up in Google Document using Google Apps Script

You could deploy your script as a web app, which implies implementing a doGet() method. In this method, you define your HTML content.

You can then access your script by the URL that is displayed in the Deploy as web app dialog. This URL could then be used in a link in your document.

However, the web app content is not displayed in a pop-up, so this might not solve your problem completely. You might want to create a sidebar. See the documentation for this.

Google-apps-script – How to extract a link URL from one word within a paragraph element in Google Docs with Google Apps Script

I was missing the .asText() method. The code below will pull the URL from the text character in position 18 of the paragraph string.

//Get HYPERLIINK from single character in a paragraph 
  var paragraphHYPERLINK = paragraph.asText().getLinkUrl(18); //paragraph text
  Logger.log(paragraphHYPERLINK)

Best Answer

Pattern 1:

From:

To:

Pattern 2:

From:

To:

References:

Related Solutions

Google-apps-script – Create help pop-up in Google Document using Google Apps Script

Google-apps-script – How to extract a link URL from one word within a paragraph element in Google Docs with Google Apps Script

Related Topic