Read Excel row values

  • Thread starter Thread starter shantanu
  • Start date Start date
S

shantanu

Hi
Kindly help!!!!!!!!!

I have to read the excel row values say from A1 to A12

The requirement is something like
i have to get the values from the excel sheet of a perticular row i.e
i have to itrate thru the row and get the values till a blank cell is
encountered. Can anyone provide me a solution.

thanks and regards
 
Hi shantanu

you could use a loop

start_row = 1
for i = start_row to activesheet.rows.count
if activesheet.cells(i,1).value = "" then exit for
'do here whatever you want
next i

you can change the value of start_row if you don't
want to start from row 1.

if you need to know more, just ask.

hth

Carlo
 
Hi shantanu

you could use a loop

start_row = 1
for i = start_row to activesheet.rows.count
if activesheet.cells(i,1).value = "" then exit for
'do here whatever you want
next i

you can change the value of start_row if you don't
want to start from row 1.

if you need to know more, just ask.

hth

Carlo






- Show quoted text -
Click to expand...

Thanks a loads
But can you provide the same wrt c#
it will highly helpful.
regards
shantanu
 
Back
Top