BenSelect Documentation
InsertAndCopySheets Method
See Also  Send Feedback
ETI.Report Namespace > ExcelHelper Class : InsertAndCopySheets Method
copyFrom
The sheet index of the sheet we are copying from (1 based). Set it to 0 to insert Empty sheets.
insertBefore
The sheet before which we will insert (1 based). This might be SheetCount+1, to insert at the end of the Workbook.
sheetCount
The number of sheets to insert.
Inserts and copies sheet "CopyFrom", SheetCount times before InsertBefore. To insert empty sheets, set CopyFrom = 0

Syntax

JScript 
public function InsertAndCopySheets( 
   copyFrom : int,
   insertBefore : int,
   sheetCount : int
);

Parameters

copyFrom
The sheet index of the sheet we are copying from (1 based). Set it to 0 to insert Empty sheets.
insertBefore
The sheet before which we will insert (1 based). This might be SheetCount+1, to insert at the end of the Workbook.
sheetCount
The number of sheets to insert.

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2024 All Rights Reserved.