Clash Royale CLAN TAG#URR8PPP

Unable to get a specific Cell value from a Table

I need to port some VBA code to a VB.Net addon, but I can't get a particular cell value from my Table.

VBA

VB.Net

I am able to change Range(2,2) to "Test" but table.Range(2, 2).ToString gives System.__ComObject as Value.

Range(2,2)

"Test"

table.Range(2, 2).ToString

System.__ComObject

Private Sub Button1_Click(sender As Object, e As RibbonControlEventArgs) _
Handles Button1.Click

Dim table As Excel.ListObject
table = Globals.wsTables.ListObjects("vehicleDefinations")
table.Range(2, 2) = "Test"

Dim file As New System.IO.StreamWriter _
("C:UsersRyzen2600xDownloadsDebug.txt", False)
file.WriteLine(table.Range(2, 2).ToString)
file.Close()

End Sub


file.WriteLine(table.Range(2, 2).Value2)

3 Answers
3

Don't use .Range to retrieve the value. Instead try to use

table.DataBodyRange.Cells(2, 2)

or

[MyTable].Cells(2,2)

ListObject().Range

Application.Range

table.DataBodyRange.Cells(2,2)

=

You're missing the .Value

.Value

file.WriteLine(table.Range(2, 2).Value.ToString)


Please reference this code:

private void ListObject_Range()

Microsoft.Office.Tools.Excel.ListObject list1 = this.Controls.AddListObject(this.Range["A1", "C4"], "list1");
MessageBox.Show("The list object contains " + list1.Range.Cells.Count.ToString() + " cells.");



More informaiton, please see

ListObject.Range Property

Help it helps you.

Thanks,
Yuki

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.