LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 30
Default Read Excel row values

On Nov 28, 12:53 pm, carlo wrote:
Sorry, no idea about c#
maybe someone else can help you!

On Nov 28, 4:34 pm, shantanu wrote:



On Nov 28, 12:09 pm, carlo wrote:


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


On Nov 28, 2:59 pm, shantanu wrote:


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- Hide quoted text -


- Show quoted text -


Thanks a loads
But can you provide the same wrt c#
it will highly helpful.
regards
shantanu- Hide quoted text -


- Show quoted text -- Hide quoted text -


- Show quoted text -


thanks a loads
regards
shantanu


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
read the values from a excel row shantanu Excel Worksheet Functions 2 July 13th 07 09:22 AM
How do I read unknown values from an existing chart? Thallos Charts and Charting in Excel 2 July 10th 07 10:32 PM
Read series values range of a chart matelot Charts and Charting in Excel 2 May 15th 07 03:45 AM
how do i read off values from a chart created in excel? rachel Excel Discussion (Misc queries) 0 December 11th 05 05:31 PM
How do I read values from a line chart? Lynn Charts and Charting in Excel 3 October 9th 05 09:11 PM


All times are GMT +1. The time now is 06:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"