描述:
WorkbooksPtr pBooks ;这里的workbooksPtr和workbooks有什么区别?
_WorkbookPtr pBook ;还有_workbookptr和_workbook有什么区别?还有就是workbook和_workbook有什么区别?
SheetsPtr pSheets ;
_WorksheetPtr pSheet;
RangePtr pRange;
还有就是有关这个:
using namespace System;
using namespace System::Reflection; // 这些在C++中创建的时候
using namespace System::Runtime::InteropServices; //
using namespace Microsoft::Office::Core;
using namespace Microsoft::Office::Interop::Excel;
我现在用的是office2003,但是这样的话我看下面因为我的程序不可能只在我自己的电脑上使用,下面会不会导致移植性不好?
//import mso.dll
#import "C:\Program Files\Common Files\Microsoft Shared\OFFICE11\mso.dll" \
rename("RGB", "MSRGB")
//import VBE6EXT.OLB
#import "C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB" raw_interfaces_only, \
rename("Reference", "ignorethis"),\
rename("VBE", "JOEVBE")
//import excel.exe
#import "C:\Program Files\Microsoft Office\OFFICE11\excel.exe" exclude("IFont", "IPicture") \
rename("RGB", "ignorethis"),\
rename("DialogBox", "ignorethis"),\
rename("VBE", "JOEVBE"), \
rename("ReplaceText", "JOEReplaceText"),\
rename("CopyFile","JOECopyFile"), \
rename("FindText", "JOEFindText"),\
rename("NoPrompt", "JOENoPrompt")