excel/c++

**m.albert** · 03-01-2003

Can someone advise an easy reference for importing data from an excel spreadsheet into a visual c++ console program to do calculations.
Thanks
Michael

**Sang-drax** · 03-01-2003

Save the Excel data as a tab-delimited text file and read it in your program with std::ifstream.

**m.albert** · 03-02-2003

Can you indicate the precise wording of the commands please.
Where can I find some written material on the subject.
Thanks and regards
Michael

**Sang-drax** · 03-02-2003

*Open the spreadsheet
*File->Save as...
*Choose tab-delimited file as 'file format'
*Press OK

I have a Swedish version of Excel, so I'm not 100% about the exact wording of the commands.

Then open the .txt file using std::ifstream in your C++ program. There are millions of tutorials about using ifstream on the Internet.

**m.albert** · 03-02-2003

What if I want to import directly from the excel file without converting it to text?
Thanks
Michael

**Speedy5** · 03-02-2003

This isn't my code, its just something I saved from this very board! I thought it might come in handy one day so:

Code:

#pragma warning (disable:4146)
#import "c:\Program Files\Common Files\Microsoft Shared\Office10\mso.dll"
#import "c:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.olb"
#import "C:\Program Files\Microsoft Office\Office10\excel.exe" \
	rename("DialogBox", "ExDialogBox") rename("RGB", "ExRGB")

#include <windows.h>
#include <iostream>



int main(){

	CoInitialize(0);

	try{
		Excel::_ApplicationPtr lpApp("Excel.Application");
		Excel::_WorksheetPtr lpWkst = 0;
		
		lpApp->PutVisible(0,TRUE);

		lpApp->Workbooks->Add();
		lpWkst = lpApp->ActiveSheet;

		lpWkst->Range["A1"]->Value2 = "Forename";
		lpWkst->Range["B1"]->Value2 = "Score";
		lpWkst->Range["A2"]->Value2 = "Dave"; 
		lpWkst->Range["B2"]->Value2 = 40L;
		lpWkst->Range["A3"]->Value2 = "Andrew";
		lpWkst->Range["B3"]->Value2 = 35L;
		lpWkst->Range["A4"]->Value2 = "Simon";
		lpWkst->Range["B4"]->Value2 = 29L;

		lpWkst = 0;
		lpApp = 0;

	}
	catch(_com_error& e){

		std::cout << "Error ";
		std::cout << static_cast<char*>
			((e.Description().length() ? e.Description() : ""));
		return 1;
	}

	CoUninitialize();

	return 0;
}

**Speedy5** · 03-02-2003

Do you see my above response? If not, please tell me and I'll repost.

**m.albert** · 03-03-2003

OK I saw your response thanks.

**Fordy** · 03-03-2003

Originally posted by Speedy5
This isn't my code, its just something I saved from this very board! I thought it might come in handy one day so:

Yeah....I thought it looked familiar

If you want to work with Excel data properly, you need to learn COM.......then the data in each cell is available in the form of a VARIANT (Could be a BSTR, an in, a bool...etc), and with the wrapper classes in tools like VC++ its very easy to work with them

**m.albert** · 03-05-2003

OK thanks where can I read some easy to understand material on this COM stuff: variants wrapper classes etc.
I often have excel worksheets that I would like to work on and write the results in another worksheet. As I am learning C++I would like to use c++ code for these programs.
Thanks
Michael

Thread: excel/c++

Thread Tools

Search Thread

Display

excel/c++

excel/c++