Retrieving worksheet data as arrays.
以数组形式检索工作表数据。
Note that my template matches Excel: worksheet.
注意,我的模板是Excel:worksheet。
Listing 6 shows the cell feed for this worksheet.
清单6显示了该工作表的单元格提要。
Within the worksheet feed, each contains a set of elements.
在工作表提要中,每个元素包含一个元素列表。
Listing 5 shows the corresponding list feed for this worksheet.
清单5显示了与该工作表对应的列表提要。
Listing 6 illustrates the process of updating rows in a worksheet.
清单6演示了更新工作表中的行的过程。
Extract the contents of the Scenario worksheet of the XML document.
提取XML文档的Scenario工作表的内容。
Extract the contents of the Comm worksheet of the XML document.
提取XML文档的Comm工作表的内容。
Listing 4 has an example of deleting the worksheet from Listing 3.
清单4演示了删除清单3中的工作表。
The final PivotCache creation happens after the worksheet is finished.
最后的PivotCache创建发生在工作表完成之后。
The list feed, which returns a feed containing the rows of a worksheet.
列表提要,返回包含工作表所在行的提要。
Listing 7 illustrates, by deleting the last row of a specified worksheet.
清单7演示了从指定的工作表删除最后一行的过程。
Just as you can modify worksheet rows, you also can modify worksheet cells.
正如您可以修改工作表行一样,您也可以修改工作表单元格。
The cell feed, which returns a feed containing the individual cells of a worksheet.
单元格提要,返回包含组成工作表的单元格的提要。
If you do this to each worksheet item your test case script looks similar to Listing 6.
如果您对每个工作表条目这样做,您的测试脚本看起来类似于列表6。
The result is a list feed containing only those worksheet rows that match the filter criteria.
过滤结果是列表提要只包含满足过滤条件的工作表行。
To delete a worksheet, simply invoke the delete method of the corresponding worksheet entry.
要删除一个工作表,只需要调用相应的工作表条目的delete方法。
You must specify the ID of the spreadsheet and the ID of the worksheet within the spreadsheet.
必须指定此电子数据表的ID和电子数据表中的工作表的ID。
The target worksheet must already exist and must already have the fields of the header row defined.
目标工作表必须已经存在,并且必须已经定义了标题行的字段。
Listing 1 shows the results of the business requirement analysis in the form of a design worksheet.
清单1以设计工作表的形式给出了业务需求分析的结果。
Consider Listing 12, which demonstrates by retrieving only the header row of a specified worksheet.
考虑清单12,其中演示了只检索指定工作表的标题行。
The nature of the request—PUT or DELETE—determines whether the worksheet entry is updated or deleted.
请求 —PUT或DELETE—的性质决定是否更新或删除工作表条目。
This article provided an example of how to analyze the business case and produce a design worksheet.
本文提供了说明如何分析业务用例和生成设计工作表的示例。
The properties are documented in the perldoc page for Spreadsheet::ParseExcel, in the worksheet section.
ParseExcel perldoc页的工作表一节中记载了这些特性。
To see this in action, consider Listing 3, which updates the title of the worksheet created in Listing 1.
要查看实际效果,考虑清单3,它更新了清单1中创建的工作表的标题。
To illustrate, consider Figure 3, which shows an example worksheet for the Sales by Region spreadsheet.
为了方便演示,考虑图3,其中演示了 “地区销售情况” 电子表格的示例工作表。
Extracts the contents of the Scenario worksheet portion of the spreadsheet from the corresponding XML document.
从对应的XML文档提取电子表格的Scenario工作表部分的内容。
Listing 1 first obtains a reference to the named spreadsheet entry and then obtains that entry's worksheet feed.
清单1首先获得对指定电子表格条目的引用,然后获得该条目的工作表提要。
Extracts the contents of the Comm worksheet portion of the spreadsheet from the corresponding XML document.
从对应的XML文档提取电子表格的Comm工作表部分的内容。
They provide a simple task worksheet at the end of the chapter that make it simple to keep a project on course.
他们在章节的末尾提供了简单的任务工作表,可使工程保持正轨变得非常容易。
应用推荐