创建未隐藏工作表的PDF Google Script

function createPDF() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheets = spreadsheet.getSheets();
  
  for (var i = 0; i < sheets.length; i++) {
    var sheet = sheets[i];
    
    if (!sheet.isSheetHidden()) {
      var url = spreadsheet.getUrl();
      url = url.replace(/edit$/, '');
      var sheetId = sheet.getSheetId();
      var pdfUrl = url + 'export?exportFormat=pdf&format=pdf&gid=' + sheetId;
      
      var response = UrlFetchApp.fetch(pdfUrl, {
        headers: {
          'Authorization': 'Bearer ' + ScriptApp.getOAuthToken()
        }
      });
      
      var pdfBlob = response.getBlob();
      var folder = DriveApp.getFolderById('YOUR_FOLDER_ID'); // 替换为目标文件夹的ID
      folder.createFile(pdfBlob).setName(sheet.getName() + '.pdf');
    }
  }
}