NPOI.XSSF.UserModel.XSSFWorkbook.CloneSheet C# (CSharp) Method

CloneSheet() public method

public CloneSheet ( int sheetNum ) : ISheet
sheetNum int
return ISheet
        public ISheet CloneSheet(int sheetNum)
        {
            ValidateSheetIndex(sheetNum);

            XSSFSheet srcSheet = sheets[sheetNum];
            return srcSheet.CopySheet(srcSheet.SheetName);
        }

Usage Example

コード例 #1
0
        public void Test57165()
        {
            XSSFWorkbook wb = XSSFTestDataSamples.OpenSampleWorkbook("57171_57163_57165.xlsx");

            try
            {
                RemoveAllSheetsBut(3, wb);
                wb.CloneSheet(0); // Throws exception here
                wb.SetSheetName(1, "New Sheet");
                //saveWorkbook(wb, fileName);

                XSSFWorkbook wbBack = XSSFTestDataSamples.WriteOutAndReadBack(wb) as XSSFWorkbook;
                try
                {
                }
                finally
                {
                    wbBack.Close();
                }
            }
            finally
            {
                wb.Close();
            }
        }
All Usage Examples Of NPOI.XSSF.UserModel.XSSFWorkbook::CloneSheet