have you used the axSpreadsheet.get_Range method? i dont know how to use it. i have an axSpreadsheet widget on my form, it's lovelly. i don't know how it wants the cell positions passing to it, and i don't know what data type it returns (an array of floats would be nice). a code example would be appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
axSpreadsheet
- Thread starter seanbo
- Start date
- Thread starter
- #2
update: okay, it returns an OWC.Range. but i can't find a method to get the floats out i'm looking for. the best i can find is OWC.Range.ToString(), but it only ever returns "System.__ComObject"; but maybe that's because i don't know what to pass axSpreadsheet.get_Range (i actually passed it "a1", "a10" - but i don't think it wants strings).
- Thread starter
- #4
- Status