PLS_Toolbox Documentation: xclputdata	< xclgetdata	xclreadr >

xclputdata

Purpose

Fill a data table in an Excel spreadsheet.

Synopsis

xclputdata(filename,datarange,xmat,formt)

Description

XCLPUTDATA fills a a range in an Excel spreadsheet using dynamic data exchange (DDE) with a data table contained in the variable xdat. This function only works on a PC, 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, spcreadr, xclgetdata, xclreadr