要将XML写回excel电子表格,应该迭代xml,并设置单元格值和格式。
To write the XML to an Excel spreadsheet, iterate through the XML and set cell values and formatting.
在这种情形中,格式实际上是基于一个规则(MDX表达式)的,基于每个单元格的数值设置不同的填充颜色。
In this case, the formatting is actually based on a rule (MDX expression), setting different fill colors based on the value in each cell.
另外,也能识别单元格的条件格式,包括正常格式,斜体填充和条件格式图标设置。
In addition, it also recognizes conditional formats on cells including regular formatting, gradient fills, and conditional formatting icon sets (which I discussed in previous posts here and here).
应用推荐