How to use named arguments in .NET/Link (COM interface to Excel)

Asked 5 years, 2 months ago

Viewed 155 times

I am using Excel from Mathematica through .NET/Link (specifically using the COM interface).

The following C# code adds a sheet after the last sheet:

workbook.Sheets.Add(After: workbook.Sheets.Count);

How can I use named arguments (After: in the example above) in .NET/Link to do the same?

asked Oct 14 '14 at 18:44

David Creech

9708 silver badges15 bronze badges

$\begingroup$ When faced with this problem, I couldn't find an answer either, so I ended up having to create sheets in reverse order, as the default behaviour is for Excel to put new sheets in front of the last one. In the meantime have you found a solution? If not, how can this question be bumped up? Does a new one have to be submitted? $\endgroup$ – Gaius Jun 16 '17 at 10:33
$\begingroup$ I have not found a solution to this. $\endgroup$ – David Creech Aug 24 '17 at 14:30

add a comment |

0 Your Answer

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy