如何通过spreadhseet api v3查询Google spreadhseet？ [英] How to query a Google spreadhseet via spreadhseet api v3?

问题描述

我有一个非常大的电子表格，包含音乐元数据。我已经编写了一个程序，根据相册的UPC代码，通过Google的电子表格api提取个人相册。它通过一个循环来完成，一次拉动一个单元并进行比较。速度非常慢，12首曲目需要6秒。为了让这个程序更快，我在Google的文章中找到了一个叫做结构化查询的参数，但是我无法使它工作。这是我尝试过的查询。

I have a very large spreadsheet filed with music metadata. I have wrote a program to pull an individual album, via the spreadsheet api from Google, based on the albums UPC code. It does this though a loop, pulling one cell at a time and comparing. It is very slow, it takes 6 seconds for a 12 track album. In attempt to make this program faster, I found an argument called "structured query" in a Google article, but I cannot get it to work. Here are the queries I have tried.

结构化查询： https： //developers.google.com/google-apps/spreadsheets/#sending_a_structured_query_for_rows

在哪里我实际命名了列：

Where I actually name the column:

    GET https://spreadsheets.google.com/feeds/list/key/worksheetId/private/full?sq=upc%3D890151002233

在哪里使用指定的列名称（c）：

Where I use the assigned column name (c):

    GET https://spreadsheets.google.com/feeds/list/key/worksheetId/private/full?sq=c%3D890151002233

即使存在UPC代码，我也会返回0结果（我直接从电子表格的第一行复制它）。

Both return 0 results even though the UPC code exists (I copied it straight from the first line of the spreadsheet). Am I doing something wrong or is the operation I am trying to complete not possible?

任何帮助将不胜感激：）

Any help would be appreciated:)

推荐答案

在行上执行完整的数据库式查询。

Performs a full database-like query on the rows.

如何使用查询在这里：
https://gdata-java-client.googlecode.com/svn-history/r51/trunk/java/sample/spreadsheet/list/ListDemo.java

这篇关于如何通过spreadhseet api v3查询Google spreadhseet？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！