Google Docs电子表格：获取单独的行

发布于 2024-11-01 03:59:36 字数 629 浏览 0 评论 0原文

我正在使用 Java API 更新 Google 电子表格CSV 文件。我创建了一种删除行的方法：

public void deleteRow(int row) throws IOException, ServiceException {
    URL listFeedUrl = _worksheet.getListFeedUrl();
    ListFeed feed = _service.getFeed(listFeedUrl, ListFeed.class);
    List<ListEntry> entries = feed.getEntries();
    ListEntry entry = entries.get(row);
    entry.delete();
}

但是，问题是我必须获取所有条目才能获取我想要的一个条目。有没有一种方法可以获取一个甚至较小的条目子集，这样我就不必等待整个条目集返回而只删除一个条目？（在当前状态下，此方法需要很长时间才能在大型电子表格上运行）

原文

I'm using the Java APIs to update a Google Spreadsheet from a CSV file. I've created a method for deleting a row:

public void deleteRow(int row) throws IOException, ServiceException {
    URL listFeedUrl = _worksheet.getListFeedUrl();
    ListFeed feed = _service.getFeed(listFeedUrl, ListFeed.class);
    List<ListEntry> entries = feed.getEntries();
    ListEntry entry = entries.get(row);
    entry.delete();
}

however, the problem is that I have to get all the entries to get the one entry I want. Is there a way that I can get one or even a smaller subset of the entries so I don't have to wait for the entire entry set to return to only delete one entry? (In its current state, this method takes a long time to run on large spreadsheets)

分享到QQ

分享到微博