Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
yulisunflower
Posted - 10/02/2009 : 12:24:34 PM Origin 7.5 SR6 Operating System: windows vista
Hi,
I have a question about how to get the number of rows of a worksheet. wks.GetNumRows seems to return a number no matter the last few rows is empty or not. What I really need is the number of rows that have value in it. It counts if that value is zero. I could not find a way of doing that. Can someone give a hand here? Thanks a lot.
Best Yu
2 L A T E S T R E P L I E S (Newest First)
yulisunflower
Posted - 10/28/2009 : 5:44:14 PM Tried it. Works well. Thanks a lot.
Yu
greg
Posted - 10/06/2009 : 5:08:32 PM The vectorbase class has a GetUpperBound method which can be accessed from the Dataset class as in:
// Worksheet column Data1_A must exist prior to execution int ii; Dataset dsA("Data1_A"); ii = dsA.GetUpperBound();