Yoav Zoldan yzoldan
azadisaryev
/ convertExcel2Sheets
Last active
March 9, 2024 18:23
Google Apps Script for converting Excel (.xls or .xlsx) file to Google Spreadsheet. Drive API must be enabled in your script's Advanced Google Services and in Developers Console for the script to work (see https://developers.google.com/apps-script/guides/services/advanced#enabling_advanced_services for details).
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * Convert Excel file to Sheets | |
| * @param {Blob} excelFile The Excel file blob data; Required | |
| * @param {String} filename File name on uploading drive; Required | |
| * @param {Array} arrParents Array of folder ids to put converted file in; Optional, will default to Drive root folder | |
| * @return {Spreadsheet} Converted Google Spreadsheet instance | |
| **/ | |
| function convertExcel2Sheets(excelFile, filename, arrParents) { | |
| var parents = arrParents || []; // check if optional arrParents argument was provided, default to empty array if not |