Xclputdata: Difference between revisions
Jump to navigation
Jump to search
imported>Jeremy No edit summary |
imported>Scott |
||
| Line 21: | Line 21: | ||
===See Also=== | ===See Also=== | ||
[[areadr]], [[spcreadr]], [[xclgetdata]], [[xclreadr]] | [[areadr]], [[mtfreadr]], [[spcreadr]], [[xclgetdata]], [[xclreadr]] | ||
Latest revision as of 15:34, 21 September 2011
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');