Topics
All
Mac OS X
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Guides
Examples
New in version:
7.1
7.2
7.3
7.4
7.5
8.0
8.1
8.2
8.3
8.4
Statistic
XL.CopyRow
Copies a row from one row to another row.
| Component | Version | macOS | Windows | Server | FileMaker Cloud | FileMaker iOS SDK |
| XL | 6.5 | Yes | Yes | Yes | Yes | Yes |
MBS( "XL.CopyRow"; bookRef1; bookRef2; sheetIndex1; sheetIndex2; SourceRow; DestRow )
Parameters
| Parameter | Description | Example value |
|---|---|---|
| bookRef1 | The reference to the source workbook. Please use XL.LoadBook to load a file. | $ref |
| bookRef2 | The reference to the destination workbook. Please use XL.LoadBook to load a file. | $ref |
| sheetIndex1 | The source index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. | 0 |
| sheetIndex2 | The destination index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. | 0 |
| SourceRow | The source row index. | $srow |
| DestRow | The destination row index. | $drow |
Result
Returns OK or error.
Description
Copies a row from one row to another row.Source and destination can be in different sheets/books.
This copies most properties and all cells.
If something is missing, please let us know.
Examples
Copy row:
# load one from container
Set Variable [$bookRef; Value:MBS( "XL.LoadBook"; XL::ExcelFile)]
# load one from file
Set Variable [$bookRef2; Value:MBS( "XL.LoadBook"; "/Users/cs/Desktop/Format2.xls")]
# copy a row from first sheet. Source row 2 to dest row 10.
Set Variable [$r; Value:MBS( "XL.CopyRow"; $bookRef2; $bookRef; 0; 0; 2; 10 )]
#Save to container and cleanup
Set Field [XL::OutputFile; MBS("XL.Save"; $bookRef; "test.xls")]
Set Variable [$r; Value:MBS( "XL.Book.Release"; $bookRef)]
Set Variable [$r; Value:MBS( "XL.Book.Release"; $bookRef2)]
Set Field [XL::Result; $r]
See also
Created 7th December 2016, last changed 9th December 2016
Feedback: Report problem or ask question.
Links
MBS Xojo Plugins
