Hot to get a value of cell using VSTO

Hi All with this code u can get the cell values of a row of an excel sheet….. try it

 

Dim apedit As New APEditValues

Globals.ThisWorkbook.ActionsPane.Controls.Add(apedit)

Dim dsSrc As DataTable = Nothing

Src = Globals.Sheet1.List1.DataSource

Dim intValue As Integer = Globals.Sheet1.List1.SelectedIndex – 1

apedit.EditProjectCodeTextBox.Text = dsSrc.Rows(intValue)(0).ToString

apedit.EditProjectNameTextBox.Text = dsSrc.Rows(intValue)(1).ToString

apedit.EditTeamMembersTextBox.Text = dsSrc.Rows(intValue)(2).ToString

 

 

 

• Posted in: Visual Studio Tools for Office