NPOI.XSSF.UserModel.XSSFWorkbook.SetSheetName C# (CSharp) Метод

SetSheetName() публичный Метод

public SetSheetName ( int sheetIndex, String sheetname ) : void
sheetIndex int
sheetname String
Результат void
        public void SetSheetName(int sheetIndex, String sheetname)
        {
            ValidateSheetIndex(sheetIndex);
            String oldSheetName = GetSheetName(sheetIndex);

            // YK: Mimic Excel and silently tRuncate sheet names longer than 31 characters
            if (sheetname != null && sheetname.Length > 31) sheetname = sheetname.Substring(0, 31);
            WorkbookUtil.ValidateSheetName(sheetname);

            // Do nothing if no change
            if (sheetname.Equals(oldSheetName)) return;

            // Check it isn't already taken
            if (ContainsSheet(sheetname, sheetIndex))
                throw new ArgumentException("The workbook already contains a sheet of this name");

            // Update references to the name
            XSSFFormulaUtils utils = new XSSFFormulaUtils(this);
            utils.UpdateSheetName(sheetIndex, oldSheetName, sheetname);

            workbook.sheets.GetSheetArray(sheetIndex).name = (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::SetSheetName