Xclputdata: Difference between revisions
Jump to navigation
Jump to search
imported>Jeremy (Importing text file) |
imported>Jeremy (Importing text file) |
||
| Line 1: | Line 1: | ||
===Purpose=== | ===Purpose=== | ||
Fill a data table in an Excel spreadsheet. | Fill a data table in an Excel spreadsheet. | ||
===Synopsis=== | ===Synopsis=== | ||
:xclputdata(filename,datarange,xmat,formt) | :xclputdata(filename,datarange,xmat,formt) | ||
===Description=== | ===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. | 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. | 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=== | ===Examples=== | ||
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]], [[spcreadr]], [[xclgetdata]], [[xclreadr]] | ||
Revision as of 15:27, 3 September 2008
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');