Xclputdata

From Eigenvector Research Documentation Wiki
Revision as of 15:34, 21 September 2011 by imported>Scott (See Also)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Purpose

Fill a data table in an Excel spreadsheet.

Synopsis

xclputdata(filename,datarange,xmat,formt)

Description

XCLPUTDATA fills a range in an Excel spreadsheet using dynamic data exchange (DDE) with a data table contained in xdat. This function only works on Microsoft Windows and the spreadsheet must be open in Office 97 or higher.

If the function doesn't work check the Excel menu tools/options/general and ensure that the ignore other applications check box is unchecked.

Examples

To place a 3x5 data table contained in the workspace variable xdat into the spreadsheet 'book1.xls' in the range B2 to F4:

xclputdata('book1.xls','r2c2:r4c6','xdat');

See Also

areadr, mtfreadr, spcreadr, xclgetdata, xclreadr