Xclputdata: Difference between revisions
Jump to navigation
Jump to search
imported>Jeremy (Importing text file) |
imported>Scott |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
===Purpose=== | ===Purpose=== | ||
| Line 10: | Line 9: | ||
===Description=== | ===Description=== | ||
XCLPUTDATA fills | XCLPUTDATA fills a range in an Excel spreadsheet using dynamic data exchange (DDE) with a data table contained in <tt>xdat</tt>. 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. | If the function doesn't work check the Excel menu '''tools/options/general''' and ensure that the '''ignore other applications''' check box is unchecked. | ||
| Line 18: | Line 17: | ||
To place a 3x5 data table contained in the workspace variable xdat into the spreadsheet 'book1.xls' in the range B2 to F4: | 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'); | xclputdata('book1.xls','r2c2:r4c6','xdat'); | ||
===See Also=== | ===See Also=== | ||
[[areadr]], [[spcreadr]], [[xclgetdata]], [[xclreadr]] | [[areadr]], [[mtfreadr]], [[spcreadr]], [[xclgetdata]], [[xclreadr]] | ||
Latest revision as of 16: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');