Xclgetdata: Difference between revisions
imported>Jeremy (Importing text file) |
imported>Scott |
||
| (3 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
===Purpose=== | ===Purpose=== | ||
| Line 10: | Line 9: | ||
===Description=== | ===Description=== | ||
XCLGETDATA extracts a data table from an Excel spreadsheet using dynamic data exchange (DDE) | XCLGETDATA extracts a data table from an Excel spreadsheet using dynamic data exchange (DDE). This function only works on a Microsoft Windows system. In addition, the spreadsheet must be open in Office 97 or higher, and character arrays can't be extracted. | ||
It has been observed that XCLGETDATA won't work unless a copy of the open spreadsheet is saved to the hard drive and the name in filename is exact. Also, if the function doesn't work check the Excel menu '''tools/options/general''' and ensure that the '''ignore other applications''' check box is unchecked. | It has been observed that XCLGETDATA won't work unless a copy of the open spreadsheet is saved to the hard drive and the name in filename is exact. Also, if the function doesn't work check the Excel menu '''tools/options/general''' and ensure that the '''ignore other applications''' check box is unchecked. | ||
<span style='border: solid 1px; padding: 3px;'>'''NOTE:''' for better support of reading XLS files, please see the function [[xclreadr]].</span> | |||
===Examples=== | ===Examples=== | ||
| Line 18: | Line 19: | ||
To get a table data from the range C2 to T25 from the open workbook 'book1.xls': | To get a table data from the range C2 to T25 from the open workbook 'book1.xls': | ||
data = xclgetdata('book1.xls','r2c3:r25c20'); | |||
To get a table data from 'Sheet2' the range D4 to F16 from the open workbook 'book1.xls': | To get a table data from 'Sheet2' the range D4 to F16 from the open workbook 'book1.xls': | ||
data = xclgetdata('c:\book1.xls\sheet2','r4c4:r16c6'); | |||
===See Also=== | ===See Also=== | ||
[[areadr]], [[spcreadr]], [[xclputdata]], [[xclreadr]] | [[areadr]], [[mtfreadr]], [[spcreadr]], [[xclputdata]], [[xclreadr]] | ||
Latest revision as of 15:33, 21 September 2011
Purpose
Extract a data table from an Excel spreadsheet.
Synopsis
- xmat = xclgetdata(filename,datarange,formt)
Description
XCLGETDATA extracts a data table from an Excel spreadsheet using dynamic data exchange (DDE). This function only works on a Microsoft Windows system. In addition, the spreadsheet must be open in Office 97 or higher, and character arrays can't be extracted.
It has been observed that XCLGETDATA won't work unless a copy of the open spreadsheet is saved to the hard drive and the name in filename is exact. Also, if the function doesn't work check the Excel menu tools/options/general and ensure that the ignore other applications check box is unchecked.
NOTE: for better support of reading XLS files, please see the function xclreadr.
Examples
To get a table data from the range C2 to T25 from the open workbook 'book1.xls':
data = xclgetdata('book1.xls','r2c3:r25c20');
To get a table data from 'Sheet2' the range D4 to F16 from the open workbook 'book1.xls':
data = xclgetdata('c:\book1.xls\sheet2','r4c4:r16c6');