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