Read the Cell(row,column) value from Excel
if i give the data in only one cell 13th Row,9 column..if i don't know the row and column numbers then how will i read that data.
I tried with below code..but its not working,it shows row and column count as only 1.
Set Exo=CreateObject("Excel.Application") '''Create the object for excel
Row_Count=Wso.Usedrange.Rows.Count ''''count the rows
Column_Count=Wso.Usedrange.Columns.Count '''count the colums
For i=1 to Row_Count
For j=1 to Column_Count
strTotalData=Wso.Cells(i,j) '''read the data cell by cell
This code tries to print (1,1) value..but i want (13,9) value.
Can any one please help me.
The code looks perfect. But it will only work when there is a value in 13,9
Thanx for reply.
Value is there in 13,9.
But i got the rowcount and columncount as one only then strTotalData=Wso.Cells(i,j)=Wso.Cells(1,1)
Then there is no data in 1,1..then i got empty value.
Exo.Visible = True
to make sure you see which excel was opened. Also make sure you are referring to the correct sheet as well