Mfc Dialogbased application plot graph for excel file

Question

1.00/5 (1 vote)

See more:

Hi ,

I have use this link for reference.

Automating Excel 2007 and creating charts using C++ MFC application in Visual Studio 2008[^]

But in this project excel cell values are hard coded by using range.put_value2

range = sheet.get_Range(COleVariant(TEXT("C3")),COleVariant(TEXT("C3")));
range.put_Value2(COleVariant(short(30)));

I want to plot graph for excel files. whichever file I choose It should plot the graph for that excel file data. I don't want to hardcode the data How i can do it?

Thank you.

Posted 3-Jul-14 5:51am

peoria123

Add a Solution

Comments

George Jonsson 3-Jul-14 22:45pm

Do you want to read existing data from an Excel document and then make the graph pro grammatically in the same Excel document?
One way to make it easier is to use named columns and the get the columns via SQL command.
The problem is I have never connected to an Excel sheet via OleDb or ODBC in C++, only in C#.
http://msdn.microsoft.com/en-us/library/7wtdsdkh.aspx

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

KarstenK · Answer 1 · 2014-07-03T20:46:00

Solution 1

Create instances of the COleVariant with your values an apply them in the code

CString myCell = TEXT("C3");//or any other
range = sheet.get_Range(COleVariant(myCell),COleVariant(myCell));

Posted 3-Jul-14 20:46pm

KarstenK

Comments

peoria123 7-Jul-14 13:51pm

Hi,
Thank you for your answer. It is working but I have very big excel file with lots of rows and 4 columns. Row size is not fixed .can I read whole coloumn at once insted of reading cell by cell. or can it be possible to open excel file in Sheet1 and it will plot graph for the data which is in sheet 1.

Thank you.

Mfc Dialogbased application plot graph for excel file

1 solution

Solution 1

Add your solution here

Preview 0

Mfc Dialogbased application plot graph for excel file

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us