C# (CSharp) Osrs.Oncor.Excel XlWorksheets示例

示例#1

文件： XlWorksheetsTest.cs 项目： OSRS/Oncor_Base

        public void WorksheetFirstDefaultNameTest()
        {
            Color  testColor        = Color.OldLace;
            string expectedName     = "Sheet 1";
            int    expectedTabColor = testColor.ToArgb();

            Osrs.Oncor.Excel.XlColor      tabColor = new Osrs.Oncor.Excel.XlColor(expectedTabColor);
            Osrs.Oncor.Excel.XlWorksheets sheets   = new Osrs.Oncor.Excel.XlWorksheets();
            Osrs.Oncor.Excel.XlWorksheet  sheet    = sheets.AddWorksheet(tabColor);
            string actualName = sheet.Name;

            Assert.AreEqual(expectedName, actualName);
        }

示例#2

文件： XlWorkbook.cs 项目： OSRS/Oncor_Base

 public XlWorkbook()
 {
     Worksheets = new XlWorksheets();
     Properties = new XlCustomProperties();
 }

示例#3

文件： XlWorksheetsTest.cs 项目： OSRS/Oncor_Base

 public void WorksheetsAddOneCountTest()
 {
     Osrs.Oncor.Excel.XlWorksheets sheets = new Osrs.Oncor.Excel.XlWorksheets();
     sheets.AddWorksheet("Sheet 1");
     Assert.AreEqual(sheets.Count, 1);
 }

示例#4

文件： XlWorksheetsTest.cs 项目： OSRS/Oncor_Base

 public void WorksheetsZeroCountTest()
 {
     Osrs.Oncor.Excel.XlWorksheets sheets = new Osrs.Oncor.Excel.XlWorksheets();
     Assert.AreEqual(sheets.Count, 0);
 }