Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Read Excel row values
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Read Excel row values
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Read Excel row values
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Read Excel row values
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 - |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
read the values from a excel row | Excel Worksheet Functions | |||
How do I read unknown values from an existing chart? | Charts and Charting in Excel | |||
Read series values range of a chart | Charts and Charting in Excel | |||
how do i read off values from a chart created in excel? | Excel Discussion (Misc queries) | |||
How do I read values from a line chart? | Charts and Charting in Excel |