自动将Excel文件转换为Google表格 [英] Automatically converting Excel Files to Google Sheets

问题描述

我有一个使用保存电子邮件和附件加载项的Google帐户.

I have a google account that uses the save emails and attachments add-on.

>://chrome.google.com/webstore/detail/save-emails-and-attachmen/nflmnfjphdbeagnilbihcodcophecebc?hl = zh-CN

电子邮件帐户仅接收excel表格作为附件，并且这些表格会自动保存到特定的文件夹中.

The email account only receives excel sheets as attachments, and those are saved to a specific folder automatically.

是否可以在保存时(或保存后)将这些工作表自动转换为Google工作表.目前，我必须使用Google表格打开文件以进行转换.

Is it possible to have those sheets converted automatically to google sheets upon save (or after save). Currently, I have to open the file with google sheets to convert it.

我尝试将文件夹设置为将上载的文件转换为Google Docs编辑器格式，但这不起作用.

I have tried setting the folder to Convert uploaded files to Google Docs editor format, but that doesn't work for this.

任何建议将不胜感激.

埃里克

推荐答案

如果您希望使用Drive API进行此操作，则可以使用

if you're wishing to do this with the Drive API, then you can do so using the examples given in Upload Files, see the section headed Importing to Google Docs types. Essentially, by setting the source file MIME type to application/vnd.openxmlformats-officedocument.spreadsheetml.sheet and that of the new file to application/vnd.google-apps.spreadsheet, this indicates that the conversion is required on upload.

这篇关于自动将Excel文件转换为Google表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！