Printable View
Hellow..:wave:
Where can i get the documentation of Excel Automation Interface Method and Properties? The interface is pretty confusing. :sick: I've desperated looking in microsoft sites and msdn, none is exist.. anybody can help? i need to finish my project to convert excel sheet cells into bunch of sql statement to be executed in oracle. I've been able to prepare the workbooks etc, but confused with some methods and properties. :ehh: thanks...
How can i parse the content of Range returned by _WorkSheet->UsedRange?
Hi.. It's me again.. still with some desperation..
How to select cell not by it's name but by it's index?
For example A1 is index 1,1 and A2 is index 1,2, etc.
Does the Excel::_Worksheet::GetUsedRange() function has a bug or something? coz i have 2 row and 5 column (2x5) of data. I call the function at the first time, it returns 2x5 range (which is correct). Then i expand/add the data to became 5x5, the function returns 5x5 size (which is.. still.. correct). But when i contract the data size into 3x5 or 4x5 and i recall the function, it still return 5x5. Does the function has a bug, or it's intended to do so..?
So how can i get the valid range that contains the real data?
Thanks..
As you see, GetUsedRange (or UsedRange.Rows.Count) is returning the maximum size a range has ever had. This is not specific to automation. You have the same phenomenom with Excel VBA.
A workaround in Excel VBA (sorry I don't know its equivalent in automation) is using ...End(xlDown) or ..End(xlUp).
Holly god..
It works well. I Used RangePtr->End(xlDown) & RangePTr->End(xlToRight), I can get the valid used range. Thanks, ur great
Now.. how can i get the active/selected cells? There are active sheets, active table, but no active cells or selected cells.