英文:
How can I automate data entry by column within Google Sheets?
问题
我一直在做一些小小的研究，但找不到一个明确的解决方案。每周我都要从一个.xlsx文件中复制/粘贴两个报告数据选项卡到Google表格中，.xlsx文件中的列顺序不总是与Google表格中的顺序匹配。例如，.xlsx文件中存在列A、B和C，而Sheet中也存在，但有一周的顺序可能是C、A、B，另一周可能是A、C、B。
是否有一种方法可以将.xlsx文件导入Google表格，以便它会根据匹配的标题自动附加列数据？
谢谢，
我还没有尝试过很多方法，但已经探索了外部服务，如Zapier。我对任何建议都持开放态度。
英文:
I've been researching this a small bit and can't find a concrete solution. Every week I have 2 tabs of reporting data I copy/paste from a .xlsx into a Google Sheet, the columns in the .xlsx do not always match the order as the Google Sheet. Example: Column A, B, and C exist in the .xlsx and Sheet, but one week the order might be C, A, B, another week it could be A, C, B.
Is there a way to import a .xlsx into a Google Sheet where it will automatically append the column data based on a matching header?
Thanks,
I havent tried a whole lot, but have explored external services such as Zapier. I am open to any and all suggestions.
答案1
得分: 0
如果您查看Google Sheets API，您应该能够找出如何连接到API并访问您在Google帐户中拥有的表格，并根据您的要求操作其中的数据。
您可以在这里找到API文档：
https://developers.google.com/sheets/api/guides/concepts
还有一个关于如何操作具有大量有用信息的表格的讨论：
https://stackoverflow.com/questions/725627/accessing-google-spreadsheets-with-c-sharp-using-google-data-api
英文:
If you take a look at the google sheets API you should be able to figure out how to connect to the API and access the sheets that you have in your google account and manipulate the data in one based on your requirements.
You can find the API Documentation here:
https://developers.google.com/sheets/api/guides/concepts
There is also a discussion about manipulating sheets with a lot of useful information here:
https://stackoverflow.com/questions/725627/accessing-google-spreadsheets-with-c-sharp-using-google-data-api
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论