Origin Ver. and Service Release (Select Help-->About Origin): 8.5Pro Operating System:Win7
Hi guys! Got a problem: i have a several worksheets in one workbook and number of worksheets can be different. So i need to find a mean value and standard deviation for columns 5-10 in worksheets starting from second and finish before two last...and put results to a specified column in last worksheet.
3. Get Columns collection from worksheet, and then get column data by GetDataObject method. The result vector contains the data for calculating the mean and standard deviation.
Thanks Penn! I manage to figure out how to loop over worksheets but now i dont understand how to select columns from 5 till 10 and make basic statistics for each of them...it is confusing me. ive tried SetRange but it is wrong i guess.
Please focus on step 3, 4, and 5. Also, an example, which I have told in this thread before, can be referred to. If you want to combine columns from 5 to 10 as one dataset to calculating mean and standard deviation, you can refer to the vector class to handle the vectors derived from step 3.