Monkeybread Software - MBS FileMaker Plugin: XL.CopyRow

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: 8.0 8.1 8.2 8.3 8.4 8.5 9.0 9.1 9.2 9.3 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 { ; Options } ) More

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

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

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

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.

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

Created 7th December 2016, last changed 31st December 2018

XL.CopyContent - XL.CopySheet