一些更多的vb.net和excel悲伤 [英] Some more vb.net and excel grief

问题描述

你好，
因此，从我的vb.net代码中，我将此发送到excel

hi there,
so from my vb.net code i send this through to excel

FormulaR1C1 = "=SUM(" & pubfuncCheckNull(privFuncRetrieveExcelColumnName(i, 2) & ":" & privFuncRetrieveExcelColumnName(i, dtaTable.Rows.Count + 1)) & ")"

这基本上只是在vb中说SUM(B3:B4)，但是当它变得更好时，它会读取SUM(''B3'':''B4'')而不计算总和.我知道它的远景，但是有人可以告诉我我做错了吗?是因为我在sum方法中使用了字符串连接?
在此先感谢

which basically just says SUM(B3:B4) in vb but when it gets to excel, it reads SUM(''B3'':''B4'') and doesn''t work out the sum. I know its a long shot but can someone tell me what i''m doing wrong? is it cause i use a string concatenation in the sum method?
Thanks in advance

推荐答案

我会看看privFuncRetrieveExcelColumnName的定义-它似乎封装了单元ID.
我认为它是您的其中一个-谷歌找不到它.

I would look at the definition of privFuncRetrieveExcelColumnName - it looks to be encapsulating the Cell IDs.
I assume it is one of yours - google couldn''t find it.

这篇关于一些更多的vb.net和excel悲伤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！