在预算中电子工作表完美的相称于逐条的计算。
Spreadsheets are ideally suited to detailed computations as in budgeting.
清单5设置了目标电子表格和工作表,然后创建了一个行数据数组,包含列-值映射。
Listing 5 sets the target spreadsheet and worksheet and then creates an array of row data containing column-value mappings.
根据相应的电子表格的安全设置,也可以在未进行身份验证的情况下访问电子表格提要,如工作表、列表、单元格提要。
Spreadsheet feeds, such as worksheet, list, and cell feeds, might even be accessed without authentication, depending on the security settings of the corresponding spreadsheet.
为了方便演示,考虑图3,其中演示了 “地区销售情况”电子表格的示例工作表。
To illustrate, consider Figure 3, which shows an example worksheet for the Sales by Region spreadsheet.
现在,您可以开始考虑在一个电子表格中包含多个页面或工作表,添加公式,甚至包含曲线图,这样,您就可以真正提高您的输出水平了。
Now, you can start thinking about including multiple pages or sheets in the same spreadsheet, adding formulas, and even including graphs so that you can really crank up the level of your output!
该元素指定电子表格的工作表提要的URL,并提供一种方法来向下钻取更深一层的细节。
This element specifies the URL to the worksheet feed for the spreadsheet and provides a way to drill down to the next level of detail.
工作表提要被绑定到一个特定的电子表格,该电子表格包含一个工作表列表。
The worksheets feed is tied to a specific spreadsheet and contains a list of worksheets in that spreadsheet.
清单1首先获得对指定电子表格条目的引用,然后获得该条目的工作表提要。
Listing 1 first obtains a reference to the named spreadsheet entry and then obtains that entry's worksheet feed.
必须指定此电子数据表的ID和电子数据表中的工作表的ID。
You must specify the ID of the spreadsheet and the ID of the worksheet within the spreadsheet.
查看清单4,它对清单3进行了修改,列出了电子表格中的工作表。
Take a look at Listing 4, which revises Listing 3 and lists the worksheets within a spreadsheet.
您还可以从一个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.
请求该URL将生成一个电子表格提要,其中包含指定的电子表格中的工作表的信息。
Requesting this URL generates a worksheet feed that contains information on the worksheets within the selected spreadsheet.
在执行本脚本并返回到GoogleSpreadsheetsGUI后,将看到空的电子表格中出现了一个新的工作表,如图2所示。
When you execute this script and flip back to the Google Spreadsheets GUI, you see a new worksheet inside your empty spreadsheet, as in Figure 2.
该方法接受5个参数:行索引、列索引、单元格值、电子表格键和工作表键。
This method accepts five arguments: the row index, the column index, the cell value, the spreadsheet key, and the worksheet key.
现在,您已经了解了如何获得电子表格和工作表,现在考虑如何检索工作表的实际内容。
Now that you know how to get spreadsheets and worksheets, consider how you can retrieve the actual contents of a worksheet. The Google spreadsheets Data API offers two ways to do this.
这个请求由GoogleAPI服务器解释和执行,最终结果是从电子表格中删除工作表。
This request is interpreted and executed by the Google API servers, resulting in the removal of the worksheet from the spreadsheet.
要向电子表格添加一个新的工作表,需要以atom格式生成一个新的工作表条目,然后将该条目POST到指定电子表格的工作表url中。
To add a new worksheet to this spreadsheet, you need to generate a new worksheet entry in Atom format and then POST this entry to the worksheet URL of the specified spreadsheet.
注意,对于某些提要,需要电子表格id (ssid)或工作表id (wsid)才能创建提要URL。
Note that for some of these feeds, you need the spreadsheet id (ssid) or worksheet id (wsid) to formulate the feed URL.
在本文的最后一部分中,我将解释如何使用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.
从对应的XML文档提取电子表格的Scenario工作表部分的内容。
Extracts the contents of the Scenario worksheet portion of the spreadsheet from the corresponding XML document.
从对应的XML文档提取电子表格的Comm工作表部分的内容。
Extracts the contents of the Comm worksheet portion of the spreadsheet from the corresponding XML document.
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.
基本上,这个XML内容至少应包含一个office:spreadsheet元素,该元素本身又包含一个table: table元素,用于表示电子表格中的每个单独的工作表。
Basically, the XML contents document contains an office: spreadsheet element, which itself includes a table: table element representing each individual sheet in the spreadsheet.
介绍了全电子式智能卡预付费电度表的工作原理、结构及技术特性,通过实例分析了使用它所带来的经济效益。
This text introduce the working principle, structure and technicality features of one-phase full -electronic pre-payment brain card meter, analysised its economic benefits through use it.
阐述了电子温度表组成部分的基本构成和工作原理。
The fundamental constitute and working elements of electronic thermometer was elaborated.
介绍了全电子式预付费磁卡电度表的工作原理、功能特点、售电系统及其综合效益。
This paper introduces the working principle, functional features, electricity vending system and comprehensive benefit analysis of full-electronic pre-payment mag card meter.
显示了当前工作表中的序号和该电子表格中工作表的总数。
Shows the sequence number of the current sheet the total number of sheets in the spreadsheet.
电子数据表包可以是用户使用多且相互关联的表格来工作。
Spreadsheet packages permit the user to work with multiple sheets that refer to each other.
电子数据表包可以是用户使用多且相互关联的表格来工作。
Spreadsheet packages permit the user to work with multiple sheets that refer to each other.
应用推荐