Keith A. Lewis
Keith A. Lewis
The call stack is not very deep, so this is probably not the issue, but every call to `Excel12` has a fairly hefty stack allocation: ``` int _cdecl Excel12(int xlfn,...
You can try something like DEPENDS, but you must pass a parameter: https://github.com/xlladdins/xll/blob/master/xll/macrofun/xll_utility.cpp
@nobisheikh How much are you willing to pay to solve this problem? You may want to look into Extended Validation Certificates.
I was thinking in terms of the policy used by your customer for exempting files from scans.
The data are stored in a 1-d array so just swap rows and columns members before returning.
The ChatGPT Oracle has pondered your question deeply. If you have a `XLOPER12 o` with `o.val.array.rows == 1` you can achieve nirvana with `std::swap(o.val.array.rows, o.val.array.columns)`. If you see sharp a...
If it is an array of `double` then the [`FP/FP12`](https://github.com/xlladdins/xll#fp-data-type) abominations involve only passing a pointer. Transpose is expensive if the array has more than one row and column.
4) https://github.com/xlladdins/xll/blob/master/test/transpose.cpp If this is not 10x faster than the other methods, I'll eat my hat.
AFAIK, ExcelDna does not expose the FP/FP12 datatype, so you will need to use C++ if performance is a concern.
Done! What would you like to see in it? P.S. My blog is [xllblog.com](xllblog.com).