fwrite_xls (MathScript RT Module Function)
LabVIEW 2012 MathScript RT Module Help
Edition Date: June 2012
Part Number: 373123C-01
»View Product Info
Edition Date: June 2012
Part Number: 373123C-01
»View Product Info
 | Download Help (Windows Only) |
Owning Class: support
Requires: MathScript RT Module (Windows)
Syntax
fwrite_xls(file, a)
fwrite_xls(file, a, sheet)
fwrite_xls(file, a, sheet, range)
Legacy Name: xlswrite
Description
Writes data to a Microsoft Excel spreadsheet file.
Inputs
| Name | Description |
|---|---|
| file | Specifies the Excel file to which you want to write. file is a string. |
| a | Specifies the data you want to write. a can be string or a numeric value in a scalar or a matrix. |
| sheet | Specifies the spreadsheet in file to which you want to write. sheet can be an integer that specifies the index of a spreadsheet or a string that specifies the name of a spreadsheet. If you do not specify sheet, LabVIEW writes a to the first spreadsheet. |
| range | Specifies the range of data in sheet you want to write. range is a string. The default is 'A1'. |
Details
To specify the range, you can use a cell number, such as 'A1', that specifies the top left cell at which to begin writing, or you can use a colon as a range operator. For example, you can specify 'A1:B3', where A1 and B3 specify the top left and bottom right cells to which you want to write data. If you use a colon as a range operator to specify the range and if the size of a is larger than the range, LabVIEW ignores the elements outside of the range.
The following table lists the support characteristics of this function.
| Supported in the LabVIEW Run-Time Engine | Yes |
| Supported on RT targets | No |
Examples
a = magic(3);
fwrite_xls('test', a);
pause(1)
b = fread_xls('test')
Related Topics
Helpful
Not Helpful