<< prev file | next file >>    view single page | view frames    summary: fields | routine    details: routine

.\

idlffexcel__define.pro

Last modification:
Mon May 07 09:56:01 2007
Simple IDL-> Excel Example -- IDL reading from Excel The following object definition is part of the IDL_MicrosoftOffice_64 archive that contains examples (Word, Excel, Spreadsheet) for how IDL 6.4 can host Microsoft Office Application Objects and a visual, Spreadsheet Control. WARNING: Extreme care must be taken when using this utility. Misuse can crash IDL if care is not taked to correctly define cell ranges. Error checking is in place, but mixed datatype errors occurring deep in the COM control are not trapped by this prototype interface (yet).

Field summary

FILENAME
string
OCELLRANGE
object reference
OEXCEL
object reference
OSHEET
object reference
OSHEETCOLLECTION
object reference
OWKBOOKCOLLECTION
object reference
OWKBOOKDATA
object reference

Routine summary

result = IDLffExcel::Init(fileName, sheet=sheet)

result = IDLffExcel::GetData(inputRange)

GetData Method.

IDLffExcel::SetProperty[, sheet=sheet], _extra=_extra

Sets Properties on IDLffExcel Object

IDLffExcel::Cleanup

IDLffExcel__define

topIDLffExcel::Init com, word, excel, spreadsheed, document

result = IDLffExcel::Init(fileName, sheet=sheet)

Parameters

fileName       

Keywords

sheet       

Version history

Author

Paul Sommer ITT, Technical Sales Engineer

Version

1.0

History

05.06.07 Written

Customer ID

Raytheon

Known issues

Restrictions

Not supported by ITT Technical Support. Use at your own risk. (Prototype code only)

Other attributes

Requires IDL version

Licensed copy of Microsoft Office 2003 IDL 6.4 (Supports hosting COM Application Objects) Previous versions of IDL require custom IDLmscomAx.dll to be copied into IDL's bin.x86 directory. Contact the author of this tool if you need this dll.

topIDLffExcel::GetData

result = IDLffExcel::GetData(inputRange)

GetData Method. Data from passed in range parameter

Parameters

inputRange        in required

input Example: oExcel = Obj_New("IDLffExcel", "myData.xls") myData= oExcel->GetData("A1:A100" | ["P1:P100","S1:S100"])

topIDLffExcel::SetProperty

IDLffExcel::SetProperty[, sheet=sheet], _extra=_extra

Sets Properties on IDLffExcel Object

Keywords

sheet        in optional

input Example: oExcel = Obj_New("IDLffExcel", "myData.xls") oExcel->SetPropery, SHEET="Sheet2"

_extra       

topIDLffExcel::Cleanup

IDLffExcel::Cleanup

topIDLffExcel__define

IDLffExcel__define

Produced by IDLdoc 2.0 on Mon May 07 09:58:37 2007.