C# (CSharp) NPOI.HSSF.Model Sheet.CloneSheet примеры использования

Пример #1

Файл: TestHSSFSheet.cs Проект: thinhmascot/NPOI

        public void TestProtect()
        {
            HSSFWorkbook workbook  = new HSSFWorkbook();
            HSSFSheet    hssfSheet = (HSSFSheet)workbook.CreateSheet();

            NPOI.HSSF.Model.Sheet sheet   = hssfSheet.Sheet;
            ProtectRecord         Protect = sheet.Protect;

            Assert.IsFalse(Protect.Protect);

            // This will tell us that CloneSheet, and by extension,
            // the list forms of CreateSheet leave us with an accessible
            // ProtectRecord.
            hssfSheet.ProtectSheet("secret");
            NPOI.HSSF.Model.Sheet Cloned = sheet.CloneSheet();
            Assert.IsNotNull(Cloned.Protect);
            Assert.IsTrue(hssfSheet.Protect);
        }