您有一种简洁的方法来确定表中每个单元格的内容和样式。
You have an elegant way to determine both the content and the style of each cell in the table.
为了理解它是如何运作的的,您可以将 MC 看作一个电子表格,它的单元格是度量标准。
To understand how that works, you can think of an MC as a spreadsheet, whose cells are the metrics.
您可以将任何单元格转换为值模板。
但是每个单元格存有什么数据呢?
存储单元格数据之后,关闭内部循环。
这会更新单元格的背景颜色。
我们实现了内容单元格排序。
所以,这个单元格的值为3。
接下来,需要填充余下的单元格。
有些单元格包含数值。
清单6.循环所有单元格并打印值。
列表和单元格提要被绑定到一个特定的工作表,其中包含组成工作表的行和单元格。
The list and cell feeds are tied to a specific worksheet and contain the rows and cells that make up that worksheet.
您将为行创建单元格。
还可以过滤列表提要或单元格提要的内容,从而使提要只返回匹配特定条件的行或单元格。
You also can filter the contents of a list feed or a cell feed, such that the feed returns only rows or cells matching specific criteria.
单元格提要,返回包含组成工作表的单元格的提要。
The cell feed, which returns a feed containing the individual cells of a worksheet.
清单8处理一个单元格提要,因此从单元格提要提取数据的方法与清单7中的方法稍有不同。
Listing 8 operates on a cell feed, and so the method of extracting data from it differs slightly from that in Listing 7.
您可以使用该索引来将格式应用于单元格样式以及将单元格样式应用于单元格,如清单18所示。
You can use that index to apply the formatting to the cell style and apply the cell style to the cell, as in Listing 18.
利用这种格式,行和单元格都很清楚。
这些嵌套表有两个单元格:第一个单元格为蓝色,第二个单元格为白色。
These nested tables have two cells: the first is colored blue, and the second is white.
向行添加的第一个单元格是一个水平标题栏单元格;向行添加的其他单元格是内容单元格。
The first cell added to a row is a horizontal header's cell; other cells added to a row are content cells.
在这个示例中,新的数值可能来自不止一个单元格,所以可以任选一个:例如左上侧单元格。
In this case, where the new number could have come from more than one cell, pick an arbitrary one: the one to the above-left, say.
在本文的后面,我们将使用两个术语:标题栏单元格和内容单元格。
Further in the article we will use two terms: a header cell and a content cell.
以前的单元格是左侧的单元格。
该方法将返回嵌套的单元格数据数组,其中每个单元格使用它的行坐标和列坐标进行索引。
This method returns a nested array of cell data, with each cell indexed by its row and column coordinates.
将单元格样式应用到具体的单元格。
用户指定输入单元格、输出单元格及其它参数。
The user specifies input cells, output cells and other parameters.
特别是,注意单元格条目对象的标题将返回被更新的单元格的字母数字坐标。
In particular, notice that the title of the cell entry object returns the alphanumeric coordinates of the cell that was updated.
该函数根据单元格中的文本将列单元格排序(排序不包含标记)。
The function sorts the column cells based on the text in the cells (mark up is excluded from the sorting).
回想一下,任何单元格中的数字都是该单元格所在行之上和列之前的字符串的LCS长度。
Recall that the number in any cell is the length of an LCS of the string prefixes above and below that end in the column and row of that cell.
当然,您在表中创建单元格时也需要往单元格中放入适当的内容。
When you create a cell in the table, of course, you also need to put the appropriate content in that cell.
应用推荐