显示范围 [英] display range
问题描述
我可以使用vb.net和excel从工作表中获取单个值。
q)我如何获得一系列值,例如A2到A5并打印出来,例如一个msgbox。我知道我可以使用cells命令但是我想要一个范围命令,其中指定excel单元格范围。
''MyString = XL.Cells(4,1).Value
MyString = XL.Range(A2,A5)。值''错误
MsgBox(MyString)
i can get a single value from a worksheet using vb.net and excel.
q)How do i get a range of values eg A2 to A5 and print them out eg with a msgbox. I know i can use the cells command but i want a range command where specify excel cell range.
''MyString = XL.Cells(4, 1).Value
MyString = XL.Range("A2", "A5").Value ''error
MsgBox(MyString)
推荐答案
我猜,返回范围应该分配给一个数组:
试试这个:
Dim MyArr()As String
MyArr = XL.Range(" A2:A5")。值
和Loop通过MyArr获取所有价值观..
问候
Veena
Hi,
I Guess, Return Range should be assigned to an Array:
Try This :
Dim MyArr() As String
MyArr = XL.Range("A2:A5").Value
And Loop through MyArr, to get all the Values..
Regards
Veena
我猜,返回范围应该分配给一个数组:
试试这个:
Dim MyArr()As String
MyArr = XL.Range(" A2:A5")。值
和循环通过MyArr,获取所有值..
问候
Veena
Hi,
I Guess, Return Range should be assigned to an Array:
Try This :
Dim MyArr() As String
MyArr = XL.Range("A2:A5").Value
And Loop through MyArr, to get all the Values..
Regards
Veena
它不会一直用于Strings数组,尝试使用变体。将Range指定为Variant的好处是,变体不会变为Variant / Range,而是变为Variant的数组。
所以
dim MyArr
MyArr =范围(A2:A5)
将使MyArr成为一个二维数组(1到4,1到1)变体,其索引从1开始。
HTH
It wont work all the times for Strings array, try using a variant. The nice thing about asigning a Range to a Variant, is that the variant wont change into a Variant/Range, but into a Variant''s array.
so
dim MyArr
MyArr = Range("A2:A5")
will make MyArr a 2 dimensioned array (1 to 4, 1 to 1) of variants, which index start in 1.
HTH
dim MyArr
MyArr =范围(A2:A5)
将使MyArr是一个2维数组(1到4,1到1)的变体,其索引从1开始。
dim MyArr
MyArr = Range("A2:A5")
will make MyArr a 2 dimensioned array (1 to 4, 1 to 1) of variants, which index start in 1.
这很奇怪。创建一个二维数组似乎很愚蠢,你不觉得吗?然后,计算机再次以神秘的方式工作。
That''s weird. It seems pretty silly of it to create a two-dimensional array, don''t you think? Then again, computers do work in mysterious ways.
这篇关于显示范围的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!