C++ Programming for Financial Engineering
Highly recommended by thousands of MFE students. Covers essential C++ topics with applications to financial engineering. Learn more Join!

Python for Finance with Intro to Data Science
Gain practical understanding of Python to read, understand, and write professional Python code for your first day on the job. Learn more Join!

An Intuition-Based Options Primer for FE
Ideal for entry level positions interviews and graduate studies, specializing in options trading arbitrage and options valuation models. Learn more Join!

Reply to thread

Message: <blockquote data-quote="Daniel Duffy" data-source="post: 35349" data-attributes="member: 607">I think you are using .NET 3.0 which does not support optional parameters. Use MISSING parameter as the test case here shows. Furthermore, you need to cast the C# 'Object' to the correct type. BTW you don't need COM explicitly because .NET wrappers are created automatically. In that sense Excel integration is a lot easier than before. <a href="http://www.datasimfinancial.com/forum/viewtopic.php?t=20" target="_blank">http://www.datasimfinancial.com/forum/viewtopic.php?t=20</a>   I Excel.ChartObjects xlCharts = (Excel.ChartObjects)getWorkSheet(4).ChartObjects(misValue); Excel.ChartObject myChart = (Excel.ChartObject)xlCharts.Add(10,80,300,250); <-------- Exception thrown here   II ch.ChartWizard(ws.get_Range(String.Format("A1:B{0}", i), Type.Missing), Excel.XlChartType.xlCylinderCol, 1,Excel.XlRowCol.xlColumns, 1, 0, true, "Chart with values of each row","Rows", "Value", "Extra Title"); // Create chart on same worksheet and format the chart using the chart wizard.ch=(ws.ChartObjects(Type.Missing) as Excel.ChartObjects).Add(150, 0, 400, 400).Chart;</blockquote>