google-apps-script - 是否可以选择将数据从Excel接收到Google表格？(Is there an option to receive data from Excel to Google Sheets?)

Question

我需要来自EXCEL的特定列或行的一些数据（文本/数字）才能接收到Google表格中。

  ask by Abu Saeed translate from so

Answer 1

you need to upload your excel file to Drive convert it to Sheets and use IMPORTRANGE to extract given range into your spreadsheet.

(您需要将excel文件上传到云端硬盘，将其转换为表格，然后使用IMPORTRANGE将给定范围提取到电子表格中。)

uploading can be automated via https://www.google.com/drive/download/backup-and-sync/

(可以通过https://www.google.com/drive/download/backup-and-sync/自动上载)

conversion can be automated via https://stackoverflow.com/a/55645062/5632629

(可以通过https://stackoverflow.com/a/55645062/5632629自动进行转换)

and IMPORTRANGE formula syntax is:

(和IMPORTRANGE公式语法为：)

=IMPORTRANGE("spreadsheet_ID_here"; "sheet_name_here!A1:D20")