我怎样才能格式化公式化结果在C#中的Excel互操作? [英] How can I format a formulaic result in C# Excel Interop?
问题描述
我有了这个代码,总结的值在给定范围内(O列第10行到第O列最后signficant行):
I've got this code that sums the values in the given range (Column O Row 10 to Column O the last signficant row):
注意这是字母O不是数字零
Note: That's the letter "O" not the number "Zero".
var totalTotalPackageCountCell =
(Range)_xlSheetDelPerf.Cells[curDelPerfRow + 2, TOTAL_PACKAGE_COUNT_COLUMN];
totalTotalPackageCountCell.Formula = string.Format("=SUM(O10:O{0})", curDelPerfRow);
它的工作原理除了一件事漂亮花花公子:显示器不带逗号的值,如20192(我想它是20192)
It works pretty dandy except for one thing: the value displays without commas, such as "20192" (I want it to be "20,192").
我试过这样:
totalTotalPackageCountCell.Formula =
string.Format("=SUM(O10:O{0})", curDelPerfRow)
.ToString("N0", CultureInfo.CurrentCulture);
...为的ToString(NO,CultureInfo.CurrentCulture)
怎么我成功添加逗号其他值
...as .ToString("N0", CultureInfo.CurrentCulture)
is how I successfully add commas to other values.
在此(公式值)的情况下,虽然,它甚至不编译 - 我得到:
In this (formula value) case, though, it doesn't even compile - I get:
没有过载方法'的ToString'需要两个参数
No overload for method 'ToString' takes 2 arguments
我怎么能有我的公式和格式它也?
How can I have my formula and format it, too?
推荐答案
您可以尝试这一个。 。尽量指定单元格的NumberFormat的,分配一个值之前
You could try this one. Try to specify the NumberFormat of the cell, before assigning a value.
totalTotalPackageCountCell.NumberFormat = "#,##0";
totalTotalPackageCountCell.Formula = string.Format("=SUM(O10:O{0})", curDelPerfRow);
这篇关于我怎样才能格式化公式化结果在C#中的Excel互操作?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!