Move and Copy Sheets SpreadsheetGear API Sample

Worksheet Samples Move and Copy Sheets

Description

Sheets can be moved and copied with ISheet.MoveAfter(...) / MoveBefore(...) and CopyAfter(...) / CopyBefore(...).

Sample Source Code

// Open template workbook
SpreadsheetGear.IWorkbook template = SpreadsheetGear.Factory.GetWorkbook("WorkbookTemplate.xlsx");

// Create a new workbook for final report workbook.
SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook();
            
// Make a copy of template sheet in new workbook and rename sheet.
SpreadsheetGear.IWorksheet newSheet = template.Worksheets["Template Sheet"].CopyAfter(workbook.ActiveWorksheet) as SpreadsheetGear.IWorksheet;
newSheet.Name = "Profit Report";

// Populate new sheet with some test data.
string formula = "=ROUND(RAND()*1000000,2)";
newSheet.Names["NorthProfit"].RefersToRange.Formula = formula;
newSheet.Names["SouthProfit"].RefersToRange.Formula = formula;
newSheet.Names["EastProfit"].RefersToRange.Formula = formula;
newSheet.Names["WestProfit"].RefersToRange.Formula = formula;

// Move the new sheet before the original "Sheet1" that was created.
newSheet.MoveBefore(workbook.Worksheets["Sheet1"]);