Excel Toolkit based on GOOP (1.1)
==================================
This excel-toolkit implements basic functions for importing & exporting data
(strings & doubles). The use of multiple sheets and multiple workbooks is supported.
some other functions available are : print, copy, rename sheet, save workbook, calling macro's etc.....
This Excel Toolkit is based on GOOP. Goop stands for "G Object Oriented Programming",
a LabVIEW add-on. It is available for free from NI. GOOP is built around the object
repository which implements the object-reference<->object-data<->data-locking mechanism.
You can download the GOOP-wizzard at www.ni.com. All source code is available,
no password-locks except for the GOOP-vi's.....
the toolkit is tested with Excel97, and will work with LabVIEW 6i and Excel2000
how to add excel toolkit in function palette? :
use Edit|Edit Control & Function Palettes, function palette, insert submenu and link to
library .llb, browse to excel.llb ....
-> remember to rename 'readonly.txt' file in active palette to enable palette editing ;-)
known problems:
an ActiveX update problem may occur, please search the NI-knowledgebase.
possible solution : re-select same method. We saw this only in 'excel print.vi' }
note:
The excel-reference in this toolkit points to a sheet within a workbook. Some functions
operate on the workbook (parent of worksheet). This implies that just before calling
the 'save workbook' method, all updates in other sheets of same workbook must have occured.
examples:
You can see a lot of techniques (good and *bad*) in the examples, some
info & hints are on diagram...
Philips Research, COS/TMA
email: martin.vernhout@philips.com
- 1
- 2
前往页