7
$\begingroup$

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?

Improve this question
$\endgroup$
3
  • $\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$ Commented Jun 16, 2017 at 10:33
  • $\begingroup$ I have not found a solution to this. $\endgroup$ Commented Aug 24, 2017 at 14:30
  • $\begingroup$ I see this is an old question, but I'd like to know the answer to this as well. Being able to do something like Workbooks("book1").Close SaveChanges:=False would be very helpful to manipulate notebooks more easily. $\endgroup$ Commented Mar 24, 2022 at 13:25

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.