I am converting some codes from Excel VBA
to C#
and run into this problem. I am not sure the equivalent of this code in c#. Intellisence
wasn't very helpful :(
Selection.ShapeRange.Adjustments.Item(1) = 90
I managed to get as far as Adjustment
in c# but there is no Item
property.
The VB to C# code converter from the SharpDevelop team is now a standalone extension to Visual Studio. Once installed, you can convert an entire VB.NET project to C# by opening the solution, right clicking the solution node in the Solution Explorer and selecting Convert to C#.
Released in 1996, it is written in C++ and became an object oriented language. VBA 5.0 was launched in 1997 along with all of MS Office 97 products.
You can try my ESharper add-in to write an Excel automation command in C#. It is easier than creating a separate C# application or an add-in, and you will have access to both Excel object model and Excel C API with more options for performance optimization.
Per MSDN it seems the Adjustments
property has an indexer, so you could do this:
Selection.ShapeRange.Adjustments[1] = 90;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With