Monkeybread Software - MBS FileMaker Plugin: XL.CopyRow

Topics All MacOS (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Deprecated Guides Examples Videos
New in version: 9.4 9.5 10.0 10.1 10.2 10.3 10.4 10.5 11.0 11.1 Statistic FMM Blog

XL.CopyRow

Copies cells from one row to another row.

Component	Version	macOS	Windows	Linux	Server	FileMaker iOS SDK
XL	6.5	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes

MBS( "XL.CopyRow"; bookRef1; bookRef2; sheetIndex1; sheetIndex2; SourceRow; DestRow { ; Options } ) More

Parameters

Parameter Description Example Flags

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

Options Which items to skip when copying content. "" Optional

Parameter	Description	Example	Flags
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
Options	Which items to skip when copying content.	""	Optional

Result

Returns OK or error.

Description

Copies cells 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.

Option	Description.
SkipPictures	Don't copy pictures.
SkipMerges	Don't copy merged cells.
SkipNamedRanges	Don't copy named ranges.
SkipPrintArea	Don't copy print area.
SkipPrintRepeat	Don'T copy print repeat
SkipPrintFit	Don't copy print fit.
SkipHorPageBreak	Don't copy horizontal page breaks.
SkipComments	Don't copy cell comments.
SkipFormats	Don't copy formats.
SkipRowHidden	Don't copy hidden rows.
SkipColHidden	Don't copy hidden columns.

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]

Blog Entries

Release notes

Version 9.0
- Added options for XL.CopyContent, XL.CopyRow, and XL.CopySheet to skip some content.

Created 7th December 2016, last changed 30th September 2020

XL.CopyContent - XL.CopySheet

Feedback: Report problem or ask question.