// tstxls.cpp : Defines the entry point for the console application.
//

#include "stdafx.h"

#include <ole2.h>
#include <stdio.h>
//#include <windows.h>

#pragma warning (disable: 4146   4192   4786   4081 )
#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\MSWORD.olb" rename("ExitWindows","ExitWindowsEx")
#import "c:\Program Files\Microsoft Office\Office10\excel.exe" rename("DialogBox", "DialogBoxXL") rename("RGB", "RBGXL") \
         rename("DocumentProperties", "DocumentPropertiesXL") exclude("IFont","IPicture")

void dump_com_error(_com_error &e)
{
    _bstr_t bstrSource(e.Source());
    _bstr_t bstrDescription(e.Description());

    printf("Code = %08lx\nCode meaning = %s\nSource = %s\nDescription = %s\n", 
		e.Error(),e.ErrorMessage(),(LPCTSTR) bstrSource,bstrDescription);	
}

struct StartOle {
    StartOle() { CoInitialize(NULL); }
    ~StartOle() { CoUninitialize(); }
} _inst_StartOle;



int main(int argc, char* argv[])
{
	using namespace Excel;

	char ceilA1[ 50 ];
	char ceilB1[ 50 ];
	char StrFilePath[ 100 ] = "C:\\tst.xls";


    try {
		_ApplicationPtr pApp(L"Excel.Application");
		
		_WorkbookPtr  pBook  = pApp->Workbooks->Open(_bstr_t(StrFilePath));
		_WorksheetPtr pSheet = pBook->GetActiveSheet();

		strcpy(ceilA1,(_bstr_t)pSheet->Range["A1"]->Value2);
		strcpy(ceilB1,(_bstr_t)pSheet->Range["B1"]->Value2);

		pBook->Close();
		pApp->Quit();
    } catch(_com_error &e) {
    dump_com_error(e);
    }


	printf("%s,%s\n",ceilA1,ceilB1);
	return  0 ;
}