Merge Method

The Merge method combines a worksheet file with the current document. Returns a Boolean.

Syntax

object.Merge( FileName, Row, Col, Options, FileFormat )

 

Parameter	Type	Description
FileName	String	required, data file name
Row	Long	optional, default=-1, row of upper left corner to insert data
Col	Variant	optional, default=-1, column of upper left corner to insert data
Options	String	optional, default=""
FileFormat	wksFileFormat	optional, default=wksFileFormatUnknown

 

Remarks

The contents of the new file are imported into the existing worksheet at the active cell so be sure to position the cell at the edge of the existing data. Any cells in the existing worksheet that lie to the right of and below the active cell are overwritten with the contents of the new importing file.

Example

This example demonstrates how to import and merge a data file with the current worksheet.

Wks.Merge (GrapherApp.Path+"\Samples\bar chart orientations.dat", 32, 2)

 

Used by: Worksheet object