过滤结果是列表提要只包含满足过滤条件的工作表行。
The result is a list feed containing only those worksheet rows that match the filter criteria.
正如您可以修改工作表行一样,您也可以修改工作表单元格。
Just as you can modify worksheet rows, you also can modify worksheet cells.
您可以通过添加列和行、包括其他来源的数据、创建用于计算的公式等,从而操作工作表。
You can manipulate the worksheet by adding columns and rows, including data from other sources, creating formulas for computations, and so on.
清单5将工作表的每一行表示为一个条目,而清单6将工作表的每个单元格表示为一个条目。
Listing 5 represents each row of the worksheet as an entry, while Listing 6 represents each cell of the worksheet as an entry.
工作项在载入之后,表格会得到创建,而该表的每一行都得到了一个工作项记录。
As work items are loaded, the tables are created, and each row of this table gets a work item record.
从工作表获取一行后,使用该行来向下钻取到单元格级别。
After obtaining the row from the sheet, use the row to drill down to the cell level.
列表和单元格提要被绑定到一个特定的工作表,其中包含组成工作表的行和单元格。
The list and cell feeds are tied to a specific worksheet and contain the rows and cells that make up that worksheet.
清单6创建了一个列表查询,该查询以列表提要的形式返回工作表中销售额超过某个限值的所有行。
Listing 6 creates a list query that returns all rows in the worksheet with sales units above a particular limit as a list feed.
要获取工作簿中的所有信息,只需遍历所有工作表,每个工作表的每一行,每一行中的每个单元格。
To gather all of the information from the workbook, iterate through all of the sheets, each row in each sheet, and each cell in each row.
目标工作表必须已经存在,并且必须已经定义了标题行的字段。
The target worksheet must already exist and must already have the fields of the header row defined.
是否将该请求作为PUT或DELETE发送取决于是否从工作表中修改或删除了行。
Whether the request is sent as a PUT or DELETE decides whether the row is modified or deleted from the worksheet.
清单6演示了更新工作表中的行的过程。
Listing 6 illustrates the process of updating rows in a worksheet.
清单7演示了从指定的工作表删除最后一行的过程。
Listing 7 illustrates, by deleting the last row of a specified worksheet.
您还可以从一个PHP应用程序中查看电子表格数据,并添加、编辑、删除单元格、行和工作表。
With the Google Spreadsheets data API, you can view spreadsheet data from a PHP application and change it, by adding, editing, and deleting cells, rows, and worksheets.
考虑清单12,其中演示了只检索指定工作表的标题行。
Consider Listing 12, which demonstrates by retrieving only the header row of a specified worksheet.
支持常见任务,如添加、修改和删除工作表、行和单元格,并可以通过Zend_Gdata完成。
Common tasks, such as adding, modifying, and deleting worksheets, rows, and cells, are all supported and can be performed using Zend_Gdata.
要处理工作表上的数据,首先要获取一个HSSFRow (or g . apache . poi .hssf . usermodel . HSSFRow)对象,它表示工作表中的一行。
To work with data on the sheet, start by getting an HSSFRow (org.apache.poi.hssf.usermodel.HSSFRow) object, which represents a row in the sheet.
该方法接受5个参数:行索引、列索引、单元格值、电子表格键和工作表键。
This method accepts five arguments: the row index, the column index, the cell value, the spreadsheet key, and the worksheet key.
在本文的最后一部分中,我将解释如何使用DataAPI远程操作电子表格内容,从一个远程PHP应用程序中添加、更新和删除行、单元格、工作表。
In this concluding part, I examine how you can use the Data API to remotely manipulate spreadsheet content, by adding, updating, and deleting rows, cells, and worksheets from a remote PHP application.
由于是在AUTOCOMMIT处于禁用状态的情况下工作,因此新行并未永久地保存到bigdog. products表中。
Because you're working with AUTOCOMMIT disabled, your new row isn't permanently saved in the bigdog.products table.
Next循环,扫描LotusSymphony电子表格的第一个工作表的前面500行,并且在第一列中查找可能的匹配。
Next loop to scan through the first 500 rows of the first worksheet in the Lotus Symphony spreadsheet, and it looks in the first column for possible matches.
这儿是本例中数据源数据行返回的截图,当执行“扩展到明细”操作时,这些数据行被放在新的工作表中。
Here is a screenshot of the source data rows returned in the example when performing the "expand to detail" operation. The rows are placed in a new worksheet.
例如,时间表应用程序应该显示足够的行和列,以便用户在输入他(她)的工作时间时不必看到数据周围大量的空白行、列。
For example, a timesheet application will show enough columns and rows so that the user can enter his or her work times without having to see numerous blank columns and rows surrounding the data.
例如,时间表应用程序应该显示足够的行和列,以便用户在输入他(她)的工作时间时不必看到数据周围大量的空白行、列。
For example, a timesheet application will show enough columns and rows so that the user can enter his or her work times without having to see numerous blank columns and rows surrounding the data.
应用推荐