Dyalog Primer - Cooperation - Microsoft Office
rcs←dbs.OpenRecordset⊂'Select * from zipcodes'
example uses a database which appears to be installed as part of
Windows XP - why an operating system needs to know US zip codes escapes
me. If you don't find this database, I suggest you look for
another with the .mdb filename extension and explore it via the SQAPL
interface then rework the exploration session.
theory, Openoffice.org can be driven via this mechanism (in practice is
a different story),.
- Dyalog Interface Guide; OLE Automation chapter.
supplied workspaces (SAMPLES/OLE and SAMPLES\OO4APL folders)
- Write a function which retrieves rows satisfying a SELECT condition from an Office/SQL database (without using SQAPL)
- Write a function which retrieves the values of a set of cells from an active Excel spreadsheet
- Write a function which replaces the values of a set of cells in an Excel spreadsheet.