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 APEditValuesGlobals.ThisWorkbook.ActionsPane.Controls.Add(apedit)
Dim dsSrc As DataTable = NothingSrc = 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
Recent Comments