To access value from Local Action Sheet of Run Time Data Table,
use the following.Datatable.GetSheet("Sheet Name").SetCurrentRow("Mention Row Number from where you want to access the value")Cell_Value = Datatable.GetSheet("Sheet Name").GetParameter("Mentioned Column Name from where you want to access the Value").ValueMsgbox Cell_Value
To access value from Global Data Sheet of Run Time Data Table, use the following.Datatable.GlobalSheet.SetCurrentRow("Mention Row Number from where you want to access the value")Cell_Value = Datatable.GlobalSheet.GetParameter("Mentioned Column Name from where you want to access the Value").ValueMsgbox Cell_Value
Wednesday, December 19, 2007
How to access values from an excel sheet cell ?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment