Creating an excel chart out of a splitted range with MFC Excelautomation

[dushkin]

Hello all.

I need to create a chart from a range of 2 columns.
For example: A1:A20 and C1:C20.
I need the A column to get the lables of the rows, unless someone has
a better idea...

Now, as far as I know, GetRange gets 2 cells as parameters.
How Can I pass ChartWizard() function a range of those 2 columns?

Thanks!

 

[filip]

Hello all.

 I need to create a chart from a range of 2 columns.
 For example: A1:A20 and C1:C20.
 I need the A column to get the lables of the rows, unless someone has
a better idea...

 Now, as far as I know, GetRange gets 2 cells as parameters.
 How Can I pass ChartWizard() function a range of those 2 columns?

Thanks!

Hi,

Excel automation is very complicated way to deal with your Excel. You
should use 3rd party component for easier and faster work, like
GemBox.Spreadsheet component
http://www.gemboxsoftware.com/GBSpreadsheet.htm

Here you can see why is GemBox.Spreadsheet better then Excel
Automation: http://www.gemboxsoftware.com/Excel-Automation.htm

Filip
http://www.gemboxsoftware.com/

 

[dushkin]

Thanks, I eventualy used _Application Union method.