Serving the Quantitative Finance Community

 
User avatar
Squal
Topic Author
Posts: 1
Joined: January 21st, 2004, 9:14 am

XLL and excel

August 1st, 2008, 10:47 am

Hi does anyone know how to get the dimension of the Matrix select by the user in excel indor to have the right CellMatrix dimension with xlw.Exemple the user select Row =1 and column =4. I wish to capture 1 and 4 when I use xlw.In fact I don't want to buil addin function with a pre format.Regards,
 
User avatar
mj
Posts: 12
Joined: December 20th, 2001, 12:32 pm

XLL and excel

August 3rd, 2008, 5:49 am

i am not quite sure what you want. the CellMatrix class has methods unsigned long RowsInStructure() const; unsigned long ColumnsInStructure() const;