return multi dimension array to excel from c++ xll -

-

this works fine when try pass 1 dimension array

__declspec(dllexport) lpxloper testarray() {     xloper xlvalues[2];     xlvalues[0].xltype = xltypenum;     xlvalues[1].xltype = xltypenum;     xlvalues[0].val.num = 123;     xlvalues[1].val.num = 345;      static xloper xlarray;     xlarray.xltype = xltypemulti | xlbitdllfree;     xlarray.val.array.rows = 2;     xlarray.val.array.columns = 1;     xlarray.val.array.lparray = &xlvalues[0];     return (lpxloper)&xlarray; }

but when try pass multi dimension array, function returns #num!

__declspec(dllexport) lpxloper testarray1() {     xloper xlvalues[2][2];     xlvalues[0][0].xltype = xltypenum;     xlvalues[0][1].xltype = xltypenum;     xlvalues[1][0].xltype = xltypenum;     xlvalues[1][1].xltype = xltypenum;      xlvalues[0][0].val.num = 123;     xlvalues[0][1].val.num = 456;     xlvalues[1][0].val.num = 345;     xlvalues[1][1].val.num = 43456;      static xloper xlarray;     xlarray.xltype = xltypemulti | xlbitdllfree;     xlarray.val.array.rows = 2;     xlarray.val.array.columns = 2;     xlarray.val.array.lparray = &xlvalues[0][0];     return (lpxloper)&xlarray; }

any ideas? in advance!!

in both testarray( ) , testarray1( ) xlvalues local variable on stack, freed runtime when function returns. need make xlvalues heap allocated memory work reliably. xll development of dark art. if you're going serious should invest in copy of steve dalton's book.


Comments

Post a Comment

Popular posts from this blog

html - height not adding height to a empty div -

-
hey guys new bootstrap , have following html :: <div class="col-md-6 clients"> <div class="col-xs-4"><img src="img/1.jpg" alt="" class="img-responsive"></div> <div class="col-xs-4"><img src="img/1.jpg" alt="" class="img-responsive"></div> <div class="col-xs-4"><img src="img/1.jpg" alt="" class="img-responsive"></div> <div class="col-xs-4"><img src="img/1.jpg" alt="" class="img-responsive"></div> <div class="col-xs-4"><img src="img/1.jpg" alt="" class="img-responsive"></div> <div class="col-xs-4"><img src="img/1.jpg" alt="" class="img-responsive"></div> </div> now after 1st 3 col-xs-4 wan...
Read more

Oracle SQL. How to select specific IDs where value of columns specify criteria? -

-
i have following statement/query: select table1.file_id, table1.status, table2.status table1 inner join table2 on table1.file_id = table2.file_id; the result follows: file id | status table 1 | status table 2 ----------------------------------------------------- 5500002 | ax | ics 5500002 | ax | icso 5500002 | axo | ics 5500003 | ax | ics 5500003 | ax | ics 5500003 | ax | ics 5500004 | null | icso test 5500004 | axo | ics 5500004 | ax | null i need each file id check 4 statuses: - ax - axo - ics - icso i want run select on file id s cover 4 statuses. can see file id occurs multiple times , i'd want query return file id fulfills requirement, in instance return 5500002 , 5500004. for 550000...
Read more

python - Robot Framework location and name of keyword -

-
i want create python library 0 argument function custom robot framework keywords can call. needs know absolute path of file keyword defined, , name of keyword. know how similar test cases using robot.libraries.builtin library , ${suite_source} , ${test name} variables, can't find similar custom keywords. don't care how complicated answer is, maybe have dig guts of robot framework's internal classes , access data somehow. there way this? thanks janne able find solution. from robot.running.context import execution_contexts def resource_locator(): name = execution_contexts.current.keywords[-1].name libname = execution_contexts.current.get_handler(name).libname resources = execution_contexts.current.namespace._kw_store.resources path = "" key in resources._keys: if resources[key].name == libname: path = key break return {'name': name, 'path': path} execution_context...
Read more