Xclputdata
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');