![]() Return (spreadsheet.id) //Returns the ID of the converted fileĬonverting the Excel file to a temporary Google Sheets file. ![]() You may use the following script as a basis for yours: function importData() ], ![]() As a workaround, you need to first convert your excel file to Google Sheets and then extract the data from the converted file to your output Google Sheets file. Unfortunately, there is no direct way to extract data from Excel files to Google Sheets using Google Apps Script. Suggestion: Temporarily Convert the Excel File to Google Sheets File to Extract Data ![]()
0 Comments
Leave a Reply. |