Forum Discussion
irina_lukina
13 years agoSuper Contributor
Hi, Abdul.
1.
If I want the value of 10th Row in 1st Column, How can I get it ? , For that do I require to Increment the Driver 10 times?
If you need to get this value using the DDT Drivers, I'm afraid, incrementing the current value several times is the only way. However, I've registered your suggestion to provide access to a specific cell through DDT drivers in our DB. Thanks for your feedback.
2.
Is there any alternate way to fetch the value?
Yes, you can access the needed value by its index when working with Excel via COM. For this purpose, you can use, for example, the following code:
function ReadDataFromExcel()
{
var Excel = Sys.OleObject("Excel.Application");
Excel.Workbooks.Open("C:\\MyFile.xls");
var value=Excel.Cells(10,1);
Log.Message("The value is: " + VarToString(value));
Excel.Quit();
}
For more information on working with Excel via COM, see the Working With Excel Files via COM help topic.
Related Content
Recent Discussions
- 9 hours agoSubhraDas
- 2 days agotramuntana