3 ms·

"Why not just pass an array of arguments?" Speed and convenience, I'd imagine? IIRC, arrays are marshalled as SAFEARRAYs in COM and those things are quite heav

"Why not just pass an array of arguments?" Speed and convenience, I'd imagine? IIRC, arrays are marshalled as SAFEARRAYs in COM and those things are quite heavy-weight, you'd really rather call a 31-parameter function and pass it 27 NULLs in places of extraneous parameters.

mixtur2021 5y ago
Only if using safe-for-scripting/Ole Automation types/interfaces in your IDL. Otherwise, it's fully possible to pass C-style arrays in COM.
- pjmlp 5y ago
  Which is the case here, => "Microsoft.Office.Interop.Excel".
- poizan42 5y ago
  Excel is out-of-proc so it relies heavily on marshaling. It's either that or custom marshaling. Also it's the same interface as is used internally in the application with VBA scripting.