My situation: At a competition, we will have 6 "scorers" each using a separate android tablet. For every game (there will probably be 70 or 80 throughout the tournament), each person will score accordingly on a custom app that will create a .csv file. (To be clear, each match will result in 6 separate, 1 row, csv files.) The format of the data will be the same from game to game, and from scorer to scorer. I can have control over the names of these files such as "[Scorer#]_[Match###].csv". These tablets will all be connected to a central computer via USB.
我的情况:在一个竞争中，我们将会有6个“scorers”使用一个单独的android平板电脑。每一场比赛(在整个比赛中可能会有70或80场)，每个人都会在一个定制的应用程序上相应得分，该应用程序将创建.csv文件。(需要说明的是，每次匹配都会产生6个独立的、1行的csv文件。)数据的格式将是相同的，从游戏到游戏，从得分手到得分手。我可以控制这些文件的名称，比如“[得分手#]_[匹配#].csv”。这些平板电脑都将通过USB连接到*电脑上。
What I would like to do: I would like to be able to have the data from all of those files automatically populate a "database" table on a single sheet. If possible, I would like a folder to act as a "watch folder" of sorts, where, as a new file shows up in a folder, that data is automatically ingested into the table. If that is not possible, I would be happy with a single function I could run to check for new data after each game ended.
我想要做的是:我希望能够将来自所有这些文件的数据自动填充到单个表上的“数据库”表中。如果可能的话，我想要一个文件夹作为某种“监视文件夹”，当一个新文件出现在一个文件夹中时，该数据将自动地进入表中。如果这是不可能的，我很乐意在每次游戏结束后运行一个函数来检查新的数据。
I had considered possibly trying to use power query, but wasn't sure if that could lead me to a usable solution.
我曾考虑过可能尝试使用power query，但不确定这是否能让我找到一个可用的解决方案。
Any suggestions would be greatly appreciated!
如有任何建议，我们将不胜感激!
(and I apologize if anything is unclear. I'm happy to clear up any confusion)
(如果有什么不清楚的话，我向你道歉。我很乐意澄清任何困惑)
1 个解决方案
#1
1
Power Query is a good fit in that scenario. You can set up a query that loads all files in a specific folder and appends the contents. Refresh the query when new files have been added to the folder.
在这种情况下，Power查询非常适合。您可以设置一个查询，该查询加载特定文件夹中的所有文件并附加内容。当新文件添加到文件夹时刷新查询。
For detailed instructions how to set up such a query, take a look here:
有关如何设置此类查询的详细说明，请参阅以下内容:
http://excelunplugged.com/2015/02/10/get-data-from-folder-in-power-query/
http://excelunplugged.com/2015/02/10/get-data-from-folder-in-power-query/
#1
1
Power Query is a good fit in that scenario. You can set up a query that loads all files in a specific folder and appends the contents. Refresh the query when new files have been added to the folder.
在这种情况下，Power查询非常适合。您可以设置一个查询，该查询加载特定文件夹中的所有文件并附加内容。当新文件添加到文件夹时刷新查询。
For detailed instructions how to set up such a query, take a look here:
有关如何设置此类查询的详细说明，请参阅以下内容:
http://excelunplugged.com/2015/02/10/get-data-from-folder-in-power-query/
http://excelunplugged.com/2015/02/10/get-data-from-folder-in-power-query/