VB6到VB.NET转c#.net转换 [英] VB6 to VB.NET to c#.net conversion
问题描述
以下是vb声明:
ApExcel.Worksheets(1).Cells(1,19)== COUNT(c [-18]);
如何将上面的转换为c#语句?什么= COUNT(c [-18])这意味着
我尝试过:
我是vb的新手请帮帮我
我的excel表包含18列。我必须相应地添加记录。
Quote:
ApExcel.Worksheets( 1 )。单元格( 1 , 19 )= = COUNT(c [-18]);
首先这段代码有一个问题。 Excel单元格是一个对象,你不能在其中存储一个字符串并期望任何东西正确。
要在单元格中存储公式,你需要说出来。
ApExcel.Worksheets( 1 )。单元格( 1 ,< span class =code-digit> 19 ) .FormulaR1C1 = = COUNT(c [-18]);
引用:what= COUNT(c [-18])这意味着
这是使用R1C1相对表示法的Excel公式。
Excel VBA FormulaR1C1属性 - 简易Excel宏 [ ^ ]
Excel&#8211; R1C1参考样式与A1 | Excelmate [ ^ ]
Following is vb statement:
ApExcel.Worksheets(1).Cells(1, 19) = "=COUNT(c[-18])";
how to convert above to c# statement? what "=COUNT(c[-18])" this mean
What I have tried:
I am new to vb please help me
My excel sheet contain total 18 columns.and i have to add records accordingly.
Quote:ApExcel.Worksheets(1).Cells(1, 19) = "=COUNT(c[-18])";First of all this code have a problem. An Excel cell is an object, you can't store a string in it and expect anything go right.
To store a formula in the cell, you need to say it.
ApExcel.Worksheets(1).Cells(1, 19).FormulaR1C1 = "=COUNT(c[-18])";
Quote:what "=COUNT(c[-18])" this mean
This is an Excel formula using the R1C1 relative notation.
Excel VBA FormulaR1C1 Property - Easy Excel Macros[^]
Excel – R1C1 Reference Style vs. A1 | Excelmate[^]
这篇关于VB6到VB.NET转c#.net转换的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!