从url谷歌表获取文件名 [英] Get filename from url google sheet

问题描述

我有问题. 如何从网址获取文件名?

I have a problem. How to get the filename from the url?

在此处输入图片描述

推荐答案

我通常不会这样做，因为您没有向我们展示您尝试过的内容，但是我感到很慷慨.

I wouldn't normally do this since you haven't shown us what you've tried, but I'm feeling generous.

此功能将为您工作. (请注意，您需要授予权限才能运行它.)

This function should work for you. (Note that you'll need to grant permissions for it to run.)

function getFileNames() {
  var sheet = SpreadsheetApp.getActive().getSheetByName("Get_File_Name");
  var links = sheet.getRange("A2:A").getValues();
  var filenames = []; 
  for (var i = 0; i < links.length; i++) {
    var url = links[i][0];
    if (url != "") {
      var filename = SpreadsheetApp.openByUrl(links[i][0]).getName();
      filenames.push([filename]);
    }
  }
  var startRow = 2; // print in row 2 since row 1 is the header row
  var fileNameColumn = 2; // Column B = column 2
  var destination = sheet.getRange(startRow, fileNameColumn, filenames.length, filenames[0].length);
  destination.setValues(filenames);
}

这篇关于从url谷歌表获取文件名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！